Week

Topic

1

Class Introduction

Creating a database

      Part 1 - Introduction to database concepts

2

Quiz #1 – Tutorial 1

Creating a database

      Part 2 – Copying records from another Access database

3

Building a database and defining table relationships
      Part 1 – Guidelines for designing a database

4

5

Quiz #2 – Tutorial 2

Building a database and defining table relationships
      Part 2 – Adding records to a new table

Maintaining and querying a database

      Part 1 – Updating a database

6

Quiz #3 – Tutorial 3

Maintaining and querying a database

      Part 2 – Defining record selection criteria for queries

7

Creating Forms and Reports

      Part 1 - Creating forms using a form wizard

8

Quiz #4 – Tutorial 4

Creating Forms and Reports

      Part 2 - Creating a form with a Main Form and a Subform

9

Final Exam