Microsoft Access 2007 data analysis /

Saved in:
Bibliographic Details
Main Author: Alexander, Michael, 1972-
Format: Book
Language:English
Published: Indianapolis, Ind. : Wiley Technology Pub., c2007.
Subjects:
Online Access:Table of contents only
Contributor biographical information
Publisher description
Table of Contents:
  • Ch. 1. The case for data analysis in Access
  • Ch. 2. Access basics
  • Ch. 3. Beyond select queries
  • Ch. 4. Transforming your data with Access
  • Ch. 5. Working with calculations and dates
  • Ch. 6. Performing conditional analysis
  • Ch. 7. Understanding and using SQL
  • Ch. 8. Subqueries and domain aggregate functions
  • Ch. 9. Running descriptive statistics in Access
  • Ch. 10. Analyzing data with pivot tables and pivot charts
  • Ch. 11. Scheduling and running batch analysis
  • Ch. 12. Leveraging VBA to enhance data analysis
  • Ch. 13. Query performance, database corruption, and other final thoughts
  • App. A. Data analyst's function reference
  • App. B. Access VBA fundamentals
  • App. C. Error message reference.