Skills inventory for Access 2003: Advanced

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

Discusssing and examining the SQL statements in Access

 

 

 

 

 

Writing SQL statements

 

 

 

 

 

Attaching SQL queries to a control in a form

 

 

 

 

 

Viewing a crosstab query and using the Crosstab Query Wizard

 

 

 

 

 

Creating single-criterion and multiple-criteria parameter queries

 

 

 

 

 

Using action queries to append, delete, and modify records in tables and to create a new table

 

 

 

 

 

Creating and running macros

 

 

 

 

 

Attaching macros to the events of forms and to the command button

 

 

 

 

 

Using macros to resize and move forms

 

 

 

 

 

Creating data-validation, data-entry, and user-decision macros

 

 

 

 

 

Creating macros that run a parameter query

 

 

 

 

 

Creating AutoKeys and AutoExec macros

 

 

 

 

 

Creating macros for data transfer between Access and other applications

 

 

 

 

 

Importing objects form an Access database and a spreadsheet

 

 

 

 

 

Exporting objects to another Access database

 

 

 

 

 

Exporting and importing XML documents

 

 

 

 

 

Linking database objects and updating the links

 

 

 

 

 

Using Windows SharePoint Services

 

 

 

 

 

Analyzing database performance

 

 

 

 

 

Splitting, compacting, repairing, and backing up a database

 

 

 

 

 

Replicating and synchronizing databases

 

 

 

 

 

Assigning and removing a password from a database

 

 

 

 

 

Encrypting and decrypting a database

 

 

 

 

 

Using the Security Wizard to create user groups and to specify permissions on a database and objects