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.

[heartseas]

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

[erinkavanagh]

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

[nabilxgmail]

Clear and focused to the point ...thumbs up

[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!!

[martinolsson]

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