Page 1 of 13PREVNEXT

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.

About this course

This course includes:

  • One self-paced lesson and one practice session for hands-on experience. The practice requires Access 2007.
  • A short test at the end of the lesson; the test is not scored.
  • A Quick Reference Card you can take away from the course.

Goals

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

To complete this course, you need to be familiar with select queries, referential integrity and table relationships, and selection criteria. If you aren't, take the courses listed in the prerequisites, and then come back to this course.


The first six courses in this series explained how to build select queries that take data from a single record source. This course shows you how to query multiple record sources.

Querying two or more record sources is a common databasing task. For example, say your boss needs sales data from last month — who sold what, and how much. In a properly designed database, you'd answer that question by querying several tables, such as Employees, Orders, and Products.

As part of that, you may also need to create joins, associations between the fields in your record sources. We'll show you what joins are and how to use them.

To learn more about this course, read the text in Goals and About this course, or look at the table of contents. Then click Next to start the first lesson.

Page 1 of 13PREVNEXT