Microsoft Access 2007 Data Analysis~tqw~ darksiderg

*******************************************************************************
Microsoft Access 2007 Data Analysis
*******************************************************************************
General InformationType.................: Ebook
Part Size............: 5,708,255 bytes



Post InformationPosted by............: ~tqw~
Release NotesChart 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.

Table of Contents

About the Author.
Acknowledgments.
Introduction.
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.
Index.

Product Details

* ISBN: 0470104856
* ISBN-13: 9780470104859
* Format: Paperback, 600pp
* Publisher: Wiley, John & Sons, Incorporated
* Pub. Date: March 2007
Install NotesAdobe Acrobat Reader