Microsoft Access Advanced

Course Outline:

• 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.

We offer this course Microsoft Accredited, Ask a member of are training team for more information on the Accreditation.