Microsoft Access 2007 Data Analysis

Microsoft Access 2007 Data Analysis

4.6 3
by Michael Alexander
     
 

View All Available Formats & Editions

Chart a course for more effective data analysis

Data analysis is more than crunching numbers and turning them into charts and graphs. Certainly Excel can do that, but you may be surprised to discover that Access 2007 offers powerful functionality that may be even better suited to your data analysis needs. Learn to analyze large amounts of data in meaningful

See more details below

Overview

Chart a course for more effective data analysis

Data analysis is more than crunching numbers and turning them into charts and graphs. Certainly Excel can do that, but you may be surprised to discover that Access 2007 offers powerful functionality that may be even better suited to your data analysis needs. Learn to analyze large amounts of data in meaningful ways, quickly and easily slice it into various views, automate redundant analysis, and save time, all using Access. If you know a bit about table structures and formulas as well as data analysis, start thinking outside the chart.

  • Apply Access 2007 to the task of collecting, transforming, analyzing, and presenting data
  • Create custom functions, perform batch analysis, and develop automated procedures that essentially run themselves
  • Build effective query skills
  • Learn to clean and shape raw data, create and utilize custom calculations, work with dates, and perform advanced time analysis
  • Work with SQL statements, PivotTables, and PivotCharts
  • Perform advanced statistical analysis using subqueries and domain aggregate functions
  • See how to use macros and Visual Basic® for Applications to enhance data analysis

Companion web site

Find all the examples from the book in the sample database located at wiley.com/go/access2007dataanalysis

Read More

Product Details

ISBN-13:
9781118079188
Publisher:
Wiley
Publication date:
06/26/2012
Sold by:
Barnes & Noble
Format:
NOOK Book
Pages:
552
Sales rank:
686,793
File size:
19 MB
Note:
This product may take a few minutes to download.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >