How to Rename a Table in Microsoft Access

See Microsoft Access: Tips and Tricks for similar articles.

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.