Question

numbers stored in the _____________ type of field are given a fixed number of decimal places by access

Answer 1

You can use 'int' data type for decimal places.

Type = 'int' Length = 3 Decimals = 2 #(just for reference)

Data type Range

int 1 - 4

longint 5 - 9

vastint 10 - 15

Note:

There are numerous data types for decimal values:

DECIMAL, NUMERIC, NUMBER, FLOAT, DOUBLE PRECISION, TINYINT, SMALLINT, BIGINT