Using Queries to Make Data Meaningful - Part 1

In Access queries let you retrieve information from one or more tables on a set of defined search conditions. Learn how to use queries in Access here.

Planning a query

There are three questions you need to answer when planning a query:

Planning: Which customers ordered technology books?

Let's think about this process for our bookstore database scenario. We have a new technology series coming out soon, and we want to send coupons to customers who have ordered technology books from us in the past. A query can help us answer the question, Which customers have ordered technology books from us already? Let's use the three-question process to plan this query.

Query ConditionCriteria of the Query Condition