Microsoft Office Tutorials and References
In Depth Information
Perform a Simple Query
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
7 In the Available Fields list, click a
field that you want to include in
8 Click the Add button (
A The field appears in the Selected
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
Note: When using fields from two or
more tables, the tables must have a
0 Click Next .
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.