Assess Your Skills

Microsoft Access Level 3 Skills Assessment

Read each question below. Being honest with yourself, evaluate your current level of knowledge and experience.

  • Choose “Yes” if you can confidently perform the activity.
  • Check “No” if you can’t perform the activity
  • Check “Unsure” if you don’t understand the questions or only have a vague idea about what’s being asked.
  • After you answer all of the questions, click on the calculate button to receive your score.

Can you confidently:

Yes No Unsure Create a multiple source query?
Yes No Unsure Identify One-to-One, One-to-Many, and Many-to-Many relationships?
Yes No Unsure Enforce referential integrity?
Yes No Unsure Perform Cascade Update and Cascade Delete on related records?
Yes No Unsure Create an Outer join?
Yes No Unsure Perform group (total) calculations on a column?
Yes No Unsure Restrict results of group calculations?
Yes No Unsure Create expressions while grouping?
Yes No Unsure Display the detail data of a Totals query?
Yes No Unsure Create Crosstab calculations?
Yes No Unsure Add row totals?
Yes No Unsure Use grouped Totals queries as a source?
Yes No Unsure Create a query with multiple joins?
Yes No Unsure Create a query that globally updates records?
Yes No Unsure Create a query to append records to another existing table?

 

  Your score:

If your score is 12 or greater, the Level 3 course is probably the best for you. Eleven or fewer? We suggest Level 2.

If you are still unsure about which level of training is best for you, please feel free to give us a call and we can have you talk directly to one of our instructors. You can reach us at 408-261-2600.

 
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600