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.