Microsoft Access Data Analysis

Microsoft Access Data Analysis : Unleashing the Analytical Power of Access

4.12 (16 ratings by Goodreads)
By (author)  , By (author) 

List price: US$39.99

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

Go beyond Excel[registered] with Access' more powerful analysis capabilities. Get better visibility into your data with custom views. Scale up your data pool without limitation, master the four fundamentals of data analysis, discover shortcuts with the helpful Input Mask Wizard, integrate your data with the web and enterprise data sources, avoid the common pitfalls of data crunching, harness VBA to improve data analysis, and leverage information from the field with real world scenarios. See examples from this book firsthand, in our companion web site. The site also includes templates and tools to get you started.
show more

Out of ideas for the holidays?

Visit our Gift Guides and find our recommendations on what to get friends and family during the holiday season. Shop now .

Product details

  • Online resource | 552 pages
  • 188 x 231.1 x 33mm | 748.44g
  • Hungry Minds Inc,U.S.
  • Foster City, United States
  • English
  • 1. Auflage
  • 076459978X
  • 9780764599781
  • 1,142,088

Back cover copy

Go beyond Excel(R) with Access's more powerful analysis capabilities Get better visibility into your data with custom views Scale up your data pool without limitation Master the four fundamentals of data analysis Discover shortcuts with the helpful Input Mask Wizard Integrate your data with the web and enterprise data sources Avoid the common pitfalls of data crunching Harness VBA to improve data analysis Leverage 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.
show more

About Michael Alexander

Michael Alexander is a Microsoft Certified Application Developer (MCAD) with 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.
show more

Table of contents

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

Rating details

16 ratings
4.12 out of 5 stars
5 44% (7)
4 38% (6)
3 12% (2)
2 0% (0)
1 6% (1)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X