Microsoft Access 2003 – Beginning (6-8 hours)
- Database Concepts
- Access Basics (Screen, Menu, Help)
- 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
Microsoft Access 2003 – Intermediate (6-8 hours)
- Importing External Data
- Importing Spreadsheets
- Publishing a Database Object
- Creating a Primary Key
- Converting Field Types
- Changing Field Sizes
- Custom Display Formats
- Input Masks
- Using the Lookup Wizard
- Assigning Captions
- Setting Default values
- Using the Expression Builder
- Creating Validity Rules & Text
- Creating Queries
- Saving/Opening Queries
- Using Wildcards
- Compound Queries
- Creating calculated Controls
- Using Summary Operators
- Querying Multiple Tables
- Action Queries
- Creating Permanent Relationships
- Enforcing Referential Integrity
- Creating Custom Reports
- Saving/Opening Reports
- Creating Custom Forms
- Saving/Opening/Printing Forms
- File Management
- Database Properties
Microsoft Access 2003 – Advanced (6-8 hours)
- Creating Indexes
- Parameter Queries
- Crosstab Queries
- Customizing Forms
- Customizing Reports
- Backing Up/Restoring
- Converting Databases
- Compacting/Repairing a Database
- Linked Table Manager
- Splitting a Database
- Switchboard Manager
- Startup Options
- Upsizing Wizard
- Password Protection
- User-Level Security
- Adding/Editing Users/Groups
- Encrypting/Decrypting Databases
- Introduction to Macros
- Customizing Access Defaults
- Customizing/Creating Toolbars
- Data Access Pages
- The Add-in Manager