MONEY Stores currency values and numeric data used in mathematical calculations. IMAGE Used to store Object Linking and Embedding (OLE) objects. DATETIME Stores date and time values for the years 100 to 9999. COUNTER Stores a long integer value that automatically increments whenever a new record is inserted. For example, true/false, yes/no, or on/off. BIT Used to store one of two types of values. No transformation of the data is made in this type of field. Miscellaneous: BINARY Enables you to store any type of data in a field. The string canĬontain any ASCII characters including letters, numbers, special characters, and nonprinting characters. The length is determined by the Field size property. TEXT A variable-length data type that stores a combination of text and numbers up to 255 characters. String: CHAR A fixed-length data type that stores a combination of text and numbers up to 255 characters. SMALLINT Stores integers from -32,768 to 32,767. REAL Stores single-precision floating-point values. FLOAT Stores double-precision floating-point values. Table-2: Common Microsoft Access data types Data Type Description Numeric: DECIMAL An exact numeric data type that holds values from -10^28-1 to 10^28-1. Tables-2 and 3 listĭata types used in Microsoft Access. SQL view supports a variety of different data types. Will only allow numbers to be stored in the column. For example, if you create a column that can only store numbers, you must assign it a specific data type that A data type specifies the type of data a columnĬan store. When you create column names for a table, each column must contain a data type.

Microsoft access data types explained