Microsoft Access 2003, 2007, XP Introduction

Course contents

The Access Environment
Introduction to database terminology
Starting Access and opening a database
Database objects
Navigating around the ribbons
The Office button - trusted settings
The Quick Access toolbar
Adding extra database commands
Security warnings and online Help
Using Database Tables
Opening a table in datasheet view
The navigation pane
Moving around a table and entering data copying,
moving and deleting data
Undoing changes
Changing the layout and appearance of the data sheet
Finding and sorting data
Filtering data by selection
Filtering data by form
Saving a filter as a query
Creating New Databases and Tables
Planning a new database
Creating a new database
Creating a database table
Setting default formats
The input mask
Setting default values for new records
Validating data entry
Setting up primary keys and indexing fields
Saving and modifying table structures
Using the lookup wizard
Setting relationships between tables
Referential integrity
Inserting subdatasheets
Designing Forms
Why create a form?
The Create ribbon
Types of form
Using AutoForm and the Form Wizard
Changing forms in design view
Adding fields to forms
Creating forms based on multiple tables
Changing subforms
Form and control properties
Form design menus
Setting filters on forms
Adding command buttons and other control objects on forms
 
Using Select Queries
What is a query?
The simple Query Wizard
Find Duplicates Query Wizard
Creating a query in Design View
Saving and printing queries
Queries with multiple tables
Joining tables in a query
Calculations and summaries in queries
Using queries in forms and reports
Reporting
Why design a report?
The Report Layout Tools ribbon
Using AutoReport
Using Report Wizards
Modifying reports in Design View
Sorting and grouping data
Some report and section properties
Mailing labels
Merge It with Microsoft Word