Nova Computer Training

New Page 2

 
 

Print this Outline 

Nova Computer Training
space

MS Access: Level 3

space 

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

 

space

Nova Computer Training
2940 Riverside Dr., Ste. 101
Macon GA 31204

Ph: 478.757.0200
Fax: 478.347.3437
Http://www.novatraining.com 
nova@novatraining.com

  

  

 

2940 Riverside Dr., Ste. 101   |   Macon GA 31204   |   Ph: 478.757.0200   |   nova@novatraining.com