Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1

70 Excel


Now that you’ve started the Query Wizard, you are free to select the vari-
ous fi elds that you’ll import into Excel. The box on the left of the wizard
shown in Figure 2-25 shows the tables in the database. As you expected,
there are two: Nutrition and Product. By clicking the plus box in front of
each table name, you can view and select the specifi c fi elds that you’ll im-
port into Excel. Try this now by selecting fi elds from both tables.

To select fi elds for your query:

1 Click the plus box [ 1 ] in front of the Product table name.
A space opens beneath the table name displaying the names of each
of the fi elds in the table.
2 Double-click the following names in the list:
Brand
Food
Price
Package oz
Serving oz
As you double-click each fi eld name, the name appears in the box
on the right, indicating that they are part of your selection in the
query. Note that you do not select the Product ID fi eld. This fi eld is
the common fi eld between the two tables and contains a unique id
number for each wheat product. You don’t have to include this in
your query.
3 Click the plus box [+] in front of the Nutrition table name and then
double-click the following fi eld names:
Calories
Protein
Carbohydrates
Fat
Once again, you do not select the common fi eld, Product ID. Your
dialog box should appear as shown in Figure 2-26.
Free download pdf