Save a Copy of the Table

Good database administrators do not lose data. Before editing a Table in any working database, it is a wise precaution to create a backup copy of that Table.

 

3. Try it: Save a Copy of the Table

The Movie Table may still be open, if not..

Go to All Access Objects->Tables.

Open a Table: tblMovies.

 

Try This, Too: Save a Copy

Go to File->Object As.

Enter a name: Copy of tblMovies 8-8-2012,

where 8-8-2012 is the current date of the backup copy.

 

Click OK. Now, click on the Home Ribbon to see the database Objects.

Close the Copy of tblMovies 8-8-2012 Table..

 

There is a current backup copy of the data. Now...we can keep going...

File ->Save Object As

Exam 77-885: Microsoft Access 2010

1. Managing the Access Environment

1.1. Create and manage a database: Save Object As