Microsoft access 2007 data analysis
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Indianapolis, IN :
Wiley ,
c2007
|
| Subjects: | |
| Online Access: | Table of contents only |
Table of Contents:
- 1. The case for data analysis in access
- 2. Access basics
- 3. Beyond select queries
- 4. Transforming your data with access
- 5. Working with calculations and dates
- 6. Performing conditional analysis
- 7. Understanding and using SQL
- 8. Subqueries and domain aggregate functions
- 9. Running descriptive statistics in access
- 10. Analyzing data with pivot tables and pivot charts
- 11. Scheduling and running batch analysis
- 12. Leveraging VBA to enhance data analysis
- 13. Query performance, database corruption, and other final thoughts