Online Training | 800‑258‑3837
Back to Course List

Microsoft Access 2010: Joining Tables

Preview video
Preview Video
Product ID
soniajta_vod
Training Time ?
65 to 70 minutes
Language(s)
English
Video Format
High Definition
Required Plugins
None
Number of Lessons
7
Quiz Questions
5
Question Feedback
Wrong Answer Remediation
Lesson Bookmarking
Course screen Course screen Course screen
Overview

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. Users learn to relate data within a table properly. Common pitfalls to avoid are discussed.

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.

Video on Demand   This course is in the Video On Demand format, to read about Video On Demand features click here.

  • Install on any SCORM LMS
  • Full-screen video presentation
  • Print certificate and wallet card
  • You have 30 days to complete the course
Audience

Microsoft Access users

Topics
The course presents the following topical areas:
  • 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

© Mastery Technologies, Inc.