- Using outer joins
Learn the basics of creating queries in Access 2013. This course explains the types of queries, how to create Select queries, and use criteria, joins, and intermediate tables.
Inside this course:
Introduction to queries (5:24)
The types of queries you can build; using the Query Wizard.
Building queries with the Query Designer (4:45)
Using the Query Designer to build select queries.
Build queries that use more than one data source (4:45)
How to query multiple data sources; the basics of joins.
Using outer joins (2:50)
More about using left and right outer joins.
Query unrelated data sources (4:45)
How to use intermediate tables and add joins.
A brief reminder of the key points in this course.
More courses available at Microsoft Office Training.