How to: Choose Data Types
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.
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.
For more information, see.
To choose a data type for a field programmatically
When creating the table using the SQL CREATE TABLE command, specify the data type for the field.
To edit an existing table, open the table with the USE command and then use the SQL ALTER TABLE command.
For more information, seeor .
For example, the following code creates and opens a table named Customer with three fields, Cust_ID, Company, and Contact using the CREATE TABLE command:
CREATE TABLE Customer (Cust_ID C(6), Company C(40), Contact C(30))
In the example, C(6) indicates the field contains Character data and has a field width of 6 characters.