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.

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.

• Build relationships for a new Access 2007 database
• Queries II: Create basic select queries
• Queries III: Use expressions and other criteria