Microsoft Access 2010 Bible

Chapter 6: Working with Datasheet View

219

FIGURE 6.2

The Navigation buttons of a datasheet

First New record

Previous Last

Record number box Next

Examining the Datasheet ribbon

The Datasheet ribbon (shown in Figure 6.3) provides a way to work with the datasheet. The Home

ribbon has some familiar objects on it, as well as some new ones. This section provides an over-

view of the groups on the ribbon; the individual commands are described in more detail later in

this chapter.

Cross-Reference
I explain ribbons in Chapter 29.

FIGURE 6.3

The Datasheet ribbon’s Home tab

Sort & Filter group

Filter by Selection button

Advanced Filter Options button

Records group Datasheet Formatting button

Views

The Views group allows you to switch between Datasheet view, PivotTable view, PivotChart view,

and Design view. You can see all four choices by clicking the View command’s downward-pointing

arrow. Clicking Design View permits you to make changes to the object’s design (table, query, and

so on). Clicking Datasheet View returns you to the datasheet.