Jump over the site's main content.

Microsoft Access Self-Assessment Test

  1. Can you open, save and print a data sheet?

  2. Can you enter records?

  3. Can you create a table?

  4. Can you use Table Design View to change properties of controls?

  5. Can you format a data sheet?

  6. Can you sort records?

  7. Can you filter records?

  8. Can you create a query?

  9. Can you use Query Design View to modify existing queries?

  10. Can you use compound criteria in a query?

  11. Can you create calculated fields in a query?

  12. Can you create a form?

  13. Can you move and resize controls in a form?

  14. Can you modify text boxes and tab order in a form?

  15. Can you insert an image in a form?

  16. Can you create a report?

  17. Can you group records in a report?

  18. Can you format a report using Report Design View?

  19. Can you change the sort order in a report?

  20. Can you put formula and calculations in a report?

  21. Can you create mailing labels?

  22. Can you link tables?

  23. Can you base a query upon multiple tables?

  24. Can you create a subform?

  25. Can you record & run a macro?

  26. Can you set up a Lookup column?

  27. Can you create a swichboard?