Skills inventory for Access 2003: Basic

Use the following form to gauge students’ skill level entering the class (students have copies in the introductions of their student manuals). For each skill listed, have students rate their familiarity from 1 to 5, with five being the most familiar. Emphasize that this is not a test. Rather, it’s intended to provide students with an idea of where they’re starting from at the beginning of class. If a student is wholly unfamiliar with all the skills, he or she might not be ready for the class. A student who seems to understand every skill, on the other hand, might need to move on to the next course in the series.

 

Skill

1

2

3

4

5

Identifying database components

 

 

 

 

 

Starting and examining Access

 

 

 

 

 

Opening a database

 

 

 

 

 

Examining the Database window and a database table

 

 

 

 

 

Using the Type a question for help box and the Office Assistant

 

 

 

 

 

Closing a database and Access

 

 

 

 

 

Planning and creating a database

 

 

 

 

 

Examining a table in Datasheet view and Design view

 

 

 

 

 

Creating a table by using the Table Wizard and Design view

 

 

 

 

 

Adding fields to a table, and setting the primary key

 

 

 

 

 

Saving and adding records

 

 

 

 

 

Modifying field names, and deleting and inserting fields

 

 

 

 

 

Finding and replacing values in a table

 

 

 

 

 

Sorting records

 

 

 

 

 

Filtering records

 

 

 

 

 

Setting field properties

 

 

 

 

 

Creating an input mask

 

 

 

 

 

Creating indexes

 

 

 

 

 

Creating queries by using the Simple Query Wizard and Design view

 

 

 

 

 

Sorting and filtering query results

 

 

 

 

 

Adding fields to and removing fields from a query

 

 

 

 

 

Using comparison operators and calculations in a query

 

 

 

 

 

Creating and modifying forms

 

 

 

 

 

Finding, sorting, and filtering records in a form

 

 

 

 

 

Creating reports

 

 

 

 

 

Grouping and summarizing data in a report

 

 

 

 

 

Printing a report