SECTION 1
Lesson 1.3: Saving Your Files

   

 

 

We know that most things in Access are saved automatically, but you can perform a manual save of a particular database object.

Consider the data contained in the Northwind sample database:

 

 

If you click File à Save As with the Employees table selected like the picture above, the Save As dialogue box will appear:

 

 

In this example, you have the ability to save the Employees table as another table (making a 1:1 copy), a form, a report, or a data access page by clicking the pull-down arrow in the As field.

Object

What You can Save As

Tables

Table, Form, Report, Data Access Page

Queries

Query, Form, Report, Data Access Page

Forms

Form, Report, Data Access Page

Reports

Report, Data Access Page

Data Access Page

Data Access Page only

 

 

 

 

 

 

If we save the Employees table as a form, the new form is constructed and placed in the Forms section of the Database window under the name Copy of Employees (or another name if you give it a custom name):

 

As you can see, the Save As function is an even simpler version of the Forms wizard. All fields present in the table are listed, and the new form even includes a full listing of all customers the current employee has dealt with in the past.