Microsoft Access 2010 Bible

Chapter 2: Creating Access Tables

87

l (^) Append Data to Existing Table: Clicking the Append Data to Existing Table but-
ton adds the data of the selected table to the bottom of another table. This option is useful
for combining tables, such as when you want to add data from a monthly transaction table
to a yearly history table.
Follow these steps to copy a table:

1. Right-click the table name in the Navigation Pane and choose Copy from the shortcut
   menu, or click the Copy button in the Clipboard group on the Home tab.


2. Choose Paste from the shortcut menu, or click the Paste button in the Clipboard group
   on the Home tab.


3. Enter the name of the new table.

When you’re appending data to an existing table (see the next step), you must type the
name of an existing table.

4. Choose one of the Paste options — Structure Only, Structure and Data, or
   Append Data to Existing Table — from the Paste Table As dialog box.


5. Click OK to complete the operation.

Figure 2.32 shows the Paste Table As dialog box where you make these decisions.

FIGURE 2.32

Pasting a table opens the Paste Table As dialog box.

Copying a table to another database

Just as you can copy a table within a database, you can copy a table to another database. There are

many reasons why you may want to do this. Maybe you share a common table among multiple

systems, or you may need to create a backup copy of your important tables within the system.

When you copy tables to another database, the relationships between tables are not copied. Access

copies only the table design and the data to the other database. The method for copying a table to

another database is essentially the same as for copying a table within a database:

1. Right-click the table name in the Navigation Pane and choose Copy from the shortcut
   menu, or click the Copy button in the Clipboard group on the Home tab.