Page 112 - Excel Data Analysis

06 537547 Ch05.qxd 3/4/03 12:11 PM Page 98

EXCEL DATA ANALYSIS

USING QUERIES TO SCREEN

EXTERNAL DATABASES (CONTINUED)

ou can use the Query Wizard to design a query The most useful feature of the Query Wizard is the
definition for a selected database. The Query Wizard database filter, which limits Excel to import only those
Y lets you select the columns you want to import from records that meet specific criteria. Although this is not a
each table in the database. You can also create filters for the necessary step, if you do not filter the data, Excel imports
data as well as specify how to sort the data as it imports the entire database. You can create up to three definitions
into Excel. for any of the selected columns, but if you have more than
one filter, you must specify how to join the definitions.
You can import any combination of columns from the
database. Excel imports the columns into your worksheet in You join definitions with either an And or an Or option. If
the order you list them in the Columns in your query box you select And, the record value in the selected column
in the Choose Columns page of the Wizard. The first column must meet both of the filter requirements before Excel
in the box imports as the first column in your worksheet. imports the data.
You can reorder the columns by moving them up or down in If you join the filter definitions with Or, only one of the
the list.
definitions must be true before Excel imports it.

USING QUERIES TO SCREEN EXTERNAL DATABASES (CONTINUED)

UnitPrice UnitPrice
is greater than

■ The columns within the ‚ Click the Select button to ■ The Filter Data page of the ¡ Select the desired filter
table display under the add the column to your query Query Wizard displays. operation from the available
selected table name. box. list.
± Click the column you
· Click a column name. ■ Repeat steps 9 and 10 for want to filter.
each column you want to
import.
— Click Next.
98