DETERMINATION OF READINESS FOR A COURSE

 

Print this document

MICROSOFT ACCESS

 

These questions are designed for people who have not taken the Access – Level 1 course and think they should start at the Access – Level 2 course (having either been self-taught or using the program, or earlier version, for some time).

CTC Computer Training is dedicated to the highest possible quality of computer instruction. The recommended score at the bottom of the quiz has been carefully calculated to ensure that people attending a higher level course are as prepared as the rest of the people in attendance.

We therefore ask that if your score does not meet the recommended prerequisite score at the bottom of the quiz that you not sign up for the higher level course. Attending a higher course level when you lack the prerequisite skills takes away from the quality of instruction for the rest of the class. Not everyone needs to have the same skill level – just a certain minimum level of preparedness.

 

Please indicate (YES or NO) your ability to perform the following functions using Microsoft Access 2000/2003:

YES

NO

I know the difference between a field and a record.

 

 

I understand the meaning of the expression “primary key”

 

 

I know what an INPUT MASK is (ie, 9999 vs 0000).

 

 

I know what a VALIDATION RULE is.

 

 

I can design an input form and go into Design View and edit components of the form.

 

 

I can create a data table using the DESIGN VIEW.

 

 

I know how to create both AND and OR queries.

 

 

I can print a database in label format.

 

 

I can create a report with field groups.

 

 

I know how to take a report I created, using a Wizard, and fix any problems it has in the report DESIGN VIEW.

 

 

I know what causes a report to print every other page as a blank page - and how to fix it.

 

 

Total ü marks*:

 

 

* Less than 8 ü in the YES column = Level 1 class necessary in order to be adequately prepared for Level 2.