Data Analysis With Microsoft Access 2010: From Simple Queries to Business Intelligence ペーパーバック – 2011/10/28
Kindle 端末は必要ありません。無料 Kindle アプリのいずれかをダウンロードすると、スマートフォン、タブレットPCで Kindle 本をお読みいただけます。
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.
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.商品の説明をすべて表示する
It isn't very dry like others and makes for a great, informative read.
Unfortunately, the book author did not provide any sample file for the examples discussed either for download or in an attached CD for most chapters until Chapter 15. (This book has 16 chapters and two appendices.) One value of having a book is organized information and this book does provide that, though at the very elementary level. This book provides quite a few simple queries as examples. They can serve as an introduction to get foot wet. Access Help does the same. To learn Access 2010 user interface as provided in this book, a user can press F1 key to search the help file and read the relevant information when using Access 2010.
This book is not for a reader who is serious in acquiring knowledge in Data Analysis and/or Business Intelligence.
In all, there are two small files available for download from [...]. These two files are "SalesDatabase.zip" and "DataWarehouse.zip."
The first zip file is a single table database (SalesDatabase.accdb) with a few additional files:
1. 1 table: GeographicSales (9 records and 3 fields)
2. 2 queries: SalesByState and UniqueRegions
3. 2 forms: MainMenu and SalesByState
4. 1 report: Sales By State
5. 1 macro: Instructions
After unzip, the size of this database is 520 KB.
This file is used as an example for Forms, Macros, and Reports. This book devoted 11 pages to discuss this file in its Appendix A.
The data warehouse database has
1. 16 tables and
2. 10 queries (2 for Append, 5 for Make Table, and 3 for report/analysis).
Chapter 15, The Data Warehouse, uses this database as its main example. This book also devoted 3 pages in its Appendix B to discuss this database, which briefly describes the process of how this database can be built. This database has 904 KB and is a vanilla database, e.g., just a collection of tables and queries, and no relationship between tables is defined.
I am not convinced that "this is the only book you'll need to gain a working knowledge of Access, and how it can be used for data analysis." This claim is misleading.