Multi Table Query In MS Access On Multiple Tables

Learning about how to make a query with a single table and to add more tables to the query database will not make any progress to your skill if you don’t challenge yourself to exercise on the program and get yourself use to run it. If you feel comfortable enough to run the one table query, then the multi table one will be just as fun. Now getting ready, you should follow the instruction below.

multi table query access

multi table query access


access query multiple tables same fields

access query multiple tables same fields


1. First you need to open the Access 2016 and then to the practice sample database. Remember to open the database you can click File on the Ribbon that will lead you to backstage and then click Browse, then you can double click the sample database.

2. Create a new query. Remember the way to create query is located on the Create group and you can click Query Design command. Click that and you will be directed to the dialogue bar to choose what table you want to work with.

3. Choose the Customer and Orders table by clicking on both table then click Add, after that Close the dialogue box.

4. Now try to change the join direction by double clicking the arrow from “left to right” into “right to left”.

5. Choose the field dialogue bar with 3 fields from Customer table which are First Name, Last Name, and Zip Code, while from the Orders table you chose the Paid field.

6. Leave the Sort row, and move to the Criteria. In the Zip Code criteria, type 27609 to sort only the customers coming from this Zip Code 27609. Then in the Paid field you type “Yes” to sort only those who had paid their order.

7. Click Run in the Design tab on the Ribbon and if you enter all the right instruction you will find 20 name of customer who live in the Zip Code area 27609 and already paid the orders. If not then you need to check back and see if the arrow is right pointing.

8. Then save the query with the name Paying Customer in 27609. Remember you can do the saving by Quick Access Toolbar or by command Ctrl + S.

Try to work with different types of tables provided in the sample database before you start working on your own objects. Remember that it is important to map the points you want to get from this query. What is the purpose, where you can find the fields and how will you expect the result?

Source Tags: , , , , , , , , .

Multi Table Query In MS Access On Multiple Tables | access2016 | 4.5