Overview

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.

Full Product Details

Author:   Michael Alexander
Publisher:   John Wiley and Sons Ltd
Imprint:   John Wiley & Sons Ltd
Dimensions:   Width: 18.90cm , Height: 3.20cm , Length: 23.40cm
Weight:   0.826kg
ISBN:  

9780470104859

ISBN 10:   0470104856
Pages:   552
Publication Date:   23 March 2007
Audience:   College/higher education ,  Tertiary & Higher Education
Format:   Paperback
Publisher's Status:   Out of Print
Availability:   In Print  
Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock.

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.

Reviews

Author Information

Michael Alexander is a Microsoft Certified Application Developer (MCAD) with more than thirteen years of experience consulting and developing office solutions. He currently serves as the director of an analytical services department for a $700 million company. He also runs a free tutorial site, www.datapigtechnologies.com, where he shares basic Access and Excel tips with intermediate users.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions