Skill Level-Beginning |
Mastered |
Needs Work |
Required for work |
Create and Modify Tables |
|
|
|
Modify Field Properties |
|
|
|
Add a Primary Key |
|
|
|
Create and modify Queries |
|
|
|
Compact and Repair a database |
|
|
|
Create a Report with the Report Wizard |
|
|
|
Beginning Access is recommended if you selected “needs work” on three or
more skills.
Skill Level-Intermediate |
Mastered |
Needs Work |
Required for work |
Design a Subform |
|
|
|
Link a Form and a Subform |
|
|
|
Create multiple-item Forms |
|
|
|
Make a Switchboard with Command buttons |
|
|
|
Edit the Form Controls to minimize errors |
|
|
|
Create Queries with many Tables |
|
|
|
Intermediate Access is recommended if you selected “needs work” on three
or more skills.
Skill Level-Advanced |
Mastered |
Needs Work |
Required for work |
Use a Query for a List Form |
|
|
|
Change the Default Form View |
|
|
|
Create Synchronized Combo Boxes |
|
|
|
Filter Data with Queries |
|
|
|
Create Action Queries |
|
|
|
Import, Export and Link data |
|
|
|
Advanced Access is recommended if you selected “needs work” on three or
more skills.