Test Center

It is easy to see the newest titles that have been added to the test library. Go to the Test Center and click "View All Free Tests". The list will include the latest tests. Come see what is new and measure your skills!

MS Access 97 Programming


Our MS Access 97 Programming test measures your knowledge of database development using MS Access 97. Designed for experienced programmers, this test covers the following topics: Controls, Database Design, Deployment, Forms, Macros, Multi-User Applications, Queries, Replication, Reports, Tables, and VBA.

This test is associated with a Job Role. Please visit the Job Role Center for more details.

Sample Test

Once you request a test, your Personal Identification Number (PIN) will be stored in your My Plan for easy access. You will have 90 days in which to take the test you requested.

Test Outline

Database Application Design
Basic Form Design
Control Types
Data Types
Field Properties
Use/Limits of Macros
Forms and Controls
Control Events
Control Properties
Form Events
Form Properties
Multi-User Applications
Basic Methods of Replication
Client-Server Applications
Form Data Sources
Linked Tables
Locking Conflicts
Platform Types
Replication Procedures and Techniques
Replication Topology
Splitting Databases
Web Techniques
Queries and Reports
Advance Querying
Basic Queries
Basic Report Design
Optimization for Speed
Pass-Through Queries
Report Events and Properties
Advanced Coding
Control Referencing
Controlling Forms and Reports
Data Manipulation
Macro Commands
Module Scope
Object-Oriented Coding