Instructions

If you need to review, watch the Module 3 Reference videos and Access Basics Part 1 (Links to an external site.)Links to an external site.and Part 2 (Links to an external site.)Links to an external site..

Make sure you've entered several records into each of the tables you created in Assignment 2. Just make up the data for the records - it doesn't matter what you enter as long as it makes sense. You won't be able to see the results of your queries until you've entered records into the tables.

Complete the following online course:

Introduction to queries (Access basics, part 3, all 5 videos) (Links to an external site.)Links to an external site.

Create and save the following queries in your database:

The customers that have a fax number.

The employees that report to person X.

The license plates of the cars that are not assigned to an employee.

All customers that placed an order in October.

The top selling product in October.

Turn-in

Attach and submit your updated CustomerPhones.accdb database file.