Microsoft Office Tutorials and References
In Depth Information
Making Friends with the Access Window
Across the top is the Ribbon, the supermenu that all Microsoft Office programs
use. Below the Ribbon and to the right of the Navigation Pane (if any space is
left on your screen) is space for you to see and work with the various objects
that make up the database: tables, queries, forms, reports, and the rest.
If you’re used to Microsoft Office 2010 or 2007, you’re probably not alarmed
that Access has no menu bar — no File, Edit, . . . series of commands marching
across the top of the window. Instead, you see tabs and a bunch of buttons
at the top of the window: the Ribbon, which replaced the menu and toolbars
in Office 2007. It’s been freshened up for Office 2013 but is essentially the
Navigating the tabs
The Ribbon has five tabs that always appear, and additional tabs appear
when particular objects are open. The Fields tab, for example, is available
when a table is active. These additional tabs are known as contextual tabs.
The tabs that always appear are
✦ File: Clicking the File tab displays Backstage View, described in
“Introducing Backstage View,” later in this chapter.
✦ Home: The first button on the Home tab (shown in Figure 2-2) is View,
which allows you to change the view of the object displayed. You can
view an object in Design view to create and configure it and use other
views to actually use the object. The Home tab also contains buttons
used for dealing with records: formatting, creating new records, creating
totals, and spell checking, as well as sorting, filtering, and finding data.
We describe many of the buttons on the Home tab in Book II, Chapters 3
✦ Create: This tab is for — what else? — making new objects in your
database. Books II through VI and Book VIII describe how to create the types
of Access objects.
✦ External Data: This tab contains commands for importing and exporting
data and objects (see Book II, Chapter 4), collecting data via e-mail using
Outlook (see Book II, Chapter 4), and connecting and synchronizing with
SharePoint (see Book IX, Chapter 3).
✦ Database Tools: The Database Tools tab contains commands for running
macros (see Book VI), creating VBA modules (see Book VIII), creating
relationships between tables (discussed in Book II, Chapter 1),
documenting or analyzing your database (see Book VII, Chapter 1), connecting
your database to SharePoint or SQL Server (described in Book IX), and
performing other advanced tasks.