Microsoft Access 2007 Data Analysis / Edition 1by Michael Alexander
Pub. Date: 03/26/2007
Chart a course for more effective data analysis with Access 2007. With this resource, you’ll learn how Access 2007 offers powerful functionality that may be better suited to your data analysis needs. Learn to analyze large amounts of data in meaningful ways, quickly and easily slice it into various views, automate redundant analysis, and save time—all… See more details below
Chart a course for more effective data analysis with Access 2007. With this resource, you’ll learn how Access 2007 offers powerful functionality that may be better suited to your data analysis needs. Learn to analyze large amounts of data in meaningful ways, quickly and easily slice it into various views, automate redundant analysis, and save time—all using Access. If you know a bit about table structures and formulas as well as data analysis, start thinking outside the chart.
- Publication date:
- Product dimensions:
- 7.40(w) x 9.30(h) x 1.20(d)
Table of Contents
About the Author.
Part I Fundamentals of Data Analysis in Access.
Chapter 1 The Case for Data Analysis in Access.
Chapter 2 Access Basics.
Chapter 3 Beyond Select Queries.
Part II Basic Analysis Techniques.
Chapter 4 Transforming Your Data with Access.
Chapter 5 Working with Calculations and Dates.
Chapter 6 Performing Conditional Analysis.
Part III Advanced Analysis Techniques.
Chapter 7 Understanding and Using SQL.
Chapter 8 Subqueries and Domain Aggregate Functions.
Chapter 9 Running Descriptive Statistics in Access.
Chapter 10 Analyzing Data with Pivot Tables and Pivot Charts.
Part IV Automating Data Analysis.
Chapter 11 Scheduling and Running Batch Analysis.
Chapter 12 Leveraging VBA to Enhance Data Analysis.
Chapter 13 Query Performance, Database Corruption, and Other Final Thoughts.
Part V Appendixes.
Appendix A Data Analyst’s Function Reference.
Appendix B Access VBA Fundamentals.
Appendix C Error Message Reference.
and post it to your social network
Most Helpful Customer Reviews
See all customer reviews >
While most Access books focus on designing forms and reports, this book goes straight to the basics of analyzing data. After a short review of table design, the author quickly gets to the heart of data analysis by showing how to construct queries by using Access¿s graphical interface and illustrating how to write your own SQL. Advanced query techniques using subqueries and domain aggregate functions are fully described. The author demonstrates how to create pivot tables and charts from within Access and how to use Visual Basic for Applications to increase the power of your application. I recommend this book for beginning and intermediate users of Access who need to learn how to use Access to analyze data. Truitt L. Bradly Senior Actuarial Analyst Microsoft Access MVP 2007
This is a great book for any analyst looking to go beyond the standard queries and realize the full analytical potential of Access. I use this book almost daily in my work and it is the most useful book on Access that I own.