| MOUS Level |
Skill Set |
Activity |
| Expert |
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 a 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 |
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 Lookup 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 |