Microsoft Access
INTRODUCTION
Now that youve completed the Microsoft Access study unit, youre ready to complete your graded project. As you work through this project, youll apply your recently learned Access skills to create and use a home inventory database. A home inventory database can serve many useful applications in todays 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.
GRADED PROJECT
In this graded project, youll create a home inventory database
based upon fictitious information provided in this booklet.
using this data, youll 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