Database Management FAQ : Database/Data Table : How to build database : Build Database, Analyzing Data

Related software (Read/Download) :
Organizer Deluxe Series
Organizer Pro Series

Question/Topic: Build Database / Analyzing Data


  1. Read over help.
  2. Analyzing your data.
  3. Build database.

To aid in creating your own database template, begin by brainstorming what type of data you would like to store and what field names you will need. During this process also decide on the type of data entry control you will need for each field; for instance, simple text, drop down list, email address etc.


Referring back to our Inventory organizer, we will need to store information such as the tools name, the type of tool or what category it will fit under such as office or garden tool. We could also store information such as where this tool is stored, its value and its condition. In addition we could also have information such as the product support and maybe some room for notes.


In total, all of these eight types of information will require the following nine field names:
Tool name
Category
Location
Condition
Value
Product support phone
Product support web
Short Notes
Long Notes
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 Character field type and drop down list data entry control. Value could be of Numeric field type with two decimal places. Support phone will be of Character field type and Phone Number data entry control, while Support web will also be of Character field type, but of Web Address data entry control. And finally, Tool Name and Short notes would be of Character field type and Simple data entry control, and Long notes would be of Memo field type and Simple Multi-Line data entry control.


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


field name field type size data entry control
TOOLNAME Character 200 SimpleText
CATEGORY Character 40 Drop-Down List
LOCATION Character 40 Drop-Down List
CONDITION Character 40 Drop-Down List
VALUE Numeric Numeric Simple
PHONE Character 20 Phone Number
WEB Character 200 Web Page Address
SHORT Character 200 SimpleText
NOTES Memo Multi-Line Text








Related software (Read/Download) :
Organizer Deluxe Series
Organizer Pro Series






Copyright © PrimaSoft PC, Inc. All rights reserved.