Microsoft Access 2007 Data Analysis
By Michael Alexander
Publisher: Wiley
Final Release Date: June 2007
Pages: 519

Chart a course for more effective data analysis

Data analysis is more than crunching numbers and turning theminto charts and graphs. Certainly Excel can do that, but you may besurprised to discover that Access 2007 offers powerfulfunctionality that may be even better suited to your data analysisneeds. Learn to analyze large amounts of data in meaningful ways,quickly and easily slice it into various views, automate redundantanalysis, and save time, all using Access. If you know a bit abouttable structures and formulas as well as data analysis, startthinking outside the chart.

  • Apply Access 2007 to the task of collecting, transforming,analyzing, and presenting data
  • Create custom functions, perform batch analysis, and developautomated procedures that essentially run themselves

  • Build effective query skills

  • Learn to clean and shape raw data, create and utilize customcalculations, work with dates, and perform advanced timeanalysis

  • Work with SQL statements, PivotTables, and PivotCharts

  • Perform advanced statistical analysis using subqueries anddomain aggregate functions

  • See how to use macros and Visual Basic® for Applications toenhance data analysis

Companion web site

Find all the examples from the book in the sample databaselocated at

Product Details
Recommended for You
Customer Reviews
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $39.99
Formats:  ePub, Mobi, PDF