Microsoft Office Tutorials and References
In Depth Information
New Query dialog box
option to design
your own query
You’ll design your own query instead of using a Query Wizard.
3. If necessary, click Design View in the list box.
4. Click the OK button. Access opens the Show Table dialog box on top of the Query window.
(Note that you could also have double-clicked the “Create query in Design view” option in
the Database window.) Notice that the title bar of the Query window shows that you are
creating a select query.
The query you are creating will retrieve data from the Employer table, so you need to add
this table to the Select Query window.
5. Click Employer in the Tables list box (if necessary), click the Add button, and then click the
Close button. Access places the Employer table’s field list in the Select Query window and
closes the Show Table dialog box.
To display more of the fields you’ll be using for creating queries, you’ll maximize the Select
6. Click the Maximize button
on the Select Query window title bar. See Figure 3-2.
Select query in Design view
Query Type button
shows select query