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