How to Set Field Data Type in Access 2007
A field data type in Access 2007 specifies the data that a field may contain and its size. The data types in Access 2007 include boolean, currency, date, double, integer, long, string and variant. You should make a copy of a table before changing any data types if the table already contains data. The following steps will show how to set field data types in Access 2007.
Other People Are Reading
Instructions
-
-
1
Start Access 2007 and open a database with a defined table. Display the "Database" window and click on the "Tables" line item in the "Objects" panel. Select the table in the right panel for which you wish to change the data types.
-
2
Select "View" menu item on the "Table" window and click on "Design View" if it is not already selected.
-
-
3
Locate the field for which you wish to change the data type and click on the "Data Type" field. Click on the downward pointing arrow that appears to bring up the drop-down list of data types. Select the desired data type and click on the "Save" icon in the toolbar.
-
4
Look at the lower part of the "Table" window for Field Properties and click on the "General" tab. Click on the "Field Size" property box, which should be the first property box listed.
-
5
Click on the downward pointing arrow that appears to bring up the drop-down list of available field sizes for numeric fields. Select the desired field size.
-
6
Enter the maximum number of allowable characters for text fields.
-
1
