Intermediate Microsoft Access

Now that you understand Microsoft Access, students will learn how to make their application more professional. Time saving, data-entry techniques are elaborated. “Goof proofing” your forms will be discussed. This class will touch upon the programming aspects of Microsoft Access.

Beyond the Simple Query

• Parameter Queries
• Crosstab Queries
• Action Queries

Advanced Form Features

• Adding Bound/Unbound Objects
• Adding Combo/List Boxes
• Adding Group Options
• Designing Command Buttons

Custom Reports

• Accessing the Drawing Tools
• Changing Object Properties
• Displaying Choices with Option Groups
• Page Setup

Database Utilities

• Converting a Database
• Compacting Databases
• Linked Table Manager
• Database Splitter
• Securing Your Database