Microsoft Access

INTRODUCTION

Now that you've completed the Microsoft Access study unit, you're ready to complete your project. As you work through this project, you'll apply your recently learned Access skills to create and use a home inventory database. A home inventory database can serve many useful applications in today's society. It allows you to access important information regarding your purchases without having to sort through a paper file of merchant receipts.

This will minimize damage and loss of important receipts, which you may need to produce to get warranty service. Keeping a copy of your database offsite, such as in a safety-deposit box or with family or friends, will allow you to hand a detailed printout of your possessions
to an insurance adjuster in case of theft, fire, or other disaster.

Over time, you may wish to add more tables to the database for different purposes. For example, you may use the Make Table Query function in Access to subdivide your database by Item Category.

PROJECT

In this graded project, you'll create a home inventory database based upon fictitious information provided in this booklet.

Using this data, you'll also perform queries and create reports.

Your Access project will consist of the following items:

1. Two data tables
2. Two data entry forms
3. Simple query and report
4. Multiple-table query and report.