Microsoft Access data analysis : unleashing the analytical power of Access /
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Indianapolis, IN :
Wiley,
c2006.
|
| Subjects: |
Table of Contents:
- 1. Access basics
- 2. Beyond select queries
- 3. Transforming your data with Access
- 4. Working with calculations and dates
- 5. Performing conditional analysis
- 6. Working with subqueries and domain aggregate functions
- 7. Running descriptive statistics in Access
- 8. Analyzing data with pivot tables and pivot charts
- 9. Scheduling and running batch analysis
- 10. Leveraging VBA to enhance data analysis
- 11. Reporting your results using Excel automation
- 12. Query performance, database corruption, and other final thoughts
- Appendix A. Data analyst’s function reference
- Appendix B. Access VBA fundamentals
- Appendix C. Data analyst's error reference.