802 Chapter 26 Create Databases and Simple Tables
Tip You can rename a table by right-clicking it in the Navigation pane and then clicking
Rename. You can delete a table by right-clicking it, clicking Delete, and then confirming
the deletion in the message box that appears. (You can also delete a table by selecting
it in the Navigation bar and then clicking the Delete button in the Records group on
the Home tab or pressing the Delete key.)- In the Navigation pane, click the Customers table to select it.
- On the Home tab, in the Clipboard group, click the Copy button. Then click the
Paste button.
Keyboard Shortcuts Press Ctrl+C to copy data. Press Ctrl+V to paste data.
The Paste Table As dialog box opens.
If you need to create a table that is similar to an existing table, it is sometimes easier
to customize a copy than to create it from scratch.- In the Table Name box, type Employees. In the Paste Options area, click
Structure Only to capture the fields from the Customers table but none of
the customer information. Then click OK.
The new Employees table appears in the Navigation pane.
Tip You can also use the Copy and Paste commands to append the information in the
selected table to another existing table. In that case, in the Paste Table As dialog box,
type the name of the destination table in the Table Name box, click Append Data To
Existing Table, and then click OK. - Double-click Employees to open it in Datasheet view so that you can view its
fields. Then close the table again.