How to Create a Microsoft Access Query That Uses More Than 1 Table

Video Transcript

"Hi my name is Chip Browne. I teach computer programming and also Microsoft Office Application classes at a local business college here in Utah at Steven Henagar Business College and I also create practice tests for Microsoft Office Applications Specialist Certifications. Today we are going to learn how to create a query that uses more than one table. Microsoft Access is a registered trademark of Microsoft Corporation. I am not affiliated with Microsoft Access. To create a query that is based upon more than one table you can do it in many ways. One way is using the Query Wizard. To access the Query Wizard click on the create tab. In the other group click on Query Wizard. Next, choose simple Query Wizard. Here we choose fields from one table. Next, we choose a different table and we choose fields from that table. You can choose detail or summary. Detail shows every field of every record. We can title the query and open it to view its information. Here is the results of the Query showing fields from each table. Another way to create a query based upon fields from more than one table is by going into query design. Click on the create tab and the other group click query design. Here, we're supposed to find the tables that we want to run in our query. As you can see the relationships which have been previously set up are automatically displayed. Next, we choose what field we would like to be part of our query. I can select them using the shift click and then drag them down as a group to the lower part of the query design window and release. Same thing for the other table. Click and shift click. Click to drag and release. Now we can run our query. Here's the result of our query displaying fields from more than one table. That is two ways on how to create a query based upon more than one table. For more information in videos visit www.chipbrowne.com. That's Browne with an "e"."