How to Rename a Table in Microsoft Access

  • google plus

In Brief...

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.

Instructions

  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.

Author: Tracy Berry

Tracy has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide, including involvement in large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, reporting/productivity applications, as well as the creation of online courses with software from leading vendors.

Discuss