Synopses & Reviews
While there are many books that focus on Data Analysis with Excel, it is extremely difficult to find any books dedicated to Data Analysis with Microsoft Access. This book shows readers that Access has strong data analysis capabilities that are easy to learn, applicable to all kinds business situations, and relevant to many types of organizations. What do we mean by Data Analysis? The process of categorizing data into groups, summarizing large amounts of data into meaningful information, and performing a wide variety of calculations in a fraction of the time it would normally take by hand. The market is virtually void of any documentation that offers users solutions revolving around data analysis with Access. So why isn’ t Data Analysis with Excel good enough? Excel has real limitations that often force Excel users to use Access. Years of consulting experience have brought the authors face-to-face with Excel users who have offered contracts because their projects had outgrown Excel. They simply did not know what the next logical step was. Access solved their problems easily!
Approach:
This book offers a comprehensive review of the wide array of analytical functionality that Access has to offer. After reading this book, the reader will be able to: Analyze large amounts of data and report their data in a meaningful way Get better visibility into data from different perspectives Quickly slice data into various views on the fly Automate redundant analysis Save time and increase productivity
Along with step-by-step instruction on the analytical functionality of Access, the book provides practical, real world, scenarios thatshow the benefits of using Access for data analysis, it shows how to avoid common pitfalls of everyday data crunching, and it routinely discusses the differences and similarities between Access and Excel when covering a subject.
Synopsis
Provides valuable information not found in other books, teaching readers how to analyze large amounts of data and report it effectively with Access Offers step-by-step instruction in the analytical functionality of Access and uses practical, real-world scenarios to illustrate how to avoid common pitfalls Teaches readers how to quickly slice data into various views and analyze it from different perspectives While data analysis is usually associated with Excel, Access has fewer limitations and strong data analysis capabilities that are easy to learn, applicable to all kinds business situations, and relevant to many types of organizations Companion Web site includes example files, templates, and tools to get the reader started
Synopsis
- Go beyond Excel® 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.
Synopsis
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.
Synopsis
- 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.
About the Author
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.
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.