Microsoft Access 2003, 2007, XP Overview

Course contents

The Access Environment
Introduction to database terminology
Starting Access and opening a database
Database objects
Navigation Pane
The Quick Access toolbar and adding additional database commands
Security warnings and Online Help
The Office Button - saving database in compatible formats
Creating New Databases and Tables
Planning a new database
Creating a new database
Creating a database table using the Microsoft Templates
Creating a database table in Design View
Setting field properties
Setting up primary keys
Moving around a table and entering data
Copying, moving and deleting data
Locating, sorting and filtering data
Using the LookUp Wizard to link tables

Designing Forms
Why create a form?
Types of form in the Create ribbon
Using AutoFormat
Using the Form Wizard
Changing forms in Design View
The Form Design Tools ribbon
Adding fields to forms
Form and Control properties

 
Using Select Queries
What is a query?
The Create Ribbon
Creating a query using the Wizard
Creating a query in Design View
Saving and printing queries
Queries with multiple tables
Calculations and summaries in queries
 
Reporting
Printing from Datasheet view
Report Layout Tools ribbons
Using AutoReport
Using Report Wizards
Label reports
Modifying reports in Design View