Week 8 Capstone Project Information

Objective: Demonstrate your knowledge of Microsoft Access 2016 by creating a database from scratch. In creating this database, you will analyze and synthesize a combination of database concepts, terms, components, tools, and objects (forms, queries, and reports).

Database Information: Now that you have learned the basics of Microsoft Access and relational databases, you will create your own database from scratch. You may create a database of your books, coupons, comics, music, movies, videogames, household inventory items, etc. This assignment can be fun and useful at the same time!

The database you create is required to have the following objects:

(2) Tables that relate with a primary/foreign key relationship

In each table, create a minimum of 8 fields which use each of the data types in the following list (Short Text, Long Text, Number, Date/Time, Currency, Yes/No, Calculated, and Hyperlink)

In each table, create a minimum of 2 fields that are setup using Lookup Wizard

Create a minimum of 1 Lookup Wizard field that is multivalued

In each table, create a minimum of 3 validation rules

In each table, create a minimum of 20 records

(2) Forms

1 form needs to be created for a table and 1 form needs to be created for a query

(6) Queries

Queries must be different types (e.g., top-down query, parameter query, crosstab, etc.)

1 query needs to have joined tables (2 tables create the query)

2 queries need to have a calculated field

(4) Reports

At least 1 report needs to be created for a table and 1 report needs to be created for the query with joined tables

At least 2 reports need to have a column total

NOTE 1: If you would like to create additional tables with more detailed information, please do so. If you would like to create additional forms, queries, or reports, please do so. Do whatever you need to do in order to create the database but make sure you meet the minimum requirements!

NOTE 2: When creating your objects (forms, queries, and reports) from the supplied data from the imported spreadsheets, it is VERY important that you make the objects user-friendly and professional.

Written Information: When you finish creating the database and the objects, answer the following questions in a minimum of one paragraph (3-5 sentences) each.

Where did the information come from and why did you choose to create this database?

How is this database useful to you?

What types of queries did you use and what question/s did the queries help answer?

What types of reports did you generate and why? Why did you create the total for the report?

Do you think you could share this database with friends or family to help them?

This is an academic assignment, so no “text-talk,” no conversational tone, and ABOVE ALL OTHER THINGS… don’t plagiarize!! Lastly, spell-check and proofread your work! Failure to follow these steps will negatively impact your grade.

Upload your database to the Week 8 Capstone Project Database activity in Week 8 as a Microsoft Access 2016 (.accdb) database using the following naming protocol: LastnameFirstnameWK8Database

Upload your written information to the Week 8 Capstone Project Written Information activity in Week 8 as a Microsoft Word 2016 (.docx) document using the following naming protocol: LastnameFirstnameWK8Explanation

Discuss your plan for the Week 8 Capstone Project.

Tell the class about the type of database you plan on creating and why.

Discuss with the class any challenges you foresee or encountered while working on the project

seen