CS 1011
Introduction to Computers and Software

Lab 7

Microsoft Access 2002
Project 2
Querying a Database Using the Select Query Window

Due: Wednesday, March 26th

40 points


Assignment

Complete all steps in Project 2 on pages A 2.1 through A 2.42.
To ensure you start with the correct database, the TA will demonstrate and assist you in downloading a correct version of the “Alisa Vending Services” database from the course Web page.

What to Turn In

Turn in all printouts you have been asked to generate during this Project, including:
1. Simple query results on page A 2.11.

Since the project doesn’t ask for any other printouts, please print the query results for the runs asked for on pages:
2. Results of the comparison operator query, run on page A 2.22.
3. Results of the sort on multiple keys query, run on page A 2.28.
4. Results of the use grouping query, run on page A 2.41.

Since you may be changing the underlying tables, go through your text and mark the places you are required to print BEFORE you start this lab, so you don’t forget to do so.

Please pay careful attention to what English language question is being asked for each query. After the query has been run, think about how the results have answered the query.

Please remember that a coversheet is required.