Microsoft Access 2002 Level 1 Course
Course Description
You will practice the critical skills necessary to create a database and enter, find, edit, and report on the data it contains.
This course targets delegates who want to gain the skills necessary to use Access to create a database to hold information on a subject and/or the basic skills needed to maintain and report on data in an Access database.
Course pre-requisites:
Topics covered on the 2 day Microsoft Access 2002 Level 1 course
Working with a Relational Database
- Identify Uses of a Relational Database
- Define Database Terminology
- Create a New Database Based on a Template
- Examine the New Database
Planning a Database
- Identify Database Purpose
- Review Existing Data
- Determine Fields
- Group Fields into Tables
- Normalize the Data
- Designate Primary and Foreign Keys
- Identify Table Relationships
Building the Basic Structure
- Create a Blank Database
- Create a Table using a Wizard
- Compare Datasheet and Design Views
- Create Tables in Design View
- Create Relationships between Tables
Working with Tables
- Modify a Table Design
- Work in Datasheet View
- Work with Subdatasheets
Creating and Working with Select Queries
- Examine a Query
- Create a Query Using a Wizard
- Work in Query Design View
- Select Records
- Edit Values in a Query Datasheet
- Add a Calculated Field to a Query
- Perform a Calculation for a Group of Records
Creating and Using Forms
- Create AutoForms
- Create a Form Using a Wizard
- Modify the Design of the Form
- Use Forms to Work with Data
Creating and Using Reports
- Create an AutoReport
- Create a Report Using a Wizard
- Examine a Report in Design View
- Create a Calculated Field
- Change the Format of a Control
- Change the Style of a Report
- Adjust Report Width
Course Classification:
Applications Training Course
This is an instructor led training course taught in a classroom based environment.
Scheduled course dates
| March 2010 | April 2010 | May 2010 | June 2010 | July 2010 |
| - | - | - | - | - |
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Microsoft Access Training and bespoke Microsoft Access courses
The Microsoft Access 2002 Level 1 course qualifies for the PTR Training Passport SAVE IT Scheme, which offers discounts on bookings for multiple courses and/or multiple delegates.

