In Access queries let you retrieve information from one or more tables on a set of defined search conditions. Learn how to use queries in Access here.
Watch the video! (5:22min)
Download the example to work along with the video.
Queries retrieve information from one or more tables based on a set of search conditions you set up and then combine that information in a way that's easy for you to analyze. If you've used an Advanced Filter in Access 2007, then you've already run a basic query on only one table. If you want to pull data from more than one table, though, you'll need to use either the Query Design command or the Query Wizard.
Before using the Access 2007 query tools, it's important to plan out the query using a logical process. Otherwise, you may not get the results you expect.