 |
 |
 |
 |
 |
Short Text (formerly “text”) - maximum number of 255 characters, can be letters, numbers, spaces or symbols
Number - contains positive or negative numbers on which arithmetic operations will be performed.
Currency - contains monetary data.
Long text (formerly Memo) - contains text that can exceed 255 characters
Date/time - stores dates or times
Autonumber - stores a unique sequential number that Access assigns to a record
Yes/No - contains one of two values: true/false, on/off...