Access Intermediate Course 2013

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 this course 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 and work with macros in forms

Prerequisites

Microsoft Access 2013 ‐ 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 enquiries@sivatech.co.uk or telephone 01296 717800

Phone: 01296 717800
Fax: 01296 717818
Email: enquiries@sivatech.co.uk