Home > Training > Microsoft Office 2003

Access 2003 Introduction

Duration
2 days

Course Objectives
Microsoft Access is a powerful and versatile database management tool. By the end of the course, delegates will be able to design and use an Access database by creating tables, queries, forms and reports.

This is a hands-on course containing varied and relevant exercises for delegates to practise and reinforce the techniques learnt.

Outline
Using an Access Database

Using Tables
Moving around a table
Adding, editing and deleting records
Finding and sorting records
Sizing, hiding and showing columns
Printing

Getting Help in Access

Using Forms, Queries and Reports

Creating Tables
The table design window
Data types
Adding and deleting fields
Setting the Primary Key

Creating Forms
Using form wizards
Using the form design view
Manipulating data using the form

Creating Queries
What can you do with queries?
Adding fields to the query grid
Rearranging and deleting fields
Renaming fields in a query
Specifying the sort order
Specifying criteria
- Between, Like, And, Or
Writing expressions
Using the asterisk
Hiding and showing columns

Creating Reports
Single column and tabular reports
Using queries with reports
Groups and total reports
Mailing labels

Table Field Properties
Field size and format
Default values and validation rules
Index property
Other field properties
Specifying lookup values

Filters
Filter by selection
Filter by form
Using and loading advanced filters
When to use filters instead of queries

Improving the Layout of Reports and Forms
Moving, sizing and aligning controls
Adding drawing controls
Adding and deleting labels
Setting the tab order
Inserting pictures and logos

Advanced Queries
Creating parameter queries
Creating calculated fields

Introduction to Multiple Tables
Why use multiple tables?
Table relationships

Assumed Knowledge
Delegates attending this course should be familiar with PCs and have experience of using other Microsoft Office applications, such as Word or Excel. No prior experience of Access is required.

Course Times
10:00am to 5:00pm

Comprehensive course manual included.
Refreshments and lunch are provided on all courses at the Information Horizons Training Centre.

Back to the top