Change a field name in Design view
- Open the table in Design view.
- Double-click the field name you want to change.
- Type the new field name, following Microsoft Access object-naming rules.
- Click Save on the toolbar to save your changes.
Caution If you have expressions, or Visual Basic for Applications code that contain references to a field whose name you are changing, you must update all of those references to the new name.