Access 2002: Introduction

Course Specifications:

Courseware: Access 2002: Level 1

Software: Microsoft Office XP Professional

Course length: 1 day

Course times: 8:30 a.m. - 4:30 p.m.

Course Description:

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.

Course Objective:

You will practice the critical skills necessary to create a database and enter, find, edit, and report on the data it contains.

Target Student:

This course targets people 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.

Prerequisites:

To ensure the successful completion of Access 2002 Introduction, we recommend completion of one of the following MicroAssist courses, or equivalent knowledge from another source:

1. Windows 2000 Introduction

Delivery Method:

Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities. Each student is provided with a computer and a Manual. The manual is the student's to keep and makes an excellent reference guide.

Course Content:

Lesson 1: Working with a Relational Database

1. Topic 1A: Identify Uses of a Relational Database
2. Topic 1B: Define Database Terminology
3. Topic 1C: Create a New Database Based on a Template
4. Topic 1D: Examine the New Database

Lesson 2: Planning a Database

1. Topic 2A: Identify Database Purpose
2. Topic 2B: Review Existing Data
3. Topic 2C: Determine Fields
4. Topic 2D: Group Fields into Tables
5. Topic 2E: Normalize the Data
6. Topic 2F: Designate Primary and Foreign Keys
7. Topic 2G: Identify Table Relationships

Lesson 3: Building the Basic Structure

1. Topic 3A: Create a Blank Database
2. Topic 3B: Create a Table using a Wizard
3. Topic 3C: Compare Datasheet and Design Views
4. Topic 3D: Create Tables in Design View
5. Topic 3E: Create Relationships between Tables

Lesson 4: Working with Tables

1. Topic 4A: Modify a Table Design
2. Topic 4B: Work in Datasheet View
3. Topic 4C: Work with Subdatasheets

Lesson 5: Creating and Working with Select Queries

1. Topic 5A: Examine a Query
2. Topic 5B: Create a Query Using a Wizard
3. Topic 5C: Work in Query Design View
4. Topic 5D: Select Records
5. Topic 5E: Edit Values in a Query Datasheet
6. Topic 5F: Add a Calculated Field to a Query
7. Topic 5G: Perform a Calculation for a Group of Records

Lesson 6: Creating and Using Forms

1. Topic 6A: Create AutoForms
2. Topic 6B: Create a Form Using a Wizard
3. Topic 6C: Modify the Design of the Form
4. Topic 6D: Use Forms to Work with Data

Lesson 7: Creating and Using Reports

1. Topic 7A: Create an AutoReport
2. Topic 7B: Create a Report Using a Wizard
3. Topic 7C: Examine a Report in Design View
4. Topic 7D: Create a Calculated Field
5. Topic 7E: Change the Format of a Control
6. Topic 7F: Change the Style of a Report
7. Topic 7G: Adjust Report Width