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 2010 places the name in edit mode in the Navigation pane so that you can type in a new name, as shown in Figure 5-8. Type the new name, and press Enter to save it.
Figure 5-8. After clicking Rename on the shortcut menu, you can ...
Get Microsoft® Access® 2010 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
