Rename a Field in a Table in Access – Instructions and Video Lesson
Rename a Field in a Table in Access: Overview
You can rename a field in a table in Access that you have already created. You should be extremely careful when you do this! This is because any changes you make to field names are not necessarily updated in all the previously created objects. This includes related reports, forms, or queries that refer to the “old” field names.
So, if you rename a field used by any other database objects, you should double-check those objects and change the name of the field reference there, if necessary. Doing that ensures that all of the related database objects that were looking for the “old” field name will now look for the new field name to access the data within the field.
To rename a field in a table in Access, open the table within which you want to rename a field in the table design view. Then click into the “Field Name” column of the field whose name you wish to change. Type a new name for the field, and then click the “Save” button in the Quick Access toolbar to save your structural changes.
Rename a Field in a Table in Access – Instructions: A picture of a user renaming a table field in Access.
Rename a Field in a Table in Access: Instructions
- To rename a field in a table in Access, open the table containing the field to rename in design view.
- Click into the “Field Name” column of the field that you want to rename and type a new name.
- Click the “Save” button in the Quick Access toolbar to save your structural modifications.
Rename a Field in a Table in Access: Video Lesson
The following video lesson, titled “Renaming Fields,” shows you how to rename a field in a table in Access. This video is from our complete Access tutorial, titled “Mastering Access Made Easy v.2016-2013.”
- Custom Reports in QuickBooks Online: Overview ...
- Change Orders in Sage 50: Overview ...
- Categorize an Item in Outlook on the Web: Overv...
- Write Checks in Sage 50: Overview T...
- Create a Mailbox Rule in Outlook: Overview ...
- Access 2010
- Access 2013
- Access 2016
- CPE Information for CPAs
- Crystal Reports
- Excel 2010
- Excel 2013
- Excel 2016
- Internet Explorer
- Microsoft Edge
- Microsoft Excel Training for Lawyers
- Microsoft Office Online
- Microsoft Outlook Training for Lawyers
- Microsoft Word Training for Lawyers
- Office 2010
- Office 2013
- Office 2016
- Office 365
- OneNote 2013
- OneNote 2016
- Outlook 2010
- Outlook 2013
- Outlook 2016
- Outlook on the Web
- Photoshop Elements
- PowerPoint 2010
- PowerPoint 2013
- PowerPoint 2016
- Project 2013
- Project 2016
- Publisher 2010
- Publisher 2013
- Publisher 2016
- Quickbooks Online
- QuickBooks Training for Lawyers
- Resume Writing
- Small Business Accounting
- What's New at TeachUcomp?
- Windows 10
- Windows 7
- Windows 8
- Windows 8.1
- Word 2010
- Word 2013
- Word 2016
- Word Online