Microsoft Office Tutorials and References
In Depth Information
Query an
ACCESS DATABASE
The Query Wizard is part of Microsoft Query, a
separate application that comes with Microsoft Office.
Microsoft Query is an application that makes it easy
for you to generate queries in Structured Query
Language (SQL), a standard in the corporate world.
The Query Wizard provides a point-and-click interface
for importing tables or selected columns into
Microsoft Excel. Once you have selected the columns
or tables you want, you can filter and sort. The
Query Wizard provides 16 filter criteria from which
you can choose. In addition, you can create multiple
filters by using and and or .
Use or when you want the wizard to select data
that meets either condition. For example, ask the
wizard to select all dresses that are blue or have red
buttons. The wizard returns every blue dress and
every dress with red buttons. Alternatively, ask the
wizard to select all dresses that are blue and have
red buttons. The and selection criterion is more
restrictive. The wizard only returns items that meet
both selection criteria: blue dresses with red buttons.
1
1
Click the New Database Query
button.
Note: You must add the New
Database Query button to the
Quick Access toolbar. See Task
#95 to learn how to customize the
Quick Access toolbar.
The Choose Data Source dialog
box appears.
2
3
4
2
Click the Databases tab.
3
Click MS Access Database.
4
Click OK.
The Select Database dialog box
appears.
5
Click to locate the folder in
which you stored your database.
6
Click to select your database.
7
7
Click OK.
6
5
208
Search JabSto ::




Custom Search