MOUS Tests: Access 97 Expert

clogo.gif (12135 bytes)

Microsoft Access 97 Expert Exam

This page describes how to prepare for the Microsoft® Office Specialist exam in Microsoft Access 97. There is a single designation level for Microsoft Access 97; users are expected to be able to work with databases in individual and workgroup settings.

There is only one level for Access 97. The table beginning on the following page lists specific activities to attain Expert level status.

If you want to create these types of documents...	Then your goal should be...
Database for individual or small workgroup use	Microsoft Access 97 Expert User

Access 97 Expert Exam Objectives
The table below lists the skill sets and activities performed by individuals identified as Expert Users.

Skill Sets	Activities
Create 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
Use 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
Modify a database	Open a database Modify field properties Modify field layout Modify the presentation of a database
View information	Present information in chart View information in a form View multiple records Switch between views
Organize information	Sort data on single fields Sort data on multiple fields
Locate information	Find a specific record Create a simple query Create a query with multiple criteria Add filters (selection and form) Remove filters
Refine 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
Analyze Data	Build summary queries Calculate fields Set crosstab queries
Create 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
Build a relational database	Identify relationships Relate tables
Integrate information from other applications	Import data Link data Add pictures to records
Utilize web capability	Create hyperlinks Build order forms for Internet use
Maintain data integrity	Identify criteria for data integrity Validate text Set required properties Set validation rules Set look up fields Use expressions in calculated controls
Build a form for other users	Title a form Modify form design Improve accuracy in forms Enhance design of a form
Produce 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
Print	Print a report Print a form Print the result of a query