After you specify the name for a field, you can choose the type of data that the field can store.

To chose a data type for a field

Open the table in the Table Designer.

On the Fields tab, select the field that you want.

In the Type list, select a data type for the field.

Tip:

If the field has a Numeric or Float type, set the number of decimal places in the Decimal column. If an integer field contains automatically incrementing values, you need to specify next and step values. For more information, see How to: Set Autoincrementing Field Values.