Skip to content

Data Analysis with Microsoft Access 2010 From Simple Queries to Business Intelligence

Spend $50 to get a free DVD!

ISBN-10: 1435460103

ISBN-13: 9781435460102

Edition: 2012

Authors: Larry Rockoff

List price: $18.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

Rather than emphasizing the mechanics, forms or report modules within Microsoft Access, DATA ANALYSIS WITH MICROSOFT ACCESS 2010: FROM SIMPLE QUERIES TO BUSINESS INTELLIGENCE focuses on data retrieval and how you can transform data into structures useful for a true understanding of the data. The author broadens the concept of data analysis to encompass Business Intelligence (BI) concepts. To help you most effectively utilize Access, the book focuses on the GUI (graphical user interface) that Microsoft Access uses to create queries. You examine underlying SQL concepts as they relate to Access queries. The book also emphasizes tables, while coverage of forms, reports and macros is addressed only briefly in an optional appendix. You also become familiar with various approaches to data analysis as you learn how Access relates to other tools, such as Microsoft Excel.
Customers also bought

Book details

List price: $18.99
Copyright year: 2012
Publisher: Delmar Cengage Learning
Publication date: 10/28/2011
Binding: Paperback
Pages: 400
Size: 7.50" wide x 9.00" long x 1.00" tall
Weight: 2.024
Language: English

Introduction
Getting Started
What Is Data Analysis
Overview of Access
Relational Database Design
Access Queries
Tables and External Data
Select Queries
Expressions and Functions
Joins and Relationships
Selection Criteria
Summarizing Data
Subqueries and Set Logic
Action Queries
Crosstab Queries and Pivot Tables
Creating Business Intelligence
What Is Business Intelligence?
Star Schema Design
Data Warehouse Queries
Excel Pivot Tables
Forms, Macros, and Reports
Creating an Access Application
The Companion Website