Question

Write data types that are used in MS-Access.

Answer 1

Data is stored in the computer according to its type. MS-Access supports various data types which are :

• Text: The field can contain any characters. The Field Size property defines the maximum number of characters. The maximum cannot be above 255 characters.
• Memo: Like a text field, but the maximum number of characters is 65,535. Access takes more time to process a memo field, so use text fields if adequate.
• Number: The field can contain a number. The Field Size property defines what kind of number. ,,
• Integer: A small integer. It must be in the range -32,768 to +32,767 (a 16-bit integer).

1. Long Integer. It must be in the range of around -2,140 million to +2,140 million (a 32-bit integer).
2. Single. A decimal number in the range from -3.4*1038 to +3.4*1038 with an accuracy of 6 or 7 significant digits (a 32-bit floating-point number).
3. Double. A decimal number in the range from -1.8*10308 to +1.8*10308 with 14 significant digits (a 64-bit floating-point number).
4. Decimal. A very long integer with a decimal point placed somewhere. Intended for monetary calculations where rounding must be strictly controlled. In the book, we use Single or Double instead.