Note: There may be minor adjustments to the topics covered in class.

9922: MS-Access Level 3

Topics

Lesson 1: Designing Applications
Application Development
Sandbox Mode
Jet 4.0 Service Pack 8
Encryption, Keys, Certificates and Signatures
Understanding Macro Security Settings
How Access Security Features Affect Developers
Changing Security Settings and Enabling and Disabling Sandbox Mode
Examining the Application
Development Process
Determining User Requirements
Designing the Application Interface
Defining the Database Configuration
Previewing an Application
Deciding How to Automate Your Application

Lesson 2: Using Advanced Tools and Controls
Advanced Access Tools
Using the Performance Analyzer
Advanced Controls
Using a Combo Box to Find Records
Using the Combo Box Wizard
Modifying the Combo Box Drop-Down List
Calculating Values from Subform Controls

Lesson 3: Creating Dialog Boxes
Dialog Boxes
Setting Dialog Box Form Properties
Adding Dialog Box Controls
Creating Option Groups
Creating Command Buttons
Specifying Default and Cancel Buttons
Enhancing Dialog Boxes

Lesson 4: Using Macros
Macros
Creating Macros
Attaching Macros to Events in Forms
Using the Macro Builder
Creating Conditional Macros
Creating Macro Groups

Lesson 5: Controlling Data Entry
Controlling Data Entry Using
Property Settings and Macros
Restricting User Access to Fields
Setting the Locked and Enabled Properties
Setting the Tab Stop Property
Setting Form Properties
Setting Form Open Modes
Closing Forms Automatically
Specifying Default Values for Fields
Conditionally Setting the Visible Property

Lesson 6: Using Dialog Boxes to Filter Records in Reports
Filtering Data in Reports
Creating Dialog Boxes for Reports
Modifying Underlying Queries
Modifying Report Properties
Evaluating Dialog Box Functionality
Creating Message Boxes

Lesson 7: Creating Custom Switchboards
Switchboards
Creating Switchboard Forms
Creating Macros for Switchboard Controls
Assigning Macros to Switchboard Controls

Lesson 8: Enhancing Applications
Enhancing Applications to Improve Usability
Creating Keyboard Shortcut Macros
Creating Control Tips and Status Bar Messages
Setting Startup Properties
Creating Modules
Adjusting Objects

Lesson 9: Using Database Utilities
Database Utilities
Using the Database Splitter
Using the Linked Table Manager
The Importance of Compacting and Repairing

Lesson 10: Tailoring Applications for Multiple Users
Applications for Multiple Users
Setting Record Locking
Opening Databases in Exclusive Mode
Setting Database Passwords
User-Level Security
Replication and Synchronization
Replicating Databases
Synchronizing Databases