BN.com Gift Guide

Microsoft Access 2007 Data Analysis

( 3 )

Overview

Chart a course for more effective data analysis with Access 2007. With this resource, you’ll learn how Access 2007 offers powerful functionality that may be 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.

...
See more details below
Other sellers (Paperback)
  • All (14) from $3.79   
  • New (8) from $21.30   
  • Used (6) from $3.79   

Overview

Chart a course for more effective data analysis with Access 2007. With this resource, you’ll learn how Access 2007 offers powerful functionality that may be 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.

Read More Show Less

Product Details

  • ISBN-13: 9780470104859
  • Publisher: Wiley
  • Publication date: 3/26/2007
  • Edition number: 1
  • Pages: 552
  • Sales rank: 626,518
  • Product dimensions: 7.40 (w) x 9.30 (h) x 1.20 (d)

Meet the Author

Michael Alexander is a Microsoft Certified Application Developer (MCAD) with more than thirteen years of experience consulting and developing office solutions. He currently serves as the director of an analytical services department for a $700 million company. He also runs a free tutorial site, www.datapigtechnologies.com, where he shares basic Access and Excel tips with intermediate users.

Read More Show Less

Table of Contents

About the Author.

Acknowledgments.

Introduction.

Part I Fundamentals of Data Analysis in Access.

Chapter 1 The Case for Data Analysis in Access.

Chapter 2 Access Basics.

Chapter 3 Beyond Select Queries.

Part II Basic Analysis Techniques.

Chapter 4 Transforming Your Data with Access.

Chapter 5 Working with Calculations and Dates.

Chapter 6 Performing Conditional Analysis.

Part III Advanced Analysis Techniques.

Chapter 7 Understanding and Using SQL.

Chapter 8 Subqueries and Domain Aggregate Functions.

Chapter 9 Running Descriptive Statistics in Access.

Chapter 10 Analyzing Data with Pivot Tables and Pivot Charts.

Part IV Automating Data Analysis.

Chapter 11 Scheduling and Running Batch Analysis.

Chapter 12 Leveraging VBA to Enhance Data Analysis.

Chapter 13 Query Performance, Database Corruption, and Other Final Thoughts.

Part V Appendixes.

Appendix A Data Analyst’s Function Reference.

Appendix B Access VBA Fundamentals.

Appendix C Error Message Reference.

Index.

Read More Show Less

Customer Reviews

Average Rating 4.5
( 3 )
Rating Distribution

5 Star

(2)

4 Star

(1)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 3 Customer Reviews
  • Anonymous

    Posted April 21, 2007

    A great source to learn how to analyze Access data

    While most Access books focus on designing forms and reports, this book goes straight to the basics of analyzing data. After a short review of table design, the author quickly gets to the heart of data analysis by showing how to construct queries by using Access¿s graphical interface and illustrating how to write your own SQL. Advanced query techniques using subqueries and domain aggregate functions are fully described. The author demonstrates how to create pivot tables and charts from within Access and how to use Visual Basic for Applications to increase the power of your application. I recommend this book for beginning and intermediate users of Access who need to learn how to use Access to analyze data. Truitt L. Bradly Senior Actuarial Analyst Microsoft Access MVP 2007

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Posted July 30, 2010

    One of the most useful Access books out there

    This is a great book for any analyst looking to go beyond the standard queries and realize the full analytical potential of Access. I use this book almost daily in my work and it is the most useful book on Access that I own.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted September 24, 2009

    No text was provided for this review.

Sort by: Showing all of 3 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)