Access Database

Final Project Grading Rubric

Course: IT163 Unit: 10 Points: 150

Copyright Kaplan University

Final Project Outcomes addressed in this Assignment:

• Develop a relational database Course outcome:

• IT163-2: Create relational databases with multiple tables. Household Inventory Database Scenario You have all seen or read the various reports over the years about how devastating a natural disaster can be; whether it be a hurricane, flood, fire, earthquake, or tornado, the results are devastating. Creating a home inventory is important and can be used to help you reclaim what may be lost in a natural disaster. For this Final Project you will be designing and developing a Household Inventory Database (HID). You will be creating tables, relationships, queries, forms, and reports. You will be evaluated and graded on each area of your database as shown in the grading rubric that is located on the last page of this Assignment. Deliverables You will submit one (1) database to the Final Project Dropbox no later than 11:59 p.m. ET on Tuesday. Please ensure you name your database: Final_Project_Lastname.accdb Step 1: Create Two Tables Ensure you name your tables as shown Table One: Manufacturer Info Manufacturer ID Primary Key: Autonumber Manufacturer Text Field Address Line 1 Text Address Line 2 Text City Text State Text Zip Text – format as Zip Code Phone number Text – Format at US

phone number Manufacturer URL Hyperlink

Final Project Grading Rubric

Course: IT163 Unit: 10 Points: 150

Copyright Kaplan University

Table Two: Inventory Item Serial Number Primary Key: Text Field Item Text Field Manufacturer ID Lookup Field (Manufacturer Table – select by

name) Description Memo Field Condition Lookup Field (Excellent, Good, Fair, etc.) Date of Purchase Date Field (short date M/DD/YYYY) Purchase Price Currency Field Location Lookup Field (rooms in your house) Model Text Field Warranty (Yes/No) Purchased New Yes/No Field Replacement Time Text Field (Note: this is your best guess

when the item might need to be replaced.) Note: Location areas to include Living room – Kitchen – Office – Bedroom - Garage Feel free to include other rooms as you need. However, those four should be included and have items in those locations. Step 2: Create a Form for BOTH Tables (These forms will be used for data entry).

1. Create a form for the Manufacturer Info by selecting an AutoFormat and modify the form to make it user-friendly by adding a descriptive title. You can also modify the actual form layout if you like as well.

a. Save the form as: My Manufacturer Form 2. Enter at least 5 records. 3. Create a form for the Inventory Items by selecting an AutoFormat and modify the form to make it user-

friendly by adding a descriptive title. You can also modify the actual form layout if you like as well. a. Save the form as: My Inventory Form

4. Enter at least 20 records. Make sure you have items in each of the rooms of your house. This will be important for the queries and report you will design.

Step 3: Creating Relationships

1. The relationship is AUTOMATICALLY created when you created the lookup for the manufacture ID in the Inventory Items table. Go to the Relationships to verify.

Final Project Grading Rubric

Course: IT163 Unit: 10 Points: 150

Copyright Kaplan University

Step 4: Creating Queries After you have completed entering in all the data you will need to select and retrieve the data in a variety of ways. The query object provides you with a way to select data that meets the criteria you will set.

1. Use the Create Tab and select “Query Wizard.” Create a simple query that selects item, manufacturer, Model, Serial Number, and location.

a. Save the query as: Room Items 2. In design view, add the Condition field to the query. Add a Selection Criteria to the Location field so that

only those records with the Location equal to “Living Room” are displayed. a. Save the query as: Living Room Items

3. Create a query that selects the item’s purchase price and serial number a. Save the query as: Item Price

Step 5: Create a Report Create a report that will allow you to have a record of your inventory that includes only the following: Item, Manufacturer, Model, and Purchase Price.

1. Use the Report Wizard to create the report. 2. Modify the design so that the title is “Inventory Report” and all data and labels are sized appropriately. 3. Add totals by room and a grand total to the report and add labels to the totals.

a. Save the report as: Inventory Report Directions for Submitting Your Final Project: After you have completed your Final Project, please upload your work to the Unit 10: Final Project Dropbox by 11:59 p.m. ET on Tuesday night. Review the grading rubric below before beginning this Assignment. Final Project grading rubric =150 points

Final Project Requirements Points Possible Points Earned

Step 1: Create Two Tables: Inventory Item and Manufacturer Info.

0–30

Step 2: Create Forms that are user-friendly.

0–40

Step 3: Relationship created by Manufacturer ID Lookup field in Inventory Items

0–5

Final Project Grading Rubric

Course: IT163 Unit: 10 Points: 150

Copyright Kaplan University

Step 4: Create Three Queries: Room Items, Living Room Items, and Item Price.

0–60

Step 5: Create a Report that will allow you to have a record of your inventory that includes only the following: Item, Manufacturer, Model, and Purchase Price.

0–20

Total (Sum of all points)

0–150