Introduction

The skills and knowledge covered in this course are sufficient to create robust relational database systems in Microsoft Access, enter, edit and delete data in database files, produce information in forms and reports, and generate queries on the data
Microsoft Access 2007 Level 1 is designed for people who need to know how to create effective databases and to manipulate data to provide viable information.

Outcomes

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

• understand how Access is used and how to navigate around it
• design a database with lookup tables
• create a database structure using Access 2007
• modify the structure of an existing table
• add records to a new table
• add transactional records to a lookup database
• work with the records in a database table
• sort and filter records in a table
• create simple and effective queries
• create meaningful reports from tables
• create and use a variety of forms