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

Name: Data Analysis with Microsoft Access 2010 From Simple Queries to Business Intelligence
Price: 6.7 USD
Availability: InStock
ISBN: 9781435460102

ISBN-10: 1435460103

ISBN-13: 9781435460102

Edition: 2012

Authors: Larry Rockoff

List price: $19.99

30 day, 100% satisfaction guarantee!

Marketplace

2 new & used from $6.70

what's this?

Rush Rewards U
Members Receive:

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…

Book details

List price: $19.99
Copyright year: 2012
Publisher: Course Technology
Publication date: 10/28/2011
Binding: Paperback
Pages: 400
Size: 7.50" wide x 9.00" long x 1.00" tall
Weight: 1.716
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