How to Rename a Table in Microsoft Access

See Microsoft Access: Tips and Tricks for similar articles.
Looking to improve your Microsoft Access skills? Check out Webucator’s Microsoft Access classes.

There will be times when you must rename a table. Before you do, please be aware that any objects that are dependent on the table will need to be updated as well. Access does not rename references for you as other technologies do.

This feature works the same in all modern versions of Microsoft Access: 2010, 2013, and 2016.

  1. Right-click on the table that you wish to rename.
  2. Choose Rename. Choose Rename
  3. Type the new name and hit the Enter key to confirm the name.
  4. Note that you will have a chance to CTRL+Z to undo right away.

Related Articles

  1. How to Create a Form with the Form Wizard in Microsoft Access
  2. How to Create a Report with the Report Wizard in Microsoft Access
  3. How to Add a Header and Footer to a Form in Microsoft Access
  4. How to Add a Header and Footer to a Report in Microsoft Access
  5. How to Open a Table in Design View in Microsoft Access
  6. How to Rename a Table in Microsoft Access (this article)
  7. How to Move a Field in the Query Grid in Microsoft Access
  8. How to Create a Navigation Form in Microsoft Access
  9. How to Add a Logo to a Form Header in Microsoft Access
  10. How to Add a Title to a Form Header in Microsoft Access
  11. How to Set the Navigation Form as the Default Form in Microsoft Access
  12. How to Run a Macro from a Navigation Button in Microsoft Access
  13. How to Add a Title to a Report Header in Microsoft Access
  14. How to Add a Logo to a Report Header in Microsoft Access