SQL for Microsoft Access, 2nd Edition

Appendix D Microsoft Access Data Types

This appendix provides the data types most commonly used in Microsoft Access.

Note: Some of the following data types are used in Design view and some are used in SQL view.

Numeric Data Types:

AUTONUMBER — Used for indexing records in tables.

CURRENCY — Used for monetary calculations.

DECIMAL — An exact numeric data type that holds values from –10^28 – 1 to 10^28 – 1.

FLOAT — Stores double-precision floating-point values.

INTEGER — Also called INT. Stores a long integer from –2,147,483,648 to 2,147,483,647.

NUMBER — Numerical data that can be used in all forms of calculations except those dealing with money. The Field size property determines the number of bytes used to store the number and, subsequently, the number ...