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 on our website. It includes instructional text, informational graphics, examples, and even interactives for you to practice and apply what you’ve learned.