Microsoft Access 2002 Level 1
| Duration: | 1 day |
| Prerequisite: | Basic knowledge of the windows environment, basic keyboard skills |
| Course Materials: | Course manual (084400S3) |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| 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. |
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