Module 1: The Fundamentals in access 2002
Introduction to Databases
Starting Access and Opening a Database
Understanding the Access Program Screen
Opening and Modifying Database Objects
Working with Multiple Windows
Tour of a Table
Adding, Editing, and Deleting Records
Tour of a Form
Tour of a Query
Tour of a Report
Previewing and Printing a Database Object
Selecting Data
Cutting, Copying, and Pasting Data
Using the Zoom Box
Closing a Database and Exiting Access

Module 2: Creating and Working with a Database in access 2002
Planning a Database
Creating a Database Using the Database Wizard
Creating a Blank Database
Creating a Table Using the Table Wizard
Modifying a Table and Understanding Data Types
Creating a New Table from Scratch
Creating a Query in Design View
Modifying a Query
Sorting a Query Using Multiple Fields
Developing AND and OR Operators
Creating a Form with the Form Wizard
Creating a Report with the Report Wizard
Database Object Management
File Management
Compacting and Repairing a Database
Converting an Access Database

Module 3: Finding, Filtering, and Formatting Data in access 2002
Finding and Replacing Information
Sorting Records
Filtering by Selection
Filtering by Form
Creating an Advanced Filter
Adjusting Row Height and Column Width
Rearranging Columns
Changing Gridline and Cell Effects
Freezing a Field
Hiding a Column