Final Database Project Requirements - 30%
These are the minimum requirements for your database project which is due Monday, December 5th at 9am. You will need to submit at least 2 files. (If you import/export from or to a file, you must submit this file as well.)
Requirement 1: An Access database file
· 4 tables
o Each has 10-15 records minimum
o Each must have a primary key
o Contain formatting and descriptions when necessary
o Must use at least 3 different data types
o Must be at least 1 one-to-many relationship between tables
· Queries – include the following requirements
o Query types: multitable, sorted, criteria, parameter
o Contain aggregate functions, logical operators, calculated fields, and various comparison operators
o At least one query using Group By
· Custom Form
o Formatted and containing appropriate logo, headers & footers
o Contain a subform
o Contain a calculated control
· Report
o Contain 2-level sort
o Display logo
o Uses conditional formatting
o Only display some fields
· Other options
o To obtain full marks you will need to do another step not listed in the requirements, but that we have studied in class
o Example: import from a file, export to a file, create an HTML document, etc.
o Note – if you import or export from/to a file, you must also submit this file. For example if you import a table from Excel, you must also submit that Excel file.
Requirement 2: A text file
You must submit a text file outlining where in your database each of the requirements can be found. This document can be in point form. There is a partial example below:
Parameter query - in qryCustomerParameter
Aggregate functions - in qrySalesTotals
Logical operators - in qryLargeSalesOrLocal
Calculated field - in qryCustomerNames
Final Database Project Simple Marking Scheme
Table Requirements: 12 Marks
· Table has enough records, data types, and primary key
· 3 marks per table
· Deduct 2 marks for missing/incorrect table relationships
Query Requirements: 9 Marks
· One mark each for: multitable, sorted, criteria, parameter, aggregate, logical, calculated, comparison, and group by.
· Requirements can be combined into queries (i.e. a multitable sorted query)
Form Requirements: 4 Marks
· Style
· Logo, header/footer
· Subform
· Calculated Control
Report Requirements: 4 Marks
· 2 level sort
· Logo
· Conditional formatting
· Only some fields displayed
Bonus Requirement: 1 Mark
