Rename Access Table

Anonymous
2018-12-12T20:53:54+00:00

Hi

I am using Office 365 Home with Windows 10.  I am using a table with title 2017.  I want to keep this table but rename it 2019.  How do I do that?

Many thanks

Bill

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} vote
Answer accepted by question author
  1. ScottGem 68,775 Reputation points Volunteer Moderator
    2018-12-12T20:58:51+00:00

    Select the table Right click and select Copy, Then Paste it and it will prompt you for a new name.

    2 people found this answer helpful.
    0 comments No comments
Answer accepted by question author
  1. Duane Hookom 26,545 Reputation points Volunteer Moderator
    2018-12-12T22:34:31+00:00

    BTW: if this works, the answer from Scott should be the accepted answer.

    1 person found this answer helpful.
    0 comments No comments
Answer accepted by question author
  1. Duane Hookom 26,545 Reputation points Volunteer Moderator
    2018-12-12T22:32:59+00:00

    You can paste it by simply pressing Ctrl+V. You can choose to paste only the structure, structure and data, or append.

    I would question why you have a year as a table name. This is a bit unusual but it's your database.

    1 person found this answer helpful.
    0 comments No comments
Answer accepted by question author
  1. Anonymous
    2018-12-12T21:08:52+00:00

    >>

    I am using a table with title 2017. I want to keep this table but rename it 2019. How do I do that?

    <<

    Not entirely clear whether you just want to "rename" the existing table from 2017 to 2019 or you want to make a copy of the table under a different name.

    Either case, the process is simple (as per attached screenshot)

    #1 - Select the table you want to rename and right-click on it

    #2 - If you simply want to <Rename> it - select <Rename> from the menu options

    #3 - If you want to make a copy under a different name - select <copy>

    1 person found this answer helpful.
    0 comments No comments

6 additional answers

Sort by: Most helpful
  1. Anonymous
    2018-12-12T21:51:28+00:00

    HI Scott

    Where do I paste It?  Do I create a blank page somehow?  Sorry I am being dense.

    thanks

    Bill

    0 comments No comments