Microsoft Access 2002 Level 1
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
Class Information
Duration: 1 day
Prerequisite: Basic knowledge of the windows environment, basic keyboard skills.
Course Materials: Course manual (084400S3)
Description: This class 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.