Microsoft Office Tutorials and References
In Depth Information
Creating, Deleting, Renaming, Copying, and Printing Objects
Creating, Deleting, Renaming, Copying,
and Printing Objects
Throughout this topic, we tell you how to create and modify tables, forms,
reports, and other Access objects by using the Navigation Pane. Several
tasks that work the same way for all Access objects crop up time and time
again, so you may as well find out about them right here:
✦ Creating an object: Click the appropriate button on the Create tab of the
Ribbon (see Figure 2-4). You usually see options to create the object by
running a wizard that steps you through the process or by using Design
view — a window with settings for designing the object.
tab of the
See Book II, Chapter 1 for information about creating tables; Book II,
Chapter 2 for more on Design view; Book III for queries; Book IV for forms;
Book V for reports; Book VI for macros; and Book VIII for VBA modules.
✦ Deleting an object: Select the object in the Navigation Pane, and press
the Delete key. Simple enough! Clicking the Delete button on the Home
tab of the Ribbon works, too, as does right-clicking the object and then
choosing Delete from the contextual menu. Access asks whether you’re
really, truly sure before blowing the object away. Just remember that
when you delete a table, you delete all its data, too.
✦ Renaming an object: Click the name of the object and press F2, or
rightclick the name and choose Rename from the contextual menu. Either
way, a box appears around the object’s name. Type a new name, and
press Enter. Press Esc if you change your mind.
✦ Copying an object: Select the object you want to copy, press Ctrl+C,
move your cursor to where you want to create the copy, and press
Ctrl+V. (The Copy and Paste buttons in the Clipboard group on the
Home tab of the Ribbon work too.) Access displays a Paste As dialog
box, asking what name to use for the copy. Type a name, and click OK.
When you’re creating a form or report, modifying a copy of an existing
report is faster than starting a new one from scratch.
✦ Printing an object: Select or open the object you want to print and then
press Ctrl+P. Alternatively, click the File tab on the Ribbon to display
Backstage View, click Print, and choose one of the following options: