did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9781435460102

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

by
  • ISBN13:

    9781435460102

  • ISBN10:

    1435460103

  • Edition: 1st
  • Format: Paperback
  • Copyright: 2011-10-28
  • Publisher: Cengage Learning PTR
  • Purchase Benefits
List Price: $30.00

Summary

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.

Table of Contents

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
Table of Contents provided by Publisher. All Rights Reserved.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program