Grading Rubric – Access 2007

Chapter 3: Cases and Places Rubrics

 

Case 1:    AC Pg 203

Class:           CIS 5.2

Professor:    Meyer

Hints:

            Part A: pg. 158

            Part B: pg 142-143, 147

            Part C: pg 142-143, 148

            Part D: pg 165-166

            Part E: pg 192, 175

            Part F: pg 185-189 

 

Description

Pts

Part A: Condition field should be a Lookup field.

.5

Part B: The bookcases description should be change to 3-Shelf Bookcase.

.5

Part C: The duvet has been sold and should be deleted from the database.

1

Part D: Minimum price of any item should be changed to $2.00

1

Part E: Default sort order for item table should be changed from item number to description.

 

1

Part F: Referential integrity should be specified

1

TOTAL POSSIBLE POINTS:

5

 

 

YOUR SCORE:  _______________