$30.00
Add to Cart
HW-2085 Final Database Project Requirements
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
Total out of 30
Answer will be sent by email as attachment.
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
Total out of 30
Answer will be sent by email as attachment.
