Designing a Multi-Table Query in Access 2013
Most queries you design in Access will likely use multiple tables
Designing a Multi-Table Query in Access 2013 we will utilize an example database. In the event that you might want to take after along, you’ll have to download our Access 2013 example database. You should approach Access 2013 introduced on your PC keeping in mind the end goal to open the case.
Planning a multi-table inquiry
Inquiries can be hard to comprehend and construct in the event that you don’t have a smart thought of what you’re attempting to discover and how to discover it. A one-table question can be sufficiently straightforward to make up as you go along but to manufacture much else effective you’ll have to designing the query in progress.
Arranging a question
When arranging a question that utilization in excess of one table, you ought to experience these four stages:
Pinpoint exactly what you need to know. On the off chance that you could ask your database any inquiry, what might it be? Building an inquiry is more convoluted than simply making an inquiry, yet knowing definitely what question you need to answer is fundamental to building a helpful inquiry.
Identify every kind of data you need to be incorporated into your inquiry comes about. Which fields contain this data?
Locate the fields you need to incorporate into your inquiry. Which tables would they say they are contained in?
Determine the criteria the data in each field needs to meet. Consider the inquiry you asked in the initial step. Which fields do you have to look for particular data? What data would you say you are searching for? By what means will you scan for it?
This procedure may appear to be unique at, to begin with, however as we experience the way toward arranging our own particular multi-table inquiry you should begin to see how arranging your inquiries can make building them a great deal less demanding.
Planning our query
Let’s go through this planning process with a query we’ll run on our bakery database. As you read through the planning process step by step, think about how each part of the planning process could apply to other queries you might run.
Step 1: Pinpointing the question we want to ask
Our bakery database contains many customers, some of whom have never placed an order but who are in our database because they signed up for our mailing list. Most of them live within the city limits, but others live out of town or even out of state. We want to get our out-of-town customers who’ve placed orders in the past to come back and give us another try, so we’re going to mail them some coupons. We don’t actually want our list to include customers who live too far away; sending a coupon to someone who doesn’t live in our area probably won’t make that person come in. So we just want to find people who don’t live in our city but who still live in our area.
In short, the question we want our query to answer is this: Which customers live in our area, are outside the city limits, and have placed an order at our bakery?
Designing a Multi-Table Query in Access 2013 we will utilize an example database. In the event that you might want to take after along, you’ll have to download our Access 2013
To read more about Office Products and Designing visit Office.com/setup