Updated March 2009
For a C you must have:
- 2 tables with a correctly created relationship
- Tables must be "linked" so data can be entered into both tables from addresses table
- Correct data must be entered from the project webpage
- At least 10 data entries with realistic data
- 3 queries that correctly shape the data
- 3 reports created from the queries
- A form and sub-form so data entry can be entered from one location
For a B you must also have:
- Mailing Labels query
- Mailing Label report
- 7 buttons on your form. 4 that link to your reports, 1 to "find record" and 2 buttons of your choice
For an A you must also have:
- Polished reports that:
- Display all the information clearly
- Removes multiple names
- Consistent formatting between fields
- Sorts the data as described in the query description (or logical sorting when not defined)
- Aligns the text to reduce space ( minimizing printed pages)
Extra Credit (TAG Opportunities)
- Investigate data validation and control data entry (error trap!)
