Data analysis with Microsoft Access 2010
Subtitle: from simple queries to business intelligence
By: Larry Rockoff
Publisher: Course Technology PTR
Published: 2012
Place of publication: Boston, MA
Language: eng
Number of pages: 386
ISBN-13: 9781435460102
Subjects: Relational databases; Microsoft Access; Database management; Information retrieval
Notes: Includes index.
Table of contents: title: What is data analysis?; title: An overview of Access; title: Tables and external data; title: Select queries; title: Joins and relationships; title: Relational database design; title: Expressions and functions; title: Selection criteria; title: Summarizing data; title: Subqueries and set logic; title: Action queries; title: Crosstab queries and pivot tables; title: What is business intelligence?; title: Dimensional modeling; title: The data warehouse; title: Excel pivot tables; title: Appendix A. Forms, macros, and reports; title: Appendix B. A sample business intelligence database.