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.