Data analysis with Microsoft Access 2010 : from simple queries to business intelligence /
by Rockoff, Larry.
Material type:
BookPublisher: Boston, MA : Course Technology PTR, c2012Description: xiv, 386 p. : ill. ; 23 cm.ISBN: 082039560106; 9781435460102; 1435460103.Other title: Microsoft Access 2010; Access 2010.Subject(s): Microsoft Access | Database management | Relational databases | Information retrieval
Contents:
Getting started. What is data analysis? ; An overview of Access -- Access queries. Tables and external data ; Select queries ; Joins and relationships ; Relational database design ; Expressions and functions ; Selection criteria ; Summarizing data ; Subqueries and set logic ; Action queries ; Crosstab queries and pivot tables -- Creating business intelligence. What is business intelligence? ; Dimensional modeling ; The data warehouse ; Excel pivot tables -- Appendix A. Forms, macros, and reports -- Appendix B. A sample business intelligence database.
| Item type | Location | Call number | Status | Date due | Barcode | Item holds |
|---|---|---|---|---|---|---|
 Book |
Lee Yan Fong Library
Library Collection
Lee Yan Fong Library |
QA76.9 D3 R648 2012 (Browse shelf) | Available | 00005911 |
Total holds: 0
Includes index.
Getting started. What is data analysis? ; An overview of Access -- Access queries. Tables and external data ; Select queries ; Joins and relationships ; Relational database design ; Expressions and functions ; Selection criteria ; Summarizing data ; Subqueries and set logic ; Action queries ; Crosstab queries and pivot tables -- Creating business intelligence. What is business intelligence? ; Dimensional modeling ; The data warehouse ; Excel pivot tables -- Appendix A. Forms, macros, and reports -- Appendix B. A sample business intelligence database.
Hong Kong Nang Yan College of Higher Education
Lee Yan Fong Library
325-329 Lai Chi Kok Road, Shamshuipo, Kowloon, HONG KONG
Lee Yan Fong Library
325-329 Lai Chi Kok Road, Shamshuipo, Kowloon, HONG KONG