Course Length: 1 day
Prerequisites: Basic knowledge of Access 2000
Certification: MOUS 2000
Product code: ACCS2KUP3LG

This one day instructor-led course presents the application development concepts of Access 2000. You will be introduced to Access features and the steps required to use the features correctly. The Learning Guide includes an exercise CD containing the exercise files used in class.

What’s in Access 2000: Introduction to Application Development?

This course teaches you how to design Access applications; use tools and controls; create dialog boxes; use macros; control data entry; use dialog boxes to get report criteria; create custom switchboards; create keyboard shortcut macros, control tips, and status bar messages; use database utilities; and protect and replicate databases.

Why do I need Access 2000: Introduction to Application Development?

• Provides skills necessary to become MOUS certified.
• Provides students with an overview of Access 2000 features.
• Provides hands-on experience using Access 2000.

 

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