Beginning (6-8 hours)

• Database Concepts
• Access Basics (Screen, Menu, Help)
• Using the Office Assistant
• Opening/Saving/Closing a File
• Viewing a Table
• Editing a Table
• AutoCorrect and Spell Checking
• Form vs Table View
• Viewing Multiple Tables
• Changing a Table Image
• Sorting
• Printing a View
• Page Setup and Printing
• Creating and Restructuring a Table
• Filtering and Finding Data
• Creating Reports

Intermediate (6-8 hours)

• Importing External Data
• Creating a Primary Key
• Converting Field Types
• Changing Field Sizes
• Custom Display Formats
• Input Masks
• Assigning Captions
• Setting Default values
• Using the Expression Builder
• Creating Validity Rules & Validity Text
• Creating Queries
• Saving/Opening Queries
• Using Wildcards
• Compound Queries
• Creating calculated Fields
• Using Summary Operators
• Querying Multiple Tables
• Action Queries
• Creating Custom Reports
• Saving/Opening Reports
• Creating Custom Forms
• Saving/Opening Forms
• File Management
• Database Properties

Advanced (6-8 hours)

• Creating Indexes
• Parameter Queries
• Crosstab Queries
• Customizing Forms
• Customizing Reports
• Converting Databases
• Compacting/Repairing a Database
• Linked Table Manager
• Splitting a Database
• Switchboard Manager
• Password Protection
• User-Level Security
• Adding/Editing Users/Groups
• Encrypting/Decrypting Databases
• Introduction to Macros
• Customizing Access Defaults
• Customizing/Creating Toolbars
• The Add-in Manager