Microsoft Office Tutorials and References
In Depth Information
Viewing Objects in Your Database
Viewing lots of objects at the same time
You can open more than one object at the same time. You can open a table
in Datasheet view, for example, to look at your data while you’re working in
Design view to create a form for editing that data.
There are two ways to view multiple objects in Access:
✦ Overlapping windows: Access 2003 and earlier versions use this
system, in which each object appears in its own window within the
Access window, as discussed in “Creating, Deleting, Renaming, Copying,
and Printing Objects,” later in this chapter. You can resize windows and
move them around in whatever arrangement you like. If you like
overlapping windows, and your copy of Access is set to Tabbed documents
(described next), you can. Click the File tab to display Backstage View;
choose Options; and then, in the Access Options dialog box, choose
Current Database. In the Application Options section, set Document
Window Options to Overlapping Windows.
✦ Tabbed documents: Access 2007 instituted a new way of arranging the
objects that you have open. Each object appears with an object tab
that bears its name. When you click the object tab, you see that object.
Figure 2-2, earlier in this chapter, shows tabbed documents.
If Access is set to Overlapping Windows, and you want to use tabbed
documents, you can. Click the File tab to display Backstage View, choose
Options, and choose Current Database in the Access Options dialog box. In
the Application Options section, set Document Window Options to Tabbed
After you open an object, you can look at it in a different view. Here are
✦ Click the View button on the Home tab of the Ribbon. (It’s the only
button in the Views group.) This button switches between the current
view and the most recently displayed view.
✦ To choose among all the available views for the object, click the bottom
half (the little arrow) of the View button and choose a view from the
✦ Click one of the View shortcuts (shown in Figure 2-2) at the right end of
the status bar, in the bottom-right corner of the Access window. Each
view has a button; hover your mouse over a button to see the name of
✦ Right-click the object tab and choose the view you want from the