Microsoft Access A to Z: Creating select queries with fields from multiple tables and criteria

In this short screencast we'll study how table relationships affect SELECT queries, how unrelated tables create Cartesian joins, and how queries store SQL statements. We will also revisit the fundamental benefits of a relational database, how tables store all data even though it can be viewed in multiple ways using queries, and how queries can be used to update data.
All of my TH-cams can be found at: learncs.w3spac...

[@heartseas7489]

You have a gift for teaching. Thank you for making these videos. They are very good.

[@lfriedrichsen]

TYSM!! See all of my youtubes organized at learncs.w3spaces.com

[@martinolsson3134]

Thank you for these pedagogical tutorials. Where to find the sample database that you've used?

[@lfriedrichsen]

You're very welcome. Sometimes I use the sample Northwind database that is provided as a free template from Microsoft. To get the unique databases I've created and sometimes use in these TH-cams you'd need to purchase the Illustrated Access textbook that matches the version of Access you have from Cengage.

[@nabilxgmail]

Clear and focused to the point ...thumbs up

[@lfriedrichsen]

Ty! See all of my TH-cams organized at learncs.w3schools.com

[@erinkavanagh3553]

Thank you I feel like I'm catching up with my College Access course.

[@lfriedrichsen]

You're welcome! You can find all of my TH-cams organized at learncs.w3spaces.com/

[@deepseademodiver]

Thank you for making these videos! I love your teaching style. I have learned so much in such a short time. I really like how you explain things in a "common sense" way, without going down "rabbit holes". What is really helpful, is that you explain the "why". Plus, you sound so much like Jodie Foster :) I look forward to more videos!!

[@lfriedrichsen]

You're welcome! I plan to continue this series this summer by going through forms, macros, and modules. Take care.