Microsoft Office Tutorials and References
In Depth Information
Viewing Objects in Your Database
Sorting objects in the Navigation Pane
You can sort objects within a group in the Navigation Pane by right-clicking
the title bar of the Navigation Pane or the empty space at the bottom of
the Navigation Pane, choosing Sort By from the contextual menu, and then
choosing an option from the submenu. You can select a sort order (ascending
or descending) and an attribute to sort by (Name, Type, Created Date, or
Modified Date). You can also choose Remove Automatic Sorts (the last
choice on the menu).
Book I
Chapter 2
Searching for an object
If your database contains dozens or even hundreds of objects, they can
be hard to find. Luckily, the Navigation Pane includes a Search bar, which
appears just below the title of the Navigation Pane. You can type words and
press Enter to find objects that contain those words in their titles.
If the Search bar doesn’t appear, right-click the Navigation Pane’s title bar
and choose Search Bar from the contextual menu. Repeat this procedure to
make the Search bar go away.
Viewing Objects in Your Database
Chapter 1 of this minibook describes the six kinds of objects that make up an
Access database: tables, queries, forms, reports, macros, and VBA modules.
(No, you don’t have to memorize this list!) When you open an object to work
with it, you choose which view, or onscreen format, to display it in. You can
open a table in Design view to design the fields that make up the table, for
example, or you can open it in Datasheet view to enter and edit the data in the
table. This entire topic describes how to use views to create and configure
objects and then use them to manage your data.
When you double-click an object’s name in the Navigation Pane, Access
opens the object in the default view for that type of object. For tables, for
example, the default view is Datasheet, because after you create a table,
you’re likely to want to type records in it.
To close an open object, click the X to the right of the object tab when the
object is active, or right-click the tab and choose Close from the contextual
Search JabSto ::

Custom Search