Share this Page URL

Chapter 9. Extending Your Use of Queries > Summarizing Data with a Crosstab Que... - Pg. 304

304 Chapter 9. Extending Your Use of Queries In this chapter, you will learn how to: · · · · · · · Create a crosstab query to summarize data Create a query using Structured Query Language (SQL) Use action queries to update, append, and delete data Run a make-table query Create special-use queries using SQL Use query properties to return unique values and records Create an outer join and a self-join in a query The select queries we created in Chapter 6, "Sorting, Filtering, and Retrieving Data," are used to retrieve a set of records by using selection criteria as well as the relationship between tables and fields in a database. Using select queries, you can also group and summarize data and perform