Loading...

Access 2010: Multi-Table Queries, Part 1

65,325 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Apr 8, 2011

http://www.gcflearnfree.org/access2010

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.

If you are interested in learning more about this topic, please visit our site at http://www.gcflearnfree.org/access2010 to view the entire tutorial. It includes instructional text, informational graphics, examples, and even interactives for you to practice and apply what you've learned.

  • Category

  • License

    • Standard YouTube License

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...