Microsoft Office Tutorials and References
In Depth Information
Notice that the query displays the fields from the Employer table, but in a different order.
For example, the first and last names of each contact, as well as the contact’s phone num-
ber, appear next to the employer name. This arrangement lets Elsa view pertinent contact
information without having to scroll through the table. Rearranging the display of table
data is one task you can perform with queries, so that table information appears in an
order more suited to how you want to work with the information.
4. Click the Close button
on the Query window title bar to close the Contacts query.
Even though a query can display table information in a different way, the information
still exists in the table as it was originally entered. If you opened the Employer table, it
would still show the fields in their original order.
Zack Ward, the director of marketing at NSJI, wants a list of all employers so that his
staff can call them to check on their satisfaction with NSJI’s services and recruits. He
doesn’t want the list to include all the fields in the Employer table (such as PostalCode
and NAICSCode)—only the employer’s contact information. To produce this list for Zack,
you need to create a query using the Employer table.
Creating, Sorting, and Navigating a Query
You can design your own queries or use an Access Query Wizard , which guides you
through the steps to create a query. The Simple Query Wizard allows you to select records
and fields quickly, and it is an appropriate choice for producing the employer list Zack
wants. You can choose this wizard either by clicking the New button to open a dialog box
listing several wizards for creating a query, or by double-clicking the “Create query by
using wizard” option, which automatically starts the Simple Query Wizard.
To start the Simple Query Wizard:
1. Double-click Create query by using wizard . The first Simple Query Wizard dialog box
opens. See Figure 1-10.
First Simple Query Wizard dialog box
default sourc e
for the query
field to the
Fields list box
to the Selected
Fields list box
r emoves all
Because Contacts is the only query object in the Seasonal database, it is listed in the
Tables/Queries box by default. You need to base the query you’re creating on the