Microsoft Access Advanced

Overview
A comprehensive course exploring the more advanced features of Access. The course will expand on the basic principles covered in WDR's Access Primary course.
Course objectives
The course is designed to give delegates a better understanding of Access. It concentrates on the features of Access that provide a smoother interface between user and database, in particular, using forms and macros to automate database operations.
By the end of this course you will have learned

• How to use calculations in queries
• How to change a query type and use functions in queries
• How to set defaults for forms; how to design advanced combo and list boxes
• How to use option groups
• How to create a subform
• How to enter expressions in reports
• How to create subtotals
• How to design macros
• How to add macro buttons to forms
• How to group macros
• Conditional macros
• How to assign macros to events
• How to customise toolbars and menus

Who should attend
This course is aimed at users of Access who require a greater knowledge of the application.
Pre-requisites
Knowledge of basic Access operation, as outlined in WDR's Access Primary synopsis.
Course synopsis

• Queries Aggregate queries; using calculations; changing a query type; using functions in queries
• Forms Setting properties for forms; setting defaults for forms; advanced combo and list boxes; use of option groups; calculated controls; creating a main form / subform; linking forms
• Macros Designing macros; macro actions; adding macro buttons to forms; grouping macros; conditional macros; assigning macros to events
• Toolbars and Menus Customising toolbars; creating custom toolbars; customising menus; creating custom menu bars; attaching menus and toolbars to forms; customising startup
• Reports Entering expressions in reports; creating subtotals; using queries to produce reports; adding objects to reports