Microsoft Office Tutorials and References
In Depth Information
You’ve defined the fields for the Position table and specified its primary key, so you can
now save the table structure.
Saving the Table Structure
The last step in creating a table is to name the table and save the table’s structure on disk.
Once the table is saved, you can use it to enter data in the table.
Saving a Table Structure
Click the Save button on the Table Design toolbar.
Type the name of the table in the Table Name text box of the Save As dialog box.
Click the OK button (or press the Enter key).
According to Elsa’s plan, you need to save the table you’ve defined as “Position.”
To name and save the Position table:
1. Click the Save button
on the Table Design toolbar. The Save As dialog box opens.
2. Type Position in the Table Name text box, and then press the Enter key. Access saves the
table with the name Position in the Northeast database. Notice that Position now appears
instead of Table1 in the Table window title bar.
Recall that in Tutorial 1 you set the Compact on Close option for the Seasonal database
so that it would be compacted automatically each time you closed it. Now you’ll set this
option for your new Northeast database, so that it will be compacted automatically.
( Note : If you are working from a floppy disk, check with your instructor or technical sup-
port staff to confirm that you should set this option.)
To set the option for compacting the Northeast database automatically:
1. Click Tools on the menu bar, and then click Options . The Options dialog box opens.
2. Click the General tab in the dialog box, and then click the Compact on Close check box to
3. Click the OK button to set the option.
The Position table is now complete. In Session 2.2, you’ll continue to work with the
Position table by entering records in it, modifying its structure, and maintaining data in
the table. You will also import two tables, Employer and NAICS, from the Seasonal data-
base into the Northeast database.