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.
@pacificresonance Glad we could help! ^Jess
gcflearnfree 2 months ago in playlist Microsoft Access
This video saved my life the other day on a project!
pacificresonance 3 months ago