O'Reilly logo

Microsoft Access 2013 Inside Out by Jeff Conrad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Renaming tables

If you keep transaction data (such as receipts, deposits, or checks written), you might want to save that data at the end of each month in a table with a unique name. One way to save your data is to rename the existing table (perhaps by adding a date to the name). You can then create a new table (perhaps by making a copy of the backup table’s structure) to start collecting information for the next month.

To rename a table, right-click it in the Navigation pane and click Rename on the shortcut menu. Access places the name in edit mode in the Navigation pane so that you can type in a new name, as shown in Figure 11-6. Type the new name, and press Enter to save it.

Figure 11-6. After clicking Rename on the shortcut menu, you can rename ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required