In this chapter, I discussed creating select queries for sorting, filtering, and preprocessing data, totals queries for doing calculations on data, crosstab queries for cross-tabulating data, and SQL-specific queries for specialized tasks. The next chapter will deal with using PivotTables and PivotCharts, a step up from crosstab queries, to chart and analyze your data in a dynamic, interactive format.