ACCESS 2007 Level 2 (Creating Smarter Databases)


The aim of this course is to build on the introductory skills of Level 1. The student learns how to ensure that data is entered correctly, how to create more sophisticated and complex queries, and is introduced to some basic automation techniques involving macros. Microsoft Access 2007 Level 2, is designed for users who have an understanding of how tables are created, records are entered, modified, and delete, and how simple queries, reports and forms are created.


At the completion of this course, participants will be able to:

  • use various data validation features in Access to protect data
  • format the data in a table
  • perform more advanced queries using a variety of querying techniques
  • create and use parameter queries
  • create calculated queries
  • create and use macros in Access
  • work with a number of macro techniques
  • create macros on forms.

On-Site Training

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.

User Reviews

Good Stuff (Rating based on 3 reviews)

of respondents recommend this course to a friend.

Click here to Read Reviews

Course Info

Next Step

Enquire Now
Tell a Friend
Email Course Outline

Course files