Microsoft Office Tutorials and References
In Depth Information
2. Click the Tables/Queries list arrow, and then click Table: Employer to select the Employer
table as the source for the new query. The Available Fields list box now lists the fields in the
You need to select fields from the Available Fields list box to include them in the query.
To select fields one at a time, click a field and then click the button. The selected
field moves from the Available Fields list box on the left to the Selected Fields list box on
the right. To select all the fields, click the button. If you change your mind or make a
mistake, you can remove a field by clicking it in the Selected Fields list box and then
clicking the button. To remove all selected fields, click the button.
Each Simple Query Wizard dialog box contains buttons on the bottom that allow you
to move to the previous dialog box (Back button), move to the next dialog box (Next but-
ton), or cancel the creation process (Cancel button) and return to the Database window.
You can also finish creating the object (Finish button) and accept the wizard’s defaults for
the remaining options.
Zack wants his list to include data from only the following fields: EmployerName, City,
StateProv, ContactFirstName, ContactLastName, and Phone. You need to select these
fields to include them in the query.
To create the query using the Simple Query Wizard:
1. Click EmployerName in the Available Fields list box, and then click the
EmployerName field moves to the Selected Fields list box.
2. Repeat Step 1 for the fields City , StateProv , ContactFirstName , ContactLastName , and
Phone , and then click the Next button. The second, and final, Simple Query Wizard dialog
box opens and asks you to choose a name for your query. This name will appear in the
Queries list in the Database window. You’ll change the suggested name (Employer Query)
3. Click at the end of the highlighted name, use the Backspace key to delete the word
“Query” and the space after “Employer,” and then type List . Now you can view the query
4. Click the Finish button to complete the query. Access displays the query results in
5. Click the Maximize button
on the Query window title bar to maximize the window. See