Access Midterm--Design A Database

Due May 10, 2021 by 11:59pm
Points 200
Submitting a text entry box or a file upload

Design Your Own Database

GCF Review--Database Design (Tips for Designing A Database) Links to an external site.

BA110 Midterm Project

Total Points Possible: 200 pts

Data File
A new Access database file saved as Midterm Project_xx. (use your initials on the end)

Overview
This Midterm Project requires the student to create a new database file (must be an original) that includes concepts presented so far in this course (see Minimum Requirements section below).

Do NOT to use any of the database files or examples provided in the prior assignments. Database templates cannot be used either for this project.

Review the GCF video on how to design databases.

Data Ideas
Ideas for data include information that relates to your job, a hobby or sport, a home business, inventories or any other topic of interest—as long as the database is an original file created by the student. (The file properties will be checked for date creation and “author.”)

Minimum Requirements

The database file must consist of the following objects, which you have practiced in prior weeks.

Two Tables
- Primary Key and Foreign Key Table Joined Correctly Through Table Relationships
- Each table must have at least 15 records.
- One filter applied on table.
One Select Query
- Select query pull criteria based on criteria entered
- Example, find all people in the city of Pendleton)
One And Query, Both Criteria Are True
One Wildcard Query, Review Various Wildcards, Create a Query Using One Not Used Prior
One Split Form
- Including a Logo Graphic
- Custom Design of Fields and Layout (Shorter Field Boxes, Etc.)
Two Reports (Formatted Professionally) One Report needs to Group on one Field.
One Exported File to Excel
One Exported PDF File.
One Word document stating purpose of database and potential additional objects that might be added for future use.