Microsoft Access 2010 Bible

Chapter 2: Creating Access Tables

85

FIGURE 2.31

Printing options in the Print Table Definition dialog box

Tip
The Database Documenter creates a table of all the objects and object properties you specify. You can use this
utility to document such database objects as forms, queries, reports, macros, and modules.

Saving the Completed Table

You can save the completed table design by choosing File ➪ Save or by clicking the Save button in

the Quick Access toolbar in the upper-left corner of the Access environment. If you’re saving the table

for the first time, Access asks for its name. Table names can be up to 64 characters long and follow

standard Access object-naming conventions — they may include letters and numbers, cannot begin

with a number, and can’t include punctuation. You can also save the table when you close it.

If you’ve saved this table before and you want to save it with a different name, choose

File ➪ Save Object As and enter a different table name. This action creates a new table design

and leaves the original table with its original name untouched. If you want to delete the old table,

select it in the Navigation Pane and press the Delete key.

Manipulating Tables

As you add many tables to your database, you may want to use them in other databases or make cop-

ies of them as backups. In many cases, you may want to copy only the table’s design and not include

all the data in the table. You can perform many table operations in the Navigation Pane, including

l (^) Renaming tables
l Deleting tables