| Databases : Field Data Types
| 
|
|
Each field in a record must have a
type The field type refers to the kind of
data that can be stored in the field. Possible field types include :
| Type |
Description |
Example Data |
| Numeric | Numbers only | 1545, 1.23, 12303 |
| Alphabetic / Text | Letters only | hello, Hi, TEST |
| Alphanumeric | Letters and numbers | robot 23, area 12, WA13 9IJ |
| Boolean / Logical | True or false | true, yes, false, no |
| Date | A date | 12/02/98, 1/12/71 |
Only data that matches the type of a field can be stored in a field. For example you could
not store the word "cricket" in a field which is set to be numeric. Some databases will also
let you store images and sound recordings in fields.
GCSE ICT Companion 04 - (C) P Meakin 2004