Users with a sound understanding of the four fundamental components of Access, tables, queries, forms and reports and the concepts of relational database design, who now wish to explore some of the more sophisticated functions.

Attendance on the Fundamentals and Intermediate Access courses or commensurate knowledge through experience.

• Multiple Primary Keys & Cascade Relationships

• Unmatched & Duplicate Queries

• Working with CrossTab Queries

• Relationship Joins in Queries

• Calculated Controls on Forms & Reports

• Incorporating Pictures

• Toggle Buttons, Check Boxes & Option Groups on Forms

• List Boxes & Combo Boxes

• Propagate Changes in Field Properties

• Page Tabs on Forms

• Multiple Table Reporting

• Sorting & Grouping on Reports

• Designing & Running Macros & Macro Security

• Macro Command Buttons

• Using Conditions in Macros

• Macros Running Queries & Reports

• AutoExec Macros

• Creating a Switchboard & Menu Forms

• Customising Menus & Toolbars

• Setting Database Startup Defaults

• Form & Report Error Checking Options

• Compacting & Repairing a Database

• Backing Up a Database

• Database Passwords & Multi User Databases

The user will be at a sufficient level of competence to produce quite sophisticated database applications and automate the database through menus, macros and command buttons.