Microsoft Training: Microsoft Access 2002 Level 1 Course

- this course is no longer scheduled to run. Please refer to schedule for current course titles.

This course is for the new user of Access and assumes no experience with relational databases. The topics cover the critical skills you need to get started creating databases in Access and working with the data by using tables, queries, forms, and reports.

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.

To ensure your success, we recommend you are familiar with the basics of using Windows.

This course is rated as a Fundamentals Course, suitable for accomplished computer users.

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

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

If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.

PTR Associates Limited

21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk

Microsoft Courses:Microsoft Access 2002 Level 1 Training Course

Microsoft Access 2002 Level 1 Course