Select the table Right click and select Copy, Then Paste it and it will prompt you for a new name.
Rename Access Table
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.
-
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.
-
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.
-
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>
6 additional answers
Sort by: Most helpful
-
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