Free E-Books

Switch between the upper and lower panes by clicking the desired pane or by pressing F6 to
switch panes. Each pane has horizontal and vertical scrollbars to help you move around.
You actually build the query by dragging fields from the upper pane to the QBE grid.
Using the Query Design ribbon
The Query Design ribbon (shown in Figure 4-6) contains many different buttons specific to building
and working with queries.
FIGURE 4-6
The Query Design ribbon
130
Access Building Blocks Part I
This ribbon has many buttons that can be helpful when designing your queries. Although each
button is explained as it is used in the chapters of this book, here are the main buttons:
n View: Switches between the Datasheet view and Design view. The View drop-down control
also enables you to display the underlying SQL statement behind the query (more on
this later).
n Save (in the Quick Access Toolbar): Saves the query. It is a good idea to save your work
often, especially when creating complex queries.


Pages:
405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429