Microsoft Office Tutorials and References
In Depth Information
Taking Tips on Creating a Query
Navigating Design view
You can work in Design view by using the mouse (to click the pane that you
want) and the scroll bars (to see parts of the view that don’t fit onscreen). If
you prefer, you can use the keyboard to move around.
The keys listed in Table 1-3 move you around Design view.
Table 1-3
Shortcut Keys in Design View
What It Does in the
Table Pane
What It Does in the
Design Grid
Moves to the next table
Moves to the next row to the
Moves to the previous table
Moves to the next row to
the left
Alt+ or F4
Displays the drop-down
menu (if the row has one)
Page Down
Displays more field names in
the active table
Displays more OR criteria
Moves to the top of field
Moves to the first column in
the grid
Displaying or hiding table names
You can view table names for each field in the query design in the Table row,
or you can choose not to see the Table row.
To make the Table row appear or disappear, use one of these methods:
Right-click the design grid and choose Table Names from the contextual
Click the Table Names button in the Show/Hide group on the Design tab
of the Ribbon.
Taking Tips on Creating a Query
The “Creating a Query in Design View” section, earlier in this chapter, includes
the basics on creating a query in Design view, but you can do much more.
This section delves into a few more aspects of the query-creation story.
Search JabSto ::

Custom Search