Self-Assessment

 

Skill Level-Beginning Access

Mastered

Needs Work

Required for my job

Create and modify tables

 

 

 

Modify field properties

 

 

 

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

 

 

 

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 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.