Microsoft® Access® 2010 In Depth

9. Designing Queries for Access Databases

Queries are an essential tool in any database management system. You use queries to select records as well as add, update, and delete records in tables. Most often you use queries to select specific groups of records that meet criteria you specify. You can also use queries to combine information from different tables, providing a unified view of related data items. In this chapter, you learn the basics of creating your own select queries, including specifying selection criteria and using the results of your queries to generate reports and create new tables. You create queries using more than one table in Chapter 11, “Creating Multitable and Crosstab Queries,” after you learn the details of how to use ...