Joining Tables|Linking Data With Queries|Linking Data Using The Lookup Wizard|Outer Joins|Indirect Joins|Joining Tables With No Common Fields|Relating Data Within a Table
This Video On Demand teaches Access users how to join data from tables to return accurate information. The video explains how to design a query pulling data from multiple tables to produce in-depth, related information. Viewers learn how to link data using the Lookup Wizard. They also learn about outer joins, indirect joins and how to join tables with no common fields. Clear, step-by-step directions explain the procedures to accomplish all the tasks. The video can be paused and reversed to give viewers control over the pace of learning. A quiz follows the video to test the viewer’s comprehension. This video is perfect for Access users who are familiar with queries and who need to manipulate data efficiently.