|
Lesson 1: Designing
Applications
Examining the Application
Development Process
Previewing an Existing Application
Deciding Where to Automate Your Application
Lesson 2: Using Advanced
Tools and Controls
Using the Performance Analyzer
Using a Combo box to Find Records
Calculating Values from Subform Controls
Lesson 3: Creating Dialog
Boxes
Setting Dialog Box Form
Properties
Adding Dialog Box Controls
Enhancing Dialog Boxes
Lesson 4: Using Macros
Creating Macros
Attaching Macros to Events on Forms
Using the Macro Builder
Creating Conditional Macros
Creating Macro Groups
Lesson 5: Controlling
Data Entry
Restricting User Access to Fields
Setting Form Properties
Setting the Open Mode
Closing Forms Automatically
Specifying Default Values for Fields
Conditionally Setting the Visible Property
Lesson 6: Using Dialog
Boxes to Get Report Criteria
Creating a Dialog Box for a
Report
Modifying Underlying Queries
Modifying Reports
Testing and Refining Dialog Boxes
Lesson 7: Creating Custom
Switchboards
Creating Switchboard Forms
Creating Macros for Switchboard Controls
Assigning Macros to Switchboard Controls
Lesson 8: Enhancing
Applications
Creating Keyboard Shortcut Macros
Creating Control Tips and Status Bar Messages
Setting Startup Properties
Adjusting Objects and Viewing Enhancements
Lesson 9: Using Database
Utilities
Using the Database Splitter
Using the Linked Table Manager
Compacting and Repairing a Database
Converting a Database to a Previous Version
Backing Up and Restoring a Database
Lesson 10: Protecting and
Replicating Databases
Setting Record Locking
Opening Databases in Exclusive Mode
Using Database Passwords
Encrypting and Decrypting Databases
Replicating and Synchronizing Databases
|