In the last video, we created a query using two tables. We used a left join so that the query would look at the Orders table first, and we used search criteria to narrow down our results. In this video, we’re going to look at joins in a bit more depth, as it’s very important to understand which type of join to use when creating a query. We’ll also look at some examples of common search criteria that you can use, such as Not In, Like, Between, and more.

If you are interested in learning more about this topic, please visit our site at http://www.gcflearnfree.org/access2010 to view the entire tutorial on our website. It includes instructional text, informational graphics, examples, and even interactives for you to practice and apply what you’ve learned.