Modifying Data Types in MS Access
To view or change the data type:
1. Click a cell.
2. In the Datasheet contextual tab, the Data Type and Formatting section displays the data type.
3. To change the data type, in the Data Type box, click the arrow, and then select the type you want. (Note: You may need to retype the value in your cell or cells if the type is not compatible.)
4. In the Format box, click the arrow to format how the data is displayed.
5. Select Is Required if you need to make this field mandatory. To make table and field definitions easier, Microsoft Office Access has a set of predefined templates.