Access 2000: Module II
Course Summary

Lesson 1: Reviewing the Basics

Approximate Time: 45

Exercise File(s) Needed: 2Auto Dealer1.mdb, 2Auto Dealer2.mdb, and 2Auto Dealer3.mdb

Summary of Objectives: Students design databases, examine Access objects, create databases and tables, work with records, work with table structures, locate information, use select queries, create and use forms, create and use reports, and enhance forms and reports

Lesson 2: Creating Relational Databases

Approximate Time: 45

Exercise File(s) Needed: 2Auto Dealer4.mdb, 2Auto Dealer5.mdb, 2College1.mdb, and 2College2.mdb

Summary of Objectives: Students describe table relationships, relate tables, enforce referential integrity, and print table relationships

Lesson 3: Working with Related Tables

Approximate Time: 45

Exercise File(s) Needed: 2Auto Dealer6.mdb, 2College3.mdb, and 2College4.mdb

Summary of Objectives: Students use the Lookup Wizard, modify lookup fields, add data to related tables, and use subdatasheets

Lesson 4: Using Subforms

Approximate Time: 35

Exercise File(s) Needed: 2Auto Dealer7.mdb, 2College5.mdb, and 2College6.mdb

Summary of Objectives: Students create subforms, display information with subforms, and add records to a table using subforms

Lesson 5: Maintaining Data Integrity

Approximate Time: 35

Exercise File(s) Needed: 2Auto Dealer8.mdb, 2College7.mdb, and 2College8.mdb

Summary of Objectives: Students review field properties, use input masks, set required properties, and use validation rules

Productivity Builder 1

Approximate Time: 30

Exercise File(s) Needed: 2Pets1.mdb and 2Pets2.mdb

Lesson 6: Using Advanced Form Features

Approximate Time: 40

Exercise File(s) Needed: 2Auto Dealer9.mdb, 2College9.mdb, 2College10.mdb, 2Truck.bmp, and 2Prof.bmp

Summary of Objectives: Students add pictures to records, use calculated controls, and improve accuracy in forms

Lesson 7: Using Advanced Report Features

Approximate Time: 45

Exercise File(s) Needed: 2Auto Dealer10.mdb, 2College11.mdb, and 2College12.mdb

Summary of Objectives: Students create a report using the Report Wizard, customize headers and footers, concatenate text fields, add calculated values, force pagination, and work with subreports

Lesson 8: Using Advanced Query Features

Approximate Time: 40

Exercise File(s) Needed: 2Auto Dealer11.mdb, 2College13.mdb, and 2College14.mdb

Summary of Objectives: Students join tables in a query, perform calculations in a query, and display special records

Lesson 9: Using Advanced Queries

Approximate Time: 40

Exercise File(s) Needed: 2Auto Dealer12.mdb, 2College15.mdb, and 2College16.mdb

Summary of Objectives: Students use crosstab queries, use parameter queries, use action queries, and optimize queries using indexes

Lesson 10: Working with Charts

Approximate Time: 30

Exercise File(s) Needed: 2Auto Dealer13.mdb, 2College17.mdb, and 2College18.mdb

Summary of Objectives: Students create charts and customize charts

Productivity Builder 2

Approximate Time: 30
Exercise File(s) Needed: 2Pets3.mdb, 2Pets4.mdb, and 2Dog.bmp
Total Exercise File Size for Course: 27 MB
Approximate Length of the Course: 7 hours 40 minutes

Responsibility of the Student

Each student must study all information learned in the course after normal classroom hours so that he/she may gain a firmer grasp of the information covered.

This allows students to detect any weak areas that they may have and enables them to seek out the assistance of the instructor.

Back to Course Outlines