MS Access Database Assignment

I need someone to develop a database based on a design schema I created.

The requirements are listed below and everything has to be built from scratch including any templates.

The specific topic will be disclosed to the tutor selected.

Part 3 – Project Presentation, Hardcopy and Digital Submission
points
Due date is the actual date of the final scheduled for this class it will be on the Monday or Wednesday of finals week
Create the tables, forms, queries, and reports required to implement your design.
1. Submit hardcopy of the following project elements (in this order, stapled together)
a. A brief written description of the project (Word document)
2. Digital copy of your Database (submission location TBA)
3. Present your database to the class
b. One form must contain a data input sub-form
C. One form must contain a minimum of one calculated field
5. Reports:
a. Must have a minimum of 2 reports
b. Must be built off of a query
c. One must be built from a Parameter query
Database Applications
BT 50
6. Macros:
Spring 14
a. Must contain a minimum of one macro
7. Additional Requirements
a. Sub-forms must have properties set so that close and minimize and navigations properties are
cleared
b. Forms must contain custom command buttons for data navigation, data lookup, and form
operations
8. End User Navigation
a. Database must contain one of the following and your database must open to the end User
Navigation
i. Switchboard form
ii. Navigation Forms (new in Access 2010)
Spring 14
BT 50
Database Applications
Database Project
Requirements for the project are as follows:
1. Tables:
a. Must have one many to many relationship Separated by a minimum of one join table
b. All tables must be normalized
C. Supported by a minimum of two dropdown tables
d. Database must contain a minimum of 5 data types
e. Field properties for all fields must be established ,
i. Field size, (must be established in all Fields) and must match in relational tables
ii. Format, (if needed)
iii. Input mask (where needed)
iv. Default value in a minimum of one field in the database)
v. Validation Rule in a minimum of one field in the database)
vi. Validation Text (for the fields with Validation Rules)
2. Relationships:
Relationships must be established and Relationship window organized and saved
a. Must have referential integrity set on a minimum of one relationship
i. Must have cascade update turned on in one of the relationships
3. Queries:
a. Must have a minimum of 2 queries
b. Must contain a Parameter Query
4. Forms:
a. Must have custom data input forms for all tables, Date input Sub-form counts as a custom
data input form