Microsoft Access 2007 Application Development

	This course is intended for those who want to go beyond using the built-in features offered by Access and develop their own applications. The course starts with how to plan an application from the ground up, and how to make use of advanced form design, macros, and dialog boxes. The course also covers creating switchboards, splash screens, custom menu forms, and navigation groups. This course stops short of actual VBA programming, which is covered in Access 2007 VBA Programming.
	Duration: 1.0 day(s) Price: £258.00 + VAT	Download Course Content   Download Course Files

Locations

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

Target Students

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

Prerequisites

Requires completion of Introduction and Intermediate courses or equivalent knowledge.

Delivery Method

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

Certification

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.

Course Objectives

• 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

Course Content

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.