Microsoft Access Data Analysis

This book shows readers that Access has strong data analysis capabilities that are easy to learn, applicable to all kind of business situations, and relevant to many types of organizations. 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 that show 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.

Table of contents :
ndamentals of Data Analysis in Access
· Access Basics
· Beyond Select Queries
Part II: Basic Analysis Techniques
· Transforming Your Data with Access
· Working with Calculations and Dates
· Performing Conditional Analysis
Part III: Advanced Analysis Techniques
· Working with Subqueries and Domain Aggregate Functions
· Running Descriptive Statistics in Access
· Analyzing Data with Pivot Tables and Pivot Charts
Part IV: Automating Data Analysis
· Scheduling and Running Batch Analysis
· Leveraging VBA to Enhance Data Analysis
· Reporting Your Results Using Excel Automation
· 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


Market Description :
· The target readership includes any professional whose daily operations foster a data intensive environment. This might include Sales Managers, Operations Analysts, Administrative Assistants, Office Managers, Government Employees, Manufacturing Managers, Engineers, and Scientists.

· Microsoft Access users and technology professionals.

About Author :
Michael Alexander is a Microsoft Certified Application Developer (MCAD) with over 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 parleyed his experience into a successful consulting practice in the private sector, developing middleware and reporting solutions for a wide variety of industries. He currently 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.datapigtechnologies.com, where he shares basic Access and Excel tips to intermediate users.