http://www.gcflearnfree.org/access2010In 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 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.
Questions about Access 2010: Multi-Table Queries, Part 2
Want more info about Access 2010: Multi-Table Queries, Part 2?
Get free advice from education experts and Noodle community members.