Skill Level-Beginning Access |
Mastered |
Needs Work |
Required for my job |
Create and modify tables |
|
|
|
|
|
|
|
Add
a Primary Key |
|
|
|
Create and modify forms |
|
|
|
Create and modify select queries |
|
|
|
Compact and Repair a database |
|
|
|
Create a report with the report wizard |
|
|
|
Modify the report with grouping and sorting |
|
|
|
Beginning Access
is recommended if you selected “needs work” on three or more skills.
Skill Level-Intermediate Access |
Mastered |
Needs Work |
Required for my job |
Design 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 Access |
Mastered |
Needs Work |
Required for my job |
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.