Access database field types and their characteristics
August 3, 2020 | Education
| Text – one line of text (up to 255 characters)
Memo field – text, consisting of several lines, which can then be viewed using scroll bars (up to 65,535 characters).
Numeric – a number of any type (integer, real, etc.).
Date / Time is a field containing a date or time.
Monetary – a field expressed in monetary units (p., $, Etc.)
Counter is a field that is entered automatically with the entry of each record.
Boolean – contains one of the values TRUE (true) or FALSE (false) and is used in logical operations.
OLE Object Field – Contains pictures, sound files, Excel tables, Word document, etc.
