Access - introduction (In-House)

Plan and create a database

Sort and filter records

Use field data types

Work with tables

Create and manage a query

Create and work with forms, and use the form wizard

View, create and print reports

Planning a database

Creating a blank database

Opening an existing database

Security warnings

The navigation pane

Previewing database components

Closing an Access database

Viewing and navigating table data

Navigating using keyboard shortcuts

Editing table data

Adding records to tables

Selecting and deleting records

Finding and replacing data

Filtering tables

Summing table data

Opening a query in datasheet view

Opening a query in design view

Adding fields to a query

Sorting query results

Modifying datasheet view

Saving and closing queries

Working with form data

Sorting records

Filtering records

Working in design and layout views

Changing object attributes

Opening and viewing reports

Viewing a report in design view

Previewing and printing report data

Creating reports with auto report

Creating reports with the report wizard

Changing field attributes

Creating database tables

Creating table fields

Selecting field data types

Introducing relationships

Establishing table relationships

The one-to-many relationship type

Establishing referential integrity

Streamline query criteria using wildcards

Creating summary queries

Creating queries based on criteria

Running date queries

Formatting field properties

Building queries from multiple tables

Summing in queries

Creating a new form

Inserting form fields

Working with the property sheet

The command button wizard

The command button wizard

Programming without typing

Creating forms with embedded sub forms

Creating forms with the sub form wizard

Creating forms with the form wizard

What are report bands?

Managing report controls

Basing reports on multiple tables

Basing reports on queries

Sorting and grouping records