Microsoft Office Tutorials and References
In Depth Information
Perform a Simple Query
17
CHAPTER
ACCESS
Adding, Finding, and Querying Data
The Simple Query Wizard opens.
6 Click the Tables/Queries and
choose the table containing the
fields on which you want to base
the query.
7 In the Available Fields list, click a
field that you want to include in
the query.
8 Click the Add button (
).
A The field appears in the Selected
Fields list.
9 Repeat Steps and to add more 8
fields to your query.
You can repeat Step to choose 6
another table from which to add
fields.
Note: When using fields from two or
more tables, the tables must have a
relationship.
0 Click Next .
TIP
What is a table relationship?
A table relationship enables you to combine related information for analysis. For example, you might define
a relationship between one table containing customer contact information and another table containing
customer orders. With that table relationship defined, you can then perform a query to, for example,
identify the addresses of all customers who have ordered the same product. To access tools for defining
table relationships, click the Database Tools tab on the Ribbon and then click Relationships . If you
created your database from a template, then certain table relationships are predefined.
323
Search JabSto ::




Custom Search