Renaming the Mobile Phone field.
For the stationery store, you want to rename a field name from "Mobile Phone" to "Wireless Phone". Changing a field name is a common modification you can make to any database table. But right now, you have the "Contact List" form open. Before you rename your field name, you must open the Contacts table by using the Navigation Pane. Then you must close all the other forms and reports that may be open. Finally, you select the field name and type in the new name.
Note If you haven't closed all the other forms, you won't be able to change the field name. You'll receive an error that says that you can't modify the structure of the table because it is in use by another person or process. So, make sure those forms are closed.
Once you've made the change, you know that Access has made changes to the reports and forms that use this field because you know that the Name AutoCorrect Options are on. Now we're ready to add an entire new field to a table.