Course Length: 1 day

Prerequisites:
General knowledge of Windows

Lesson 1: An Overview of Access 2003
Relational Databases
The Access Environment
The Database Environment
Examine an Access Table

Lesson 2: Managing Data
Examine an Access Form
Add and Delete Records
Sort Records
Display Record Sets
Update Records
Run a Report

Lesson 3: Establishing Table Relationships
Identify Table Relationships
Identify Primary and Foreign Keys in the Relationships Window
Working with Subdatasheets

Lesson 4: Querying the Database
The Select Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform a Calculation on a Record Grouping

Lesson 5: Designing Forms
Form Design Guidelines
Create AutoForms
Create a Form Using the Form Wizard
Modify the Design of a Form

Lesson 6: Producing Reports
Create an AutoReport
Create a Report by Using the Wizard
Examine a Report in Design View
Add a Calculated Field to a Report
Modify the Format Properties of a Control
AutoFormat a Report
Adjust the Width of a Report