Every ar in a table has properties and also these properties specify the field"s characteristics and behavior. The most necessary property because that a field is that data type. A field"s data kind determines what type of data it have the right to store. MS accessibility supports different types of data, each v a specific purpose.

You are watching: Which data type stores web addresses

The data form determines the sort of the values that users have the right to store in any kind of given field.Each ar can keep data consist of of only a single data type.

Here are few of the most typical data types you will find used in a typical Microsoft accessibility database.

Type that DataDescriptionSize
Short TextText or combinations of text and numbers, consisting of numbers that perform not call for calculating (e.g. Phone call numbers).Up to 255 characters.
Long TextLengthy message or combinations of text and numbers.Up to 63, 999 characters.
NumberNumeric data provided in mathematical calculations.1, 2, 4, or 8 bytes (16 bytes if set to Replication ID).
Date/TimeDate and time worths for the years 100 v 9999.8 bytes
CurrencyCurrency values and numeric data supplied in mathematics calculations involving data v one to 4 decimal places.8 bytes
AutoNumberA distinct sequential (incremented by 1) number or random number assigned through Microsoft accessibility whenever a brand-new record is included to a table.4 bytes (16 bytes if set to Replication ID).
Yes/NoYes and No values and also fields the contain only one of two worths (Yes/No, True/False, or On/Off).1 bit.

If you usage previous versions of Access, girlfriend will notice a difference for 2 of those data types.

In accessibility 2013, us now have actually two data types — quick text and also long text. In previous versions of accessibility these data varieties were dubbed text and memo.

The text field is described as brief text and also your memo ar is now called long text.

Here are several of the various other more committed data types, friend can choose from in Access.

Data TypesDescriptionSize


Files, such together digital photos. Multiple records can be attached every record. This data form is not easily accessible in previously versions of Access.

Up to about 2 GB.

OLE objects

OLE objects have the right to store pictures, audio, video, or other BLOBs (Binary large Objects)

Up to about 2 GB.


Text or combine of text and also numbers stored as text and also used as a hyperlink address.

Up to 8,192 (each component of a Hyperlink data type can contain up to 2048 characters).

Lookup Wizard

The Lookup Wizard entry in the Data type column in the architecture view is not actually a data type. When you pick this entry, a wizard start to help you define either a simple or facility lookup field.

A simple lookup field uses the materials of another table or a worth list come validate the materials of a solitary value per row. A complicated lookup field permits you to save multiple values of the exact same data form in each row.

Dependent on the data form of the lookup field.


You can develop an expression that offers data from one or more fields. You have the right to designate different result data species from the expression.

You can create an expression that provides data from one or much more fields. You can designate different result data species from the expression.

See more: What Does 18K Ge With A Circled A Mean On A Silver Ring? What Does 18K Ge Mean On Jewelry

These space all the various data varieties that girlfriend can choose from when creating fields in a Microsoft access table.