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)

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.