Household inventory database
INVENTRY.MDB is a Microsoft Access database for creating a household inventory of your personal possessions, such as your insurance agent might require or that you might make before you move to a new home to make sure the movers don't lose anything.
It 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:
- Category - General category of the item
- Q - Quantity
- Make - Brand name
- Model - Model name or number
- Desc - Description
- SerialNo - Serial number and any other identifying numbers
- Loc - Current location, abbreviated
- Cost - Buy price
- Value - Current value or estimate
- Priority - Priority for keeping the item, how important it is to keep or have.
- Disp - Disposition plans: keep, donate, throw out, etc.
- 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:
- Essential. Keep no matter what.
- Useful. Keep.
- Potentially useful. Keep.
- Not currently used, not clearly useful for the future, and easily replaced.
- 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
The Access 2.0 InventoryForm as it appears when opened in Access 2003.
The Access 2003 version of the form:
