1-866-245-5224 sales@keystonelearning.com

Access 2003: About Data Types

Access 2003: About Data Types

Data Types come in all different shapes and sizes dependent upon the data you want to store in your individual fields.

Figure 2. Access Data Types

You can set the data type for any field in Design View.

On the following page, you’ll find a table listing many of the common data types for Access 2003 as well as their uses and field sizes.

The following table describes some of the more common data types available for fields in Access.

               

Data type

Stores

Size

Text

Use for text, or text and numbers that are not used in calculations (for example, a product ID).

 Up to 255 characters.

Memo

Use for text greater than 255 characters in length. Notes and lengthy descriptions are good examples of where you would use a Memo field.

 Up to 1 gigabyte of characters, or 2 gigabytes of storage (2 bytes per character), of which you can display 65,535 characters in a control.

Number

Use for storing numbers to be used in calculations, except for monetary values (use the Currency for data type for monetary values).

 1, 2, 4, or 8 bytes, or 16 bytes when used for replication ID.

Date/Time

Use for storing date/time values. Note that each value stored includes both a date component and a time component.

 8 bytes.

Currency

Use for storing monetary values (currency).

 8 bytes.

AutoNumber

Use for generating unique values that can be used as a primary key. Note that AutoNumber fields can be incremented sequentially, by a specified increment, or chosen randomly.

 4 bytes or 16 bytes when used for replication ID.

Yes/No

Use for True/False fields that can hold one of two possible values: Yes/No or True/False, for example.

 1 bit (8 bits = 1 byte).

Hyperlink

Use for storing hyperlinks to provide single-click access to Web pages through a URL (Uniform Resource Locator) or files through a name in UNC (universal naming convention) format. You can also link to Access objects stored in a database.

 Up to 1 gigabyte of characters, or 2 gigabytes of storage (2 bytes per character), of which you can display 65,535 characters.