Queries VII: Query multiple sources for data
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 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.