Lee Yan Fong Library

Normal view MARC view ISBD view

Rockoff, Larry.

Data analysis with Microsoft Access 2010 : from simple queries to business intelligence / Microsoft Access 2010 Access 2010 Larry Rockoff. - Boston, MA : Course Technology PTR, c2012. - xiv, 386 p. : ill. ; 23 cm.

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.

ISBN: 082039560106 9781435460102 1435460103

LCCN: 2011936038

Subjects--Uniform Titles:
Microsoft Access.

Subjects--Topical Terms:
Database management.
Relational databases.
Information retrieval.

LC Class. No.: QA76.9 D3 / R648 2012

Dewey Class. No.: 005.7565