Microsoft Office Tutorials and References
In Depth Information
The Query Wizard —
Choose Columns page
appears.
8
Click the table and/or
fields you want to
import.
9
8
9
Click the Add button.
If you want to open
more than one table
or field repeat Steps 8
and 9.
0
Click Next.
0
The Query Wizard — Filter Data page
appears.
!
Click the column by which you want to
filter.
@
Click here and select a comparison
operator.
@
#
Click here and select the criterion by
which you want to filter.
#
!
You can apply additional filters.
l
$
Click Next.
$
Important!
In this task, you click the New Database Query
button ( ) to access the Choose Data
Source dialog box. The task assumes you have
installed the New Database Query button on
the Quick Access toolbar. See Task #95 to
learn how to add commands to the Quick
Access toolbar.
Did You Know?
You use the Choose Data Source dialog box
to import an Access database. To open the
Choose Data Source dialog box, place the
New Database Query button on the Quick
Access toolbar or click the Data tab, click From
Other Sources, and then click From Microsoft
Query.
Chapter 9: Extend Excel
209
 
Search JabSto ::




Custom Search