Household personal possessions insurance 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.

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 numbers
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:

INVENTORY.MDB (inventory.zip)

About 58 KB. Both the Access 2.0 and 2003 versions are in the zip file. The Access 2.0 version should be renamed to INVENTRY.MDB (8.3 character limit for the file name). The Access 2003 version has the report and form imported from the Access 2.0 version, in addition to its own newer form and report.

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: