graphic2
graphc1

Exam 77-424: Microsoft Access 2013
2.0 Build Tables
2.1 Create a Table: Create a Copy of a Table

Copy and Paste a Table

Before manipulating any data in the Tables, it is a wise precaution to create a COPY of the Table. So, a word to the wise!

 

Before You Begin: Select an Object

Go to All Access Objects->Tables.

Select a Table: tblCustomers

 

1. Try it: Copy and Paste a Table 
Go to Home->Clipboard->Copy.

 

Try This, Too: Paste the Table

Go to Home->Clipboard->Paste.

 

You will be prompted to enter the following:

Table Name: Copy of tblCustomers

Paste Options: Structure and Data

 

What Do You See? You can choose to keep the Table Structure only, without the Data if you wish. This is a good way to purge any sample records.

 

Click OK.

Keep going...

Home->Clipboard->Copy

pic1