Skills inventory for Access 2003: Intermediate

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

Converting a table to first, second, and third normal forms

 

 

 

 

 

Establishing one-to-one, one-to-many, and many-to-many table relationships

 

 

 

 

 

Planning table relationships

 

 

 

 

 

Working with orphan records

 

 

 

 

 

Setting and testing cascading deletes

 

 

 

 

 

Setting and testing cascading updates

 

 

 

 

 

Creating a Lookup list field

 

 

 

 

 

Modifying a Lookup list field

 

 

 

 

 

Changing a text box control to a combo box control

 

 

 

 

 

Entering data in a related table

 

 

 

 

 

Using Simple Query Wizard and Design view to create joins

 

 

 

 

 

Creating inner and outer joins

 

 

 

 

 

Creating a join with an intermediate table and creating a self-join query

 

 

 

 

 

Finding records that do not match between tables

 

 

 

 

 

Creating a calculated field and modifying the format of a displayed value

 

 

 

 

 

Using the Expression Builder

 

 

 

 

 

Creating a query to display summary values

 

 

 

 

 

Using queries to concatenate values

 

 

 

 

 

Drawing a rectangle around a control

 

 

 

 

 

Changing tab order

 

 

 

 

 

Adding a graphic to a form and embedding graphic in an unbound object frame

 

 

 

 

 

Binding a control to a calculated field

 

 

 

 

 

Creating a calculated field and aligning controls

 

 

 

 

 

Adding a combo box to a form, modifying its properties, and creating an input mask for a combo box

 

 

 

 

 

Adding report headers and report footers

 

 

 

 

 

Applying conditional formatting

 

 

 

 

 

Keeping parts of the report on the same page