Microsoft Access Data Analysis: Unleashing the Analytical Power of Access

Go beyond Excel® with Access′s more powerful analysis capabilitiesGet better visibility into your data with custom viewsScale up your data pool without limitationMaster the four fundamentals of data analysisDiscover shortcuts with the helpful Input Mask WizardIntegrate your data with the web and enterprise data sourcesAvoid the common pitfalls of data crunchingHarness VBA to improve data analysisLeverage information from the field with real–world scenarios
Companion web site
See examples from this book firsthand, in our companion web site at www.wiley.com/go/accessdataanalysis. The site also includes templates and tools to get you started.

Spis treści:
Acknowledgments.
Introduction.
Part One: Fundamentals of Data Analysis in Access.
Chapter 1: Access Basics.
Chapter 2: Beyond Select Queries.
Part Two: Basic Analysis Techniques.
Chapter 3: Transforming Your Data with Access.
Chapter 4: Working with Calculations and Dates.
Chapter 5: Performing Conditional Analysis.
Part Three: Advanced Analysis Techniques.
Chapter 6: Working with Subqueries and Domain Aggregate Functions.
Chapter 7: Running Descriptive Statistics in Access.
Chapter 8: Analyzing Data with Pivot Tables and Pivot Charts.
Part Four: Automating Data Analysis.
Chapter 9: Scheduling and Running Batch Analysis.
Chapter 10: Leveraging VBA to Enhance Data Analysis.
Chapter 11: Reporting Your Results Using Excel Automation.
Chapter 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.
Index.

Nota biograficzna:
Michael Alexander is a Microsoft Certified Application Developer (MCAD) wit h more than 13 years experience consulting and developing office solutions. Michael started his career in consulting and development at the White House Communications Agency in Washington DC where he spearheaded the development of a standalone HRIS system for the White House’s Military Office. He parlayed his experience with VBA and VB into a successful consulting practice in the private sector, developing middleware and reporting solutions for a wide variety of industries. He currently lives in Plano, TX where he serves as the director of an analytical services department of a $700 million company. In his spare time, he runs a free tutorial site, www.datapig technologies.com, where he shares basic Access and Excel tips with intermediate users.

Okładka tylna:
Go beyond Excel® with Access′s more powerful analysis capabilitiesGet better visibility into your data with custom viewsScale up your data pool without limitationMaster the four fundamentals of data analysisDiscover shortcuts with the helpful Input Mask WizardIntegrate your data with the web and enterprise data sourcesAvoid the common pitfalls of data crunchingHarness VBA to improve data analysisLeverage information from the field with real–world scenarios
Companion web site
See examples from this book firsthand, in our companion web site at www.wiley.com/go/accessdataanalysis. The site also includes templates and tools to get you started.