Introduction

The skills and knowledge covered in this course are sufficient to sort, filter, and query data, to validate data prior to data entry, and to build a small menu system to manage a database.

Prerequisites

This course assumes a basic knowledge ofMicrosoft Access 2003, especially building a database file and data tables. It would also be beneficial to have a general understanding of personal computers and the Windows operating system as you will be required to start applications, work with and copy files, and locate file folders.

Outcomes

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

• Sort and filter data in a table
• Format data in tables
• Use a range of data validation techniques to protect data integrity
• Export records from Access
• Export records to HTML for use on theWeb
• Add parameters to queries to capture criteria data
• Protect your database files against unauthorised access.