Starting and exiting Access; opening and closing databases; using, opening, and closing database objects; navigating pages

Using and hiding the Assistant, finding an answer, selecting an Assistant, changing Assistant options

Creating a blank database, designing and saving tables, creating tables in Design view, using the Table Design window and the Table Wizard, adding field names and descriptions, assigning data types, setting a primary key

Using Datasheet view; navigating fields in tables; adding, selecting, editing, saving, deleting, and moving through records

Using field properties; limiting field size; setting number, date/time, and yes/no formats; setting default values and validation rules and text

Changing row height, column width, font attributes, and cell effects; selecting, moving, hiding, unhiding, and freezing columns

Sorting records; finding specific records and using wildcards; using Replace, Filter By Selection, Filter Excluding Selection, Filter For, and Filter By Form; applying and removing a filter

Printing table data and selected records, changing page setup

Using related tables, creating a relationship, setting referential integrity, adding a table to the Relationships window

Using queries, RecordSets, and the Simple Query Wizard; creating a query in Design view; opening and running a query; adding a table to a query; joining tables in a query

Sorting and printing a query, adding criteria to and hiding a field in a query, adding a record using a query

Analyzing a table, using relationships in splits and the Table Analyzer Wizard

Using forms, the Form Wizard, and AutoForm; viewing and printing records in a form; basing a form on a query; adding records using a form

Using reports, the Report Wizard, AutoReport, and Print Preview; printing pages of a report; basing a report on a query

Using Help, Contents, the Index, and Find; viewing ScreenTips