Description
Microsoft Access 97 is a relational database management program included with
Microsoft Office 97. The Microsoft Access 97 Microsoft Office Specialist
certificate validates a consultant's skills in using Microsoft Access
97. As a qualitative assessment of a consultant's abilities, the
Microsoft Office Specialist program
offers clients' confidence while choosing a consultant.
The Microsoft Office Specialist Access 97 exam contents and
objectives are provided below. In addition to meeting the Microsoft
Office Specialist
Access 97 certification requirements, Dale Rainwater holds a Microsoft Office
Specialist certification in
Microsoft Access 2002 and Microsoft Access 2000.
The Access 97 Microsoft Office Specialist exam evaluates a candidates skills using an
Access 97 database's tables, forms, queries, reports, and other objects.
Dale Rainwater Consulting offers computing services in New York City, NY
and Northwest Arkansas.
Exam Contents / Objectives
Microsoft
Access 97
 |
Creating a Database
 | Plan a database |
 | Create a table |
 | Enter data into a table |
 | Modify data in a table |
 | Enter data into a form |
 | Navigate through a table |
 | Delete data from a table |
|
 |
Using Forms
 | Create a simple form |
 | Modify a form |
 | Create controls on a form |
 | Modify controls |
 | Add a record using a form |
 | Show related records on a form |
|
 |
Modifying a Database
 | Open a database |
 | Modify field properties |
 | Modify field layout |
 | Modify the presentation of a database |
|
 |
Viewing Information
 | Present information in a chart |
 | View information in a form |
 | View multiple records |
 | Switch between views |
|
 |
Organizing Information
 | Sort data on single fields |
 | Sort data on multiple fields |
|
 |
Locating Information
 | Find a specific record |
 | Create a simple query |
 | Create a query with multiple criteria |
 | Add filters (selection and form) |
 | Remove filters |
|
 |
Refining Results of a Query
 | Add fields to a query |
 | Remove fields from a query |
 | Sort a query |
 | Join tables in a query |
 | Remove joins in a query |
 | Save a query |
|
 |
Analyzing Data
 | Build summary queries |
 | Calculate fields |
 | Set cross-tab queries |
|
 |
Creating Sub Forms
 | Identify appropriate use for sub forms |
 | Add a record with a main form |
 | Add records with sub forms |
 | Merge two tables into a form |
|
 |
Building a Relational Database
 | Identify relationships |
 | Relate tables |
|
 |
Integrating Information from Other Applications
 | Import data |
 | Link data |
 | Add pictures to records |
|
 |
Utilizing Web Capability
 | Create hyperlinks |
 | Build order forms for Internet use |
|
 |
Maintaining Data Integrity
 | Identify criteria for data integrity |
 | Validate text |
 | Set required properties |
 | Set validation rules |
 | Set look up fields |
 | Use expressions in calculated controls |
|
 |
Building a Form for Other Users
 | Title a form |
 | Modify form design |
 | Improve accuracy in forms |
 | Enhance design of a form |
|
 |
Producing Reports
 | Create a report |
 | Modify a report |
 | Label a report |
 | Customize headers and footers |
 | Make a calculation on a report |
 | Group data in a report |
 | Sort data in a report |
 | Add custom pages |
|
 |
Printing
 | Print a report |
 | Print a form |
 | Print the result of a query |
|