Course Length: 1 day
Prerequisites: Access 2003 Module I & II
Certification: MOUS 2000
Product code: ACCS2KUP1LG

See Dates for this class

This course targets individuals interested in learning the features of Microsoft Access 2003.

What’s in Access 2003 Module III?

Access 2003 Advanced: Introduction to Application Development is a course that presents skills training and assessment for creating applications in Microsoft Access 2003. This course provides competency in designing applications, using advanced tools and controls, creating dialog boxes, using macros, controlling data entry, using dialog boxes to filter records in reports, creating custom switchboards, enhancing applications, using database utilities, and tailoring applications for multiple users.

 

 

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