Tutorials

Tutorials

editors (login required)
Contents Tool Factory Database V3 Types of Fields in a Database
Grade: K-12
Required products: Tool Factory Database V2
Instructions
When adding fields, select the “type” that is most appropriate to the kind of data required.

Check Box – This creates a single check box. *TIP* In order to “select all options that apply”, use a single checkbox for each option.
Options List – The list of options will appear with a radio button next to each. Only one item can be selected from the list.
Selection List – Each option appears in a drop-down menu. Only one can be selected from the list.
Text – Create single or multiple lines of text.
Number – This field will only accept numbers. *TIP* Phone numbers should be a “Text” field, otherwise the parenthesis and dashes won’t show up.
Currency – This supports money amounts in any currency type.
Date – This field allows for days, months, and years.
Time – Insert time in hours, minutes and seconds
Picture – Use this field for photographs and clipart. It’s also useful to collect pictures from the internet.
Movie – Movie files can be QuickTime, MPG, or AVI.
Sound – Add narration, sound effects, or even music.
Click images to enlarge