Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.
    • Access 2013

      Introduction to queries

    • Access 2013

      Building queries with the Query Designer

    • Access 2013

      Build queries that use more than one data source

    • Access 2013

      Using outer joins

    • Access 2013

      Query unrelated data sources

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.

Course summary
A brief reminder of the key points in this course.

More courses available at Microsoft Office Training.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!