APPLICATION DEVELOPMENT USING MICROSOFT ACCESS

This five day instructor led course teaches application developers and business-productivity users how to create applications using Microsoft Access 97/2000

Overview of Microsoft Access

• What you can do with Microsoft Access
• What is Microsoft Access
• Microsoft Access Components
• Lab
• User interface
• Sources of help
• Components of Microsoft Access

Application Design Process

• Developing the database strategy
• Developing the database design
• Determining the queries, forms and reports
• Lab
• Determining other application com¬ponents

Designing and Creating Tables

• Creating tables
• Using the table wizards
• Setting field and table properties
• Creating input masks for data entry
• Lab
• The Access primary key
• Indexes and their uses
• Setting relationships between tables

Adding and Editing Data

• Methods of adding and editing data
• Lab
• Using existing data

Building Queries

• Query Basics
• Types of queries
• Designing select queries
• Creating multiple table queries
• Lab
• Types of joins
• Setting query properties

Designing and Creating Forms

• Form basics
• Designing and creating forms without form wizards
• The toolbox
• Form properties
• Control types and properties
• Using expressions in forms
• Creating sub-forms and forms
• Lab
• Displaying and filtering information
• Reusing forms and printing forms

Creating Reports

• Report basics
• Creating reports without report wizards
• Lab
• Using report wizards
• Saving and printing reports
• Creating reports

Automating with Macros

• Macros basics
• Creating and editing macros
• Running macros
• Testing and troubleshooting macros
• Lab
• Creating macro groups
• Creating an AutoKeys macro
• Using macros in forms

Rolling Out an Application

• Considerations for rolling out applications
• Navigational devices
• Creating a main form
• Creating a main menu or switchboard
• Lab
• Controlling the application startup
• Distributing upgraded versions of an application
• Setting database options
• Security issues

Administration

• Compacting a database
• Repairing and Backing up a database
• Documenting the database
• Using the add-in manager

Inclusive to the overall costs of this Microsoft training course is equipment, training material, lunch and refreshments.