Access 2002 : Level 1

Course Description
Overview:  Students will be able to create databases in Access and work with the data by using tables, queries, forms, and reports.  

Prerequisites: Windows 2000: Introduction or equivalent knowledge.

Performance-Based Objectives
Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

• define the purpose of and terminology associated with a relational database and Access objects.
• follow the steps required to properly design a database.
• create tables to hold data and then establish table relationships.
• modify the design of and work with data in tables.
• create, modify the design of, and work with select queries.
• create and modify forms to work with your data.
• create and modify reports to select, organize, and print data.

Course Content

Lesson 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

Lesson 2: 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

Lesson 3: Building the Basic Structure
         Create a Blank Database
         Create a Table using a Wizard
         Compare Datasheet and Design View
         Create Tables in Design View
         Create Relationships between Tables

Lesson 4: Working with Tables
         Modify a Table Design
         TopWork in Datasheet View
         Work with Subdatasheets

Lesson 5: 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

Lesson 6: Creating and Using Forms
         Create AutoForms
         To Create a Form Using a Wizard
         Modify the Design of the Form
         Use Forms to Work with Data

Lesson 7: 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