Introduction

The skills and knowledge acquired in Microsoft Access 2007 Level 3 are sufficient to automate operations using macros, secure and protect data, and have a general understanding of the programming environment in Microsoft Access 2007.
This publication is primarily designed for people who need to know how to automate operations in Microsoft Access 2007. It is ideal for people who working in offices, clubs, or for home use.

Outcomes

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

• design a relational database project
• create a relational database file with multiple tables
• set table relationships and join tables together
• create queries based on one or more tables
• create and work with aggregation queries
• create and use a series of action queries
• work with a number of macro techniques
• create some simple programming code using VBA