Access Application Writing

Full-day classes are weekdays from 9am to 4pm , unless otherwise specified or requested.

This course is designed to present you with additional capabilities so that you can transform an Access database into an end-user application and experience. You will learn how to provide automatic opening of key forms and switchboards, button production control of forms and reports, along with various possibilities to make the database more user friendly yet powerful. The automation within the database will be made possible largely through the creation of macro objects, custom forms and custom controls.

• Determining User Requirements
• Performance Analyzer
• Advanced Form Functionality
• Combo Boxes
• Calculating from Subform Controls
• Creating Dialog Boxes
• Adding Dialog Box Controls
• Using Macros
• Attaching Macros to Form Events
• Conditional Macros
• Macro Groups
• Setting Form Properties
• Dialog Boxes for Reports
• Creating Custom Switchboards
• Assigning Macros to Switchboards
• Keyboard Shortcut Macros
• Setting Startup Properties
• Database Splitter
• Linked Table Manager
• Compact and Repair a Database
• Protecting Databases
• Replicating and Synchronizing
• Controlling Data Entry