Household inventory database for Microsoft Access

INVENTRY.MDB is a Microsoft Access database for creating a household inventory of your personal possessions.

Insurance agents often recommend that you make an inventory when you buy a homeowner's or renter's policy, and even if you aren't required to do it, it's a good idea to have a list of all the items you own.

After a catastrophic loss, it's not easy to make a complete list of the items lost for filing an insurance claim unless you did it beforehand, and making a record of all the serial numbers helps police to identify and recover your property if it's stolen.

An inventory before you move to a new home helps ensure that the movers didn't lose anything.

The database has a couple of simple queries to sort the data or review selected fields, and it has a report that might need adjustments before it's useful for printing on a different printer from the one it was designed for.

Its tables are:

• Inventory - the inventory of items. Its fields are:

1. Category - General category of the item
2. Q - Quantity
3. Make - Brand name
4. Model - Model name or number
5. Desc - Description
6. SerialNo - Serial number and any other identifying number(s)
7. Loc - Current location, abbreviated
8. Cost - Buy price
9. Value - Current value or estimate
10. Priority - Priority for keeping the item, how important it is to keep or have.
11. Disp - Disposition plans: keep, donate, throw out, etc.
12. Misc - To provide a column on printouts for a checkmark, or whatever.

• Locs - physical locations (links the abbreviations with the full location descriptions)
• Priorities - (links the codes with the full descriptions). The current priority codes are as follows, but they can be changed to anything:

1. Essential. Keep no matter what.
2. Useful. Keep.
3. Potentially useful. Keep.
4. Not currently used, not clearly useful for the future, and easily replaced.
5. Discard any time.

Download:

Download link

Description

US$2.00 (64KB)

The zip file contains INVENTORY.MDB in Microsoft Access 2003 and 2.0 formats. You can modify the databases however you want to customize them for your own needs. The Access 2003 version has its own newer form and report, in addition to the form and report imported from the Access 2.0 version. I believe this version will not work in Access 2007 or later. The Access 2.0 version should be renamed to INVENTRY.MDB for use in Windows 3.1 (8.3 character limit for the file name). The Buy Now button goes to the PayPal website: If you pay from your PayPal account, PayPal automatically redirects you to my download page.   If you pay with a credit card, the redirect to my download page is not automatic. You will see a "Return to Merchant" button/link on the last PayPal confirmation page. Click that link to go to my download page.   If you cancel the transaction at PayPal with their "Cancel and return to [my email address]" link, you will return to this page you are reading now instead of going to the download page.

Screenshots:

In addition to the usual Datasheet view, the databases have a form that can be used for data entry or review. This is the Access 2.0 InventoryForm as it appears when opened in Access 2003.

The Access 2003 version of the form: