Advanced Access
For Those who have attended the Intro to Access course and wish to advance their database building skills to include the more advanced features required for developing Access applications.
Aims & Objectives To create a mini application to demonstrate and develop skills and features used in application building.
Pre-requisites A knowledge of the functions and features to do with Table and Form Design covered on the Introduction to Access course will be assumed.  Please check the course contents for the Introduction course on web page www.witham-tec.co.uk/accintro.htm if you are not sure. 
Content Linking Tables
Dynasets and Selection Criteria
Using Calculations in Queries
Advanced Form Design - Combo Boxes, Toggle Buttons, Subforms
Tab Control & Option Groups 
Using Command Buttons to run Macros
Creating Graphs to Display Data
Sorting & Grouping in Reports
Using Expressions in Reports
Automating a Database & Macros
Switchboards & the Autoexec Macro
Concatenation and the Format$ function
Using Collections
Popup forms and Custom Dialogue Boxes
The Calendar Control
Setting permissions and locking records
Conditional Macros
Grouping Macros
Hyperlinks
Security
Duration 2 days