21. Learn Microsoft Access: How To Create and Use Subqueries




About this tutorial:

Video duration: 00:15:18
In this video called Learn Microsoft Access: How To Create and Use Subqueries, Steve Bishop gives you a tutorial on how to write SQL Queries that use subqueries to filter your results using JOIN and FROM statements. After watching this lesson you will know how to create a subquery, how to inject subquery SQL into another SQL query, how to alias a subquery, and how to use data from a subquery within the parent query. You will also learn how to use the query designer tool to help you write your subqueries.

This how to video tutorial is part of a series of videos that are tutorials on…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

3 thoughts on “21. Learn Microsoft Access: How To Create and Use Subqueries

    Jack MacDonald

    (August 2, 2020 - 12:25 am)

    When creating an alias for the sub query: right-click on the original designer and choose Properties. Type the alias into the dialog box that appears. Then open the query in SQL view to replace the query name with the SQL inside parentheses, just as you did. The advantage of this method is you can't overlook replacing any of the references to the original query, which can be very helpful for editing complete queries.

    Kent Dutrieux

    (August 2, 2020 - 12:25 am)

    Thanks for the series, it's helping me see what's behind the scene when I drag and drop. I wasn't quite sure how sub-queries worked

    Bryan Ogden

    (August 2, 2020 - 12:25 am)

    Thanks For The Content . That Was Good ! . The Video Was Washed Out Could Not See . But Could Follow .

Leave a Reply

Your email address will not be published. Required fields are marked *