Microsoft Access 2010 Intermediate Course


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.

Course Outcomes

At the completion of Microsoft Access 2010Level you should 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
  • modify and adapt an existing form according to specific needs
  • create and use macros in Access
  • work with a number of macro techniques
  • create macros on forms

Target Audience

Microsoft Access 2010 Level 2 is designed for users who have an understanding of how
tables are created, records are entered, modified and deleted, and how simple queries,
reports and forms are created.


Microsoft Access 2010 Level 2 assumes some knowledge of the software to create basic
databases and generate reports. It would be beneficial to have a general understanding of
personal computers and the Windows operating system environment.

Download Course details – Click Here

For more information or to book your place on a course please contact Claire Graham at or telephone 01296 717800

Phone: 01296 717800
Fax: 01296 717818