Characteristics of Fields
Each field within a table must have a unique name (avoid spaces and special characters).
Data within a field must be of the same data type. The following are common data types:
- character (text or string)
- memo (large character field)
- integer (whole numbers for calculations)
- number (values with decimals for calculations)
- currency (formatted number)
- logical or Boolean (true/false; 0,-1; yes/no)
- date/ time (use computer’s internal calendar/clock)
- graphic (picture)