Grading Rubric – Access 2010

Tutorial 4, Case Problem 3

Class:

Professor:

Notes:

Solution File:Rossi.accdb

Description / Pts / Your Score
DonationInfo form contains all of the fields from the Donation table / 1
DonationInfo form uses the Verve theme and the Columnar layout / 1
DonationInfo form title appears as two words and the font color is Pink, Accent 2, Darker 25% / 1
DonationInfo form title is underlined / 1
The Donation Value field values are left-aligned / 1
The Donation value of the record with Power tools in the donation description field has been changed to 565 / 1
A new record has been added with details as shown here and on Page 209 of the text / 1
DonationID 2150 has been deleted / 1
DonorsAndDonations is a main form including all fields from the donor table / 1
DonationSubform is a subform containing the DonationID, AgencyID, DonationDate, Description, and DonationValue fields from the Donation table / 1
DonationSubform uses the datasheet layout / 1
DonorsAndDonations form uses the Verve theme / 1
DonorsAndDonations title appears as three words on a single line in Pink, Accent 2, Darker 25% font color / 1
Background color for all field value boxes in the main form is Pink, Accent 1, Lighter 80% / 1
The boxes on the main form have a line thickness of 1 pt. / 1
All columns in the subform are sized to their best fit / 1
The Phone field value for DonorID 36062 has been changed to 316-282-2556 / 1
AgenciesAndDonations report includes the Agency and Phone fields from the Agency table, and all fields except AgencyID and Pickup from the Donation table / 1
DonorID has been selected as an additional grouping level / 1
Detail records are sorted in descending order by DonationValue / 1
AgenciesAndDonations report uses the Outline layout and Portrait orientation / 1
AgenciesAndDonations report uses the Verve theme / 1
The report title is fully displayed and appears as three words, using font color Pink, Accent 2, Darker 25% / 1
Donation Description, Donation Date and Donation ID field labels appear as shown and fields are sized to fully display values / 1
The Recycle picture has been inserted to the right of the report title / 1
Conditional formatting has been applied so any Donation value greater than or equal to 200 is bold and in Maroon font color / 1
TOTAL POSSIBLE POINTS: / 26 / 0

YOUR SCORE: ______