Final Database Project Requirements

Final Database Project Requirements - 30%

These are the minimum requirements for your database project which is due Monday, December 5^th 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

Total out of 30