|  Organizer Advantage HowTo/Help  |  Designer HowTo/Help  | 

Designer Help > Build Database Simple > Home Inventory

How to build a simple home inventory database

Think over what data fields your application will need and write them down.

In the case of the home inventory table we would like to store and track information such as item name, the type of the tool/equipment or what category it will fit, where the item is stored, its value and its condition. In addition, we could also have information such as the product support, link to an image file, and maybe some room for notes.

In total, all of these eight types of information will require the following 8 fields: ITEMNAME, CATEGORY, LOCATION, CONDITION, ITEMVALUE, WEBSUPPORT, NOTES, PICTURE

For each field we will need to select the most suitable field type and data entry control. So for instance, CATEGORY, LOCATION, and CONDITION could all have Text field type and Combo-Box data entry control. ITEM VALUE could be of Numeric field type with two decimal places. PICTURE will be of Text field type and Graphic data entry control, while WEB SUPPORT link will be of Text field type, but of Web Browser data entry control. And finally, ITEM NAME would be of Text field type and Simple Text data entry control, and NOTES would be of Memo field type and Simple Multi-Line data entry control.

We have now planned out our table template, which will make the job of actually creating it much easier.

Print the above table, so you can refer to it when creating the table and so you do not make errors when entering field names with sizes and selecting field types with data entry controls.

Now you are ready to define your Home Inventory Table.

• Create home inventory table
• Define home inventory Layout
• Process home inventory data

Organizer Advantage, Simple Database Solutions

Organizer Advantage, Business Database Solutions

Organizer Advantage Free Service

Organizer Advantage Support