On this Microsoft Access 2007 training course you will learn basic functions and features of Microsoft Access 2007. You will learn to create databases, work with tables, fields, and records, sort and filter data, create queries, forms, and reports.

Target audience

You should be comfortable using a personal computer and Windows XP or later. You will get the most out of this course if your goal is to become proficient using the features of Microsoft Access, including the tables, forms, reports, and filters.

Course prerequisites

Before taking this course, you should be familiar with personal computers and the use of a keyboard and a mouse. Furthermore, this course assumes that you've completed the Windows XP: Basic course (or Windows Vista: Basic) or have equivalent experience

Course contents

Getting started

• Database concepts
• Exploring the Access environment
• Getting help

 Databases and tables

• Planning and designing databases
• Exploring tables
• Creating tables
• Changing the design of a table
• Finding and editing records
• Organizing records

 Data entry

• Setting field properties
• Working with input masks
• Setting validation rules

 Basic queries

• Creating and using queries
• Modifying query results and queries
• Performing operations in queries

 Using forms

• Creating forms
• Using Design view
• Sorting and filtering records

 Working with reports

• Reports
• Modifying and printing reports