Microsoft Access 2007 Application Development

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

This course is for people who want to go beyond using the built-in features offered by Access and develop their own applications.

Requires completion of Introduction and Intermediate courses or equivalent knowledge.

This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets. The Microsoft Certified Application Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.

• Designing Applications
• Using Advanced Tools and Controls
• Creating Dialog Boxes
• Controlling Data Entry
• Using Dialog Boxes to Get Report Criteria
• Creating Custom Switchboards
• Enhancing Applications
• Using Database Utilities
• Protecting & Replicating Databases

Lesson 1: Application design

Examining an application.
Planning an application.
Creating a binary executable.

Lesson 2: Advanced form design

Using grouped controls.
Using the Tab control.
Creating subforms.

Lesson 3: Dialog boxes and macros

Working with dialog boxes.
Working with macro groups.
Automating navigation across forms.

Lesson 4: Application navigation

Working with switchboards.
Working with splash screens.

Lesson 5: Custom menus and navigation groups

Custom menu forms.
Custom groups in the Navigation Pane.

Infero Training Ltd is based in the Lace Market in Nottingham. Training courses take place at the following locations including Nottingham, Derby, Loughborough, Mansfield, Chesterfield, Burton-on-Trent, Lincoln, Leicester, Sheffield, Stoke-on-Trent, Tamworth, Wolverhampton, Walsall, Birmingham, Solihul, Coventry, Nuneaton, Peterborough, Grantham.