Query multiple record sources

Using Query Wizard

Finally, you can use multiple tables, or other queries, as the record source for a new query. In fact, you'll query multiple record sources far more than you will single sources. Multi-source queries are how you answer questions such as which assets came from which suppliers.

The Query Wizard is the easiest way to get started building multi-source queries, especially if you're new to Access.

Note    Remember that any tables in the record source must participate in a relationship. For example, you can't extract the names of your employees from one source and the assets that they use from another unless those tables are related. If the tables in your record source aren't related, the query returns all the data from each table, and that kind of result has extremely limited uses.

  1. On the Create tab, in the Queries group, click Query Wizard.

  2. Complete the wizard. As part of that process, select the tables and fields you want to use as your record source, and ...

  3. Give your new query a descriptive name, and remember to avoid using spaces in the name.

You'll get a chance to try the Query Wizard during the practice, so keep going.

Topic 7 of 9

Previous | Next

(Back to Start)

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!