Introduction

The skills and knowledge covered in this course are sufficient to automate operations using macros, secure and protect data, and have a general understanding of the programming environment in Microsoft Access 2003.

Prerequisites

This course assumes that you can create a database file, store and manage data. It would also be beneficial to have a general understanding of personal computers and the Windows operating system as you will be requiredto start applications, work with and copy files, and locate file folders.

Outcomes

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

• Split the tables from a database file
• Create and maintain multiple copies of a database file
• Create aggregated queries
• Create a data access page
• Create data access pages using the Design View
• Create a macro for an option group to provide instant filtering
• Write a simple procedure in VBA.