Microsoft access database data types

Long Time Same as the setting on the Time tab in the regional settings of Windows. Example: PM. Short Time Displays the time as hours and minutes separated by the time separator, by using a hour clock. Example: Lists of components that you can use in custom formats. Type any combination of the following components to build a custom format. For more information on Windows regional settings, see Windows Help. Note: Separators are set in the regional settings of Windows.

For example, hh:mm. Any short string of characters, enclosed in quotation marks "" Custom separator. Quotation marks are not displayed. For example, "," displays a comma. For example, PM. For example, pm. For example, P. For example, p. Enter a fractional precision to specify the number of digits to the right of the decimal point Allows entry by setting to Yes of a zero-length string "" in a Hyperlink, Text, or Memo field.

Yes Tracks changes. To view the field value history, right-click the field, and then click Show column history. Warning: Warning Setting this property to No deletes any existing field value history. You can define a custom format for a Hyperlink field. Purpose Use to store a block of text that is more than characters long and is formatted text. Note, beginning in Access Memo data type has been renamed to Long Text.

Warning: Setting this property to No deletes any existing field value history. You can define a custom format for a Memo field. Purpose Use to store a numeric value that isn't a monetary value. If you might use the values in the field to perform a calculation, use the Number data type.

Byte — Use for integers that range from 0 to Storage requirement is 1 byte. Integer — Use for integers that range from , to 32, Storage requirement is 2 bytes. Long Integer — Use for integers that range from -2,,, to 2,,, Storage requirement is 4 bytes. Tip: Use Long Integer when you create a foreign key to relate to another table's AutoNumber primary key field.

Single Use for numeric floating point values that range from Double Use for numeric floating point values that range from Storage requirement is 8 bytes. Replication ID Use for storing a globally unique identifier required for replication.

Storage requirement is 16 bytes. Note that replication is not supported using the. Decimal Use for numeric values that range from Storage requirement is 12 bytes. Tip: For best performance, always specify the smallest sufficient Field Size. Purpose Use to store a Large numeric value that isn't a monetary value. If you might use the values in the field to perform a calculation, use the Large Number data type.

OLE Object fields support fewer file types than Attachment fields support. In addition, OLE Object fields do not let you attach multiple files to a single record. Purpose Use to store up to characters of text. Note, beginning in Access the Text data type has been renamed to Short Text. Enter a value from 1 to Text fields can range from 1 to characters. For larger text fields, use the Memo data type. For example, if you are storing postal codes of a known length, you should specify that length as the Field Size.

You can define a custom format for a Text field. Data types. Introduction to data types and field properties. Tip: An effective caption is usually brief. Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information.

Not enough pictures. Any additional feedback? Submit feedback. Thank you for your feedback! Number, Large Number. Numeric values, such as distances. Note that there is a separate data type for currency. Yes and No values and fields that contain only one of two values. Rich Text. Text or combinations of text and numbers that can be formatted using color and font controls.

Calculated Field. Text or combinations of text and numbers stored as text and used as a hyperlink address. Short Date. Medium Date. Display the date in medium format. For example, 3-Apr for USA. A separate field can be added in the table if no existing field produces unique values for every record. MS Access asks the user to create this type of field if the user does not specify primary key while saving the table.

Skip to content. MS Access provides the following data types:. Page Contents show. Next ». This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More. Close Privacy Overview This website uses cookies to improve your experience while you navigate through the website.

Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are as essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent.

You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience. Necessary Necessary. Necessary cookies are absolutely essential for the website to function properly.

Contents Exit focus mode. Please rate your experience Yes No. Any additional feedback? Submit and view feedback for This product This page. View all page feedback. In this article. A character string literal can contain any ANSI character decimal.