Microsoft Access 2010 Bible

Part I: Access Building Blocks

136

The Show Table dialog box (refer to Figure 4.5) displays all tables and queries in your database.

Double-click on tblProducts to add it to the query design, or highlight tblProducts in the

list and click the Add button. Close the Show Table dialog box after adding tblProducts. Figure

4.6 shows tblProducts added to the query.

FIGURE 4.6

The query design window with tblProducts added

Field list Table/Query pane

Query by Example grid

To add additional tables to the query, right-click on the anywhere in the upper portion of the

query designer and select Show Table from the shortcut menu that appears. Alternatively, drag

tables from the Navigation Pane to the upper portion of the query designer. There is also a Show

Table button on the Design ribbon tab.

Removing a table from the query designer is easy. Just right-click on the table in the query designer

and select Remove Table from the shortcut menu.

The query window has three primary views:

l Design view: Design view is where you create the query.

l (^) Datasheet view: Datasheet view displays the records returned by the query.
l SQL View: The SQL View window displays the SQL statement behind a query.
The Field List window (or, more simply, the Field List) contains the names of all the fields in the
selected table or query. A Field List can be resized by clicking on the edges and dragging it to a dif-
ferent size. You may want to resize a Field List so that all of a table’s fields are visible.