Access 2002 Introduction

1 day

Overview

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 start creating databases in Access and working with data using tables, queries, forms, and reports.

Prerequisites

Windows Introduction or equivalent knowledge.

Benefits

Access, like other relational database management systems, is not easy to learn on your own. There are concepts and theories about relational databases that are essential to working with these data repositories. Even if you will only be using a database created by someone else, understanding how a database is designed and structured will make your work easier and help you troubleshoot any data problems you might encounter. Almost all users of Access need to create queries, forms, or reports, and this course will get you started.

Target student

People who want to use Access to create a database to hold information on a subject, and/or want to learn the basic skills needed to maintain and report on data in an Access database.

What's next

Access 2002 Introduction is the first course in this series. Access 2002 Intermediate, the next course in this series, teaches students how to enhance their database designs. Students who want to learn advanced features can take the third course in this series, Access 2002 Advanced. In that course, students learn to create advanced queries, create more efficient forms and reports, and work with macros. The final course in this series, Access 2002 VBA Programming, teaches students to create custom applications.

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