How to Change Data Type in Microsoft Access
- George Apostolov
How to Change Data Type in Microsoft Access: step-by-step guide
Open your Access database.
Locate the table containing the field whose data type you want to change. Right-click on the table name in the 'Navigation Pane' and select 'Design View'.
In 'Design View', find the field you want to modify in the 'Field Name' column.
In the 'Data Type' column next to the 'Field Name', click the dropdown menu.
Select the new data type for the field.
Click the 'Save' button to save your changes.
Quick answer: To change a data type in Microsoft Access, open your database and switch to Design View by right-clicking the table in the Navigation Pane. Locate the target field in the Field Name column, open the dropdown menu in the Data Type column, choose the new data type, and click the Save button.
About this Microsoft tutorial
Modify field data types in Microsoft Access by opening the table in Design View, selecting a new type from the dropdown, and saving. This guide shows how to change Data Type in Microsoft Access in 6 steps, starting with "Open your Access database" and finishing with "Click the 'Save' button to save your changes". The interactive demo above is a click-through copy of the real Microsoft interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to change Data Type in Microsoft Access?
6 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Microsoft data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Microsoft. Related guides: How to Change Date Format in Microsoft Excel, How to Change Field Size in Microsoft Access and How to Change Language in Microsoft Excel. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
