Access 2010: Mult-Table Queries, Part 1

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
5,817
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Apr 8, 2011

http://www.GCFLearnFree.org

In a typical database, a single table doesn't show you the complete picture. That's because related data is often spread out through several different tables. With a query, you can pull in data from multiple tables to answer questions.

For example, to find customers who have placed orders at our bakery, we would use the Orders table to get the ID for each customer who has placed an order, and we would also need the Customers table to get each customer's name and contact information. We wouldn't be able to do this by looking at one of the tables by itself, but we can use a query to look at both tables at the same time.

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (2)

Sign In or Sign Up now to post a comment!
Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more