O'Reilly logo

Microsoft® Access® 2010 In Depth by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required