Overview of data types in Access desktop databases, and detailed data type reference, including Short Text, Long Text, and Date/Time.

This article describes the data types and other field properties available in Access, and includes additional information in a detailed data type reference section.

Learn how to modify or change the data type setting for a field in Access databases.

Access data types are differently named from SQL Server data types. For example, a SQL Server column of the bit data type is imported or linked into Access with the Yes/No data type. The following …

Access validates data as it’s entered to ensure that it matches the field’s data type. If you need a specific data format in a field, specify its data type when you create it.

The following table shows the data types available for Access web apps and what kind of data they're suitable for. For SQL Server aficionados, we also list the SQL Server data types that they correspond …

When you use the Date/Time data type in Microsoft Access, you can keep the default formats, apply a predefined format, or create a custom format.

On the Table Fields tab, in the Formatting group, click the down arrow next to Data Type, and then click Attachment. Access sets the data type for the field to Attachment, and places an icon in the header …

The following table lists ANSI SQL data types, their equivalent Microsoft Access database engine SQL data types, and their valid synonyms. It also lists the equivalent Microsoft SQL Server data types.

Use these Access type conversion functions to coerce an expression to a specific data type. For example, you can use the CDate function to convert a string to the Date data type.