Datasheet

Figure 1-16 The Query By Design interface.
For this example, select the following three fields: Branch_Num, Cus-
tomer_Name, and State. To select fields from the top half of the QBD, you can
either double-click the field or click it once and drag it down to the bottom
half. Now that field will be included in the output of the query. Figure 1-17
shows you how the Query By Design should look after selecting the output
fields.
Running a query
At this point, you have all you need to run the query. You can run a query from
the QBE in two ways. Either select Query/Run or click the red exclamation
point in the toolbar. As you can see from Figure 1-18, the output from a query
looks similar to a regular table after it is open.
Figure 1-17 The lower half of the Query By Design interface
shows the output fields of the select query.
Access Basics 27
05_59978X ch01.qxp 12/1/05 7:46 PM Page 27