Access: Multi-table Queries (Part 1)

In this video, you’ll learn the basics of using multi-table queries in Access 2019, Access 2016, and Office 365. Visit edu.gcfglobal.org/en/access/d... for our text-based lesson.
This video includes information on:
• Planning a query
• Identifying the question to ask and the information needed
• Locating the tables containing the necessary information
• Determining criteria the query should search for
• Joining tables in queries
• Creating multi-table queries
We hope you enjoy!

[@jhumkibanerjee2713]

Thanks, I have practicals today. You made my day🖖

[@soldier2gud4me]

You guys are the best. Saved my time with your tip on 2:52 subscribed

[@luwaarosina8511]

thanks you made my day ,good explanation .

[@samm6626]

Great memorable criteria thank you

[@taliahjohnson8460]

What do I do if i'm not seeing a join even though i have two tables

[@MMchannels]

very helpful

[@cybergen49]

So helpful :wink:

[@anacarolapers]

I need to create a query for the customer table that lists all states in ascending order. Each state should appear only once. No problem with the ascending order but I do not know how to make it appear only once.

[@GCFLearnFree]

It sounds like you may need a totals query. A totals query can aggregate the data for each state, which will allow you to have a single row for each state. This lesson has more information about totals queries: www.gcflearnfree.org/access2016/more-query-design-options/4/. We hope it helps!

[@joelavacca4894]

Helpful but how can this work with 3 tables without already having the relationship. You had the relationship set up before you added the tables.

[@GCFLearnFree]

Generally, table relationships will be added as part of the database design process, and they would need to be in place before creating multi-table queries. Table relationships are a big topic, but this article goes over some of the main concepts: www.techrepublic.com/article/relational-databases-defining-relationships-between-database-tables/. We hope it helps!

[@mamatashrestha2949]

can you mention the sql query command to perform these filter

[@GCFLearnFree]

The SQL query is actually very long because we are selecting a number of different fields. However, you can see it by clicking the View drop-down arrow and selecting SQL View. While it’s possible to write queries from SQL View, our tutorials focus on building them in Design View. Hope this helps!

[@mauriciovargas5076]

Very good explanation but it is not necessary to have the orders table to get the result

[@muhammadidrees3322]

how can we creat a single from from which data goes to two tables, both the tables hve one or two different columns

[@GCFLearnFree]

We're not sure what you mean. Can you be more specific about what you're trying to do?