Microsoft Access 2007 Data Analysis
26%
off

Microsoft Access 2007 Data Analysis

By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 3 business days
When will my order arrive?

Expected delivery to the United States by Christmas Expected to be delivered to the United States by Christmas

Description

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.show more

Product details

  • Online resource | 552 pages
  • 182.88 x 233.68 x 33.02mm | 725.74g
  • John Wiley and Sons Ltd
  • John Wiley & Sons Ltd
  • Chichester, United Kingdom
  • English
  • 1. Auflage
  • 0470104856
  • 9780470104859
  • 671,077

Back cover copy

Chart a course for more effective data analysis Data analysis is more than crunching numbers and turning them into charts and graphs. Certainly Excel can do that, but you may be surprised to discover that Access 2007 offers powerful functionality that may be even 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. Apply Access 2007 to the task of collecting, transforming, analyzing, and presenting data Create custom functions, perform batch analysis, and develop automated procedures that essentially run themselves Build effective query skills Learn to clean and shape raw data, create and utilize custom calculations, work with dates, and perform advanced time analysis Work with SQL statements, PivotTables, and PivotCharts Perform advanced statistical analysis using subqueries and domain aggregate functions See how to use macros and Visual Basic(R) for Applications to enhance data analysis Companion web site Find all the examples from the book in the sample database located at www.wiley.com/go/access2007dataanalysisshow more

About Michael Alexander

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.show more

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.show more