Summary


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.




Expert One-on-One(c) Microsoft Access Application Development
Expert One-on-One Microsoft Access Application Development
ISBN: 0764559044
EAN: 2147483647
Year: 2006
Pages: 124
Authors: Helen Feddema

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net