Microsoft Access 2007 data analysis /
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Indianapolis, IN :
Wiley,
c2007.
|
| Subjects: |
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
- Appendix A. Data analyst’s function reference
- Appendix B. Access VBA fundamentals
- Appendix C. Error message reference.