Home inventory database
Create a home inventory database that can be referred to in
case of damage, theft, or natural disaster. You’ll assume the role of homeowner, who over time
has acquired many valuable assets. You would like to more easily manage purchase history,
product serial and model numbers, warranties, and appraisal information. For this project, you
must create an Access database with forms, queries, and reports that you’ll store off site in case
of emergency.
Note: If you have more than 10 attachments, you’ll need to WinZip all of the project’s
associated files along with all documentation using the WinZip software program.
Instructions
Create a Database
1. Start Access and create a Blank database, naming it “Inventory.”
2. On the Home tab, select View and then go to Design.
3. When prompted, name the new table “Inventory.”
4. In Design view, change the field name ‘ID’ to ‘Item ID’ and verify that it’s data type
AutoNumber and has been selected as the primary key.
5. In Design view, add the remaining fields and corresponding data types:
Field Name Data Type Description
Item Name Short Text
Category Short Text Appliances, Electronics, Jewelry,
Other
Manufacturer Short Text
Model Short Text
Serial Number Short Text
Purchase Date Date/Time (Short Date)
Purchase Price Currency
Merchant ID Number
Online Purchase Yes/No
Credit Card Purchase Yes/No
Warranty Type Short Text Store, Manufacturer, Other
Warranty Length Short Text
Repair Yes/No
Repair Date Date/Time (Short Date)
Comments Short Text
6. Save and then close the Inventory table.
7. Create a second table in Design view. Name the table “Merchants.”
8. Add the following fields and corresponding data types. Be sure Merchant ID is the
primary key:
Field Name Data Type Description
Merchant ID AutoNumber
Merchant Name Short Text
Address Short Text
City Short Text
State Short Text
Zip Short Text
Email Hyperlink
Website Hyperlink
Telephone Short Text (Phone number input
mask).
Fax Short Text
9. Save and then close the Merchants table.
10. Create a relationship by linking the Merchant ID in the Inventory table to the Merchant
ID in the Merchants table. Be sure to enforce referential integrity
