Grading Rubric – Access 2007
Chapter 2: Cases and Places Rubrics
Case 1 (Page AC 135)
Class: CIS 5.2
Professor: Meyer
Notes: You need the completed “Second hands Goods” database from (which was your Access Chapter 1 Project Assignment AC 71 Project 1) in order to complete this assignment.
Hints: A. Don’t forget about wildcards (* and ?).
B. You will need to use criteria and comparative operators AC94.
C. Total price would be number of items x price.
D. Use a join query using both tables.
E. AC 90
F: AC 95
|
Description |
Pts |
Your Score |
|
Part A: Query should be designed to display the description of all items that contain the word Table. |
.5 |
|
|
Part B: Query should be designed to display the item number, description, and condition of the items that has the earliest posting date. |
.5 |
|
|
Part C: Query should be designed to display the total price of each item for sale and should include the item description and total price. |
1 |
|
|
Part D: Query should be designed to display the seller. |
1 |
|
|
Part E: A parameter query should be created that will allow the user to enter an item description. |
1 |
|
|
Part F: Query should be designed to find all items posted between a particular date. |
1 |
|
|
TOTAL POSSIBLE POINTS: |
5 |
0 |
YOUR SCORE: _______________