This course expands on the Access functions covered in the Introductory and Intermediate courses. The course covers those features to enable the participant to develop major applications and use advanced Access functions.

The course is divided into four main sections: macros, modules, memory variables, programming constructs, applications and debugging tools. Features covered include the Macros mode, Module mode and Access Basic, Menu Builder, if desired. Optional topics may be covered according to the needs of the participants.

This course is intended for those who have taken the Introductory and Intermediate courses, or who have extensive daily experience using Access applications. The class exercises provide "hands-on" experience in using the Access commands. More than 70% of this course is hands-on use of Access.

Objectives:

• Use macros to automate repetitive tasks in Access
• Expand awareness of the programming tools available in Access
• Use Access Basic programming constructs for procedures and User Defined functions
• Use the Access debugging tools and other applications development tools
• Create a custom designed menu using the Menu Builder
• Prepare an Access application for distribution
• Optional topics depending on student needs:
• Networking concepts and programming considerations
• Database Security
• Creating a Data Dictionary