Queries VII: Query multiple sources for data

Learn how to query multiple data sources

Learn how to create a query that takes data from two or more sources — tables or queries. You'll probably need to query multiple sources more than you will single tables or queries. The key to doing that is making sure you can join, or associate, the fields in the tables or queries in your record source.

Start course button

About this course

This course includes:

  • One practice session for hands-on experience. The practice requires Access 2007.

  • A Quick Reference Card you can take away from the course.


After completing this course you will be able to:

  • Build queries that retrieve data from more than one source — tables or queries.

  • Change join types.

  • Use an outer join to find additional data.

  • Add and remove joins.

Before you begin

Topics in this section

  1. Query multiple sources

  2. Rules for using joins

  3. Relationships vs. joins

  4. About inner joins

  5. About outer joins

  6. Query using an inner join

  7. Query using an outer join

  8. Adding joins to queries

  9. Use an indirect join

  10. Practice

  11. Quick reference card

Applies To: Access 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language