Cart
Free US shipping over $10
Proud to be B-Corp

Data Analysis with Microsoft Access 2010 Larry Rockoff

Data Analysis with Microsoft Access 2010 By Larry Rockoff

Data Analysis with Microsoft Access 2010 by Larry Rockoff


$5.47
Condition - Good
Only 1 left

Summary

Rather than emphasizing the mechanics, forms or report modules within Microsoft Access, this book focuses on data retrieval and how you can transform data into structures useful for a true understanding of the data. To help you most effectively utilize Access, it focuses on the graphical user interface that Microsoft Access uses to create queries.

Faster Shipping

Get this product faster from our US warehouse

Data Analysis with Microsoft Access 2010 Summary

Data Analysis with Microsoft Access 2010: From Simple Queries to Business Intelligence by Larry Rockoff

DATA ANALYSIS WITH MICROSOFT ACCESS 2010 is an introduction to Access with an emphasis on topics relevant to data analysis. The goal is to help the analyst gain a true understanding of data and the information it contains. Access queries are covered in detail, both in terms of the mechanics of their design, and how they can be used for typical data analysis tasks. The book is written in an easy-to-understand tutorial style, with new topics introduced in a logical and intuitive sequence. Numerous screenshots are included, so you won't need to sit with a computer as you read the book. The author also broadens the concept of data analysis to encompass business intelligence (BI) topics, including valuable material on how to use Access and Excel pivot tables. Additional features include "See the SQL" sidebars that allow interested readers to learn SQL as they are learning Access, and "Focus on Analysis" sidebars that provide details on a number of useful quantitative topics. A companion website has a sample database that correlates with the BI material in the book. In short, this is the only book you'll need to gain a working knowledge of Access, and how it can be used for data analysis.

Data Analysis with Microsoft Access 2010 Reviews

Introduction. Part I: GETTING STARTED. 1. What Is Data Analysis. 2. Overview of Access. 3. Relational Database Design. Part II: ACCESS QUERIES. 4. Tables and External Data. 5. Select Queries. 6. Expressions and Functions. 7. Joins and Relationships. 8. Selection Criteria. 9. Summarizing Data. 10. Subqueries and Set Logic. 11. Action Queries. 12. Crosstab Queries and Pivot Tables. Part III: CREATING BUSINESS INTELLIGENCE. 13. What Is Business Intelligence? 14. Star Schema Design. 15. Data Warehouse Queries. 16. Excel Pivot Tables. Appendix A: Forms, Macros, and Reports. Appendix B: Creating an Access Application. Appendix C: The Companion Website.

About Larry Rockoff

Larry Rockoff has been involved with Excel and business intelligence development for many years. He currently works as a senior reporting analyst for a major retail pharmacy. His main area of expertise is with data warehouse systems and reporting tools. He holds an MBA from the University of Chicago, with a specialization in management science.

Table of Contents

Introduction. Part I: GETTING STARTED. 1. What is Data Analysis? 2. Overview of Access. Part II: ACCESS QUERIES. 3. Tables and External Data. 4. Select Queries. 5. Joins and Relationships. 6. Relational Database Design. 7. Expressions and Functions. 8. Selection Criteria. 9. Summarizing Data. 10. Subqueries and Set Logic. 11. Action Queries. 12. Crosstab Queries and Pivot Tables. Part III: CREATING BUSINESS INTELLIGENCE. 13. What is Business Intelligence? 14. Dimensional Modeling. 15. The Data Warehouse. 16. Excel Pivot Tables. Appendix A: Forms, Macros and Reports. Appendix B: A Sample Business Intelligence Database.

Additional information

CIN1435460103G
9781435460102
1435460103
Data Analysis with Microsoft Access 2010: From Simple Queries to Business Intelligence by Larry Rockoff
Used - Good
Paperback
Cengage Learning, Inc
2011-10-28
400
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - Data Analysis with Microsoft Access 2010