Wiley India Pvt Ltd
|Number of Pages||624 Pages|
This book offers a comprehensive review of the wide array of analytical and reporting functionality that Access has to offer. In this effort the author shows how to effectively use Access for data transformation and analysis, how to efficiently movie and analyze data across applications, and how to use Access's native reporting tools to synthesize data into visually compelling dashboards and reports.
Then the readers will get a look at the integration techniques that can be performed using Excel and Access. Along with step-by-step instruction, this book provides practical, real world, scenarios that show the benefits of integrating Excel and Access.
About the AuthorM
Mike Alexander is the author of several books on advanced business analysis. He has more than 15 years experience consulting and developing reporting solutions for a variety of industries. In addition to consulting, Mike is also serves as the principle contributor at www.datapigtechnologies.com, where he shares free video tutorials with the Microsoft Excel and Access communities. Mike has been named a Microsoft MVP for his ongoing contributions to the Excel community.
TABLE OF CONTENTS : -
Part I Fundamentals of Data Analysis in Access.
Part II Basic Analysis Techniques.
Part III Advanced Analysis Techniques.
Part IV Reports, Dashboards, and Visualization in Access.
Part V Advanced Excel and Access Integration Techniques.
Part VI Appendixes.