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.
    Create Forms and Populate the Database
11. Create a Merchants form.
12. Create an Inventory form, with the purchase price as $0.00

Sample Solution