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, select it in the Database window and choose the Rename command from the Edit menu. Access places the name in an edit mode in the Database window so that you can type in a new name, as shown in Figure 5-7. Type in the new name, and press Enter to save it.
Figure 5-7. Renaming a table in the Database window.
Tip
Get Microsoft® Office Access 2003 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.
