Office 2007 Bible

Manipulating Tables in a Database Window

As you create many tables in your database, you may want to use them in other databases or copy them for use as a history file. You may want to copy only the table structure. You can perform many operations on tables in the Navigation pane, including

• Renaming tables

• Deleting tables

• Copying tables in a database

• Copying a table from another database

You perform these tasks by direct manipulation or by using menu items.

Renaming tables

Rename a table with these steps:

1.	Select the table name in the Database window.
2.	Click once on the table name, and press F2.
3.	Type the new name of the table and press Enter.

You can also rename the table by right-clicking on its name in the Navigation pane, and selecting Rename from the shortcut menu. After you change the table name, it appears in the Tables list, which re-sorts the tables in alphabetical order.

Caution

If you rename a table, you must change the table name in any objects where it was previously referenced, including queries, forms, and reports.

Deleting tables

Delete a table by selecting the table in the Navigation pane and pressing the Delete key. Another method is by right-clicking a table and selecting Delete from the shortcut menu. Like most delete operations, you have to confirm the delete by selecting Yes in a confirmation dialog box.

Copying tables in a database

The copy and paste options in the Clipboard group on the Home tab allow you to copy any table in the database. When ...