Available field data types and usage of access

The following table summarizes the data types of all available fields in Microsoft Access, their usage, and storage space.

Data Type	Usage	Big and small
"Text" (Text)	A combination of text or numbers, such as an address or a number that does not need to be calculated, such as a telephone number, part number, or zip code.	It can contain a maximum of 255 characters. Microsoft Access only saves characters in the input field, but does not save null characters in the unused position in the text field. Set the "field size" attribute to control the maximum number of characters that can be entered.
"Remarks" (Memo)	Long text and numbers, such as remarks or descriptions.	It can contain a maximum of 64,000 characters.
"Number" (Number)	Numeric data that can be used for arithmetic computation, except for the computation of currencies (using the currency type ). Set the "field size" attribute to define a specific numeric type.	1, 2, 4, or 8 bytes. 16 bytes are only used for Synchronous replication ID (guid ).
"Date/time" (Date/time)	Date and time.	8 bytes.
"Currency" (Currency)	Currency value. The currency data type can be used to avoid rounding During calculation. It is accurate to the 15-digit and 4-digit digits on the right of the decimal point.	8 bytes.
"Automatic ID" (Autonumber)	The unique sequence (1 in each increment) or random number automatically inserted when a record is added.	4 bytes. 16 bytes are only used for Synchronous replication ID (guid ).
"Yes/No" (Yes/No)	The field only contains one of the two values, such as "yes/no", "True/false", and "On/Off ".	1 digit
"OLE object" (OLE object)	In otherProgramObjects created using the OLE protocol, such as Microsoft Word documents, Microsoft Excel workbooks, images, sounds, or other binary data, can be linked to or embedded into Microsoft Access tables. You must use the BIND object box in the form or report to display the OLE object.	The maximum size is 1 GB (limited by disk space ).
"HYPERLINK" (Hyperlink)	Stores the hyperlink fields. The hyperlink can be a UNC path or URL.	It can contain a maximum of 64,000 characters.
"Query wizard"	Create a field that allows you to use a combo box to select values from other tables or from the value list. Select this option in the Data Type list to start the wizard for definition.	The length of the primary key field is the same as that of the primary key field, and this field is also a "query" field. Generally, it is 4 bytes long.

Note:
"Number", "date/time", "currency", and "yes/no". These data types provide predefined display formats. You can select the desired format from the available formats of each data type to set the "format" attribute. You can also create custom display formats for all data types, except for the OLE object data types.