Build database - access database template

:: Introduction
:: Database principles
:: Tables
:: Queries
:: Data security
:: Glossary
:: Resources
:: Student Files
:: Contact
:: Back to Main Site
:: Site Map

Microsoft Access - Class 2 - Part III

> Back

How would you make a backup copy of a table with the data in it?

1)	Select the table you want to back up.
2)	Go to File, Save As
3)	Verify if name given by Access is what you want to use. The default for copies is "CopyofTablename" (i.e. copy of EmployeeTable would be CopyofEmployeeTable.)
4)	Click on OK.
5)	You will find the table in the same database under the name you have chosen. It will contain all the data from your original table.

Please note that this technique works only if you don't open the table. You should simply select the table to be copied in your database window. If you open your table in the datasheet view, you will only be able to save it as a form, report or web page, but not as a table.

Print this page

> Top