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
Available through our Marketplace sellers and in stores.
See All Options
Pick Up In Store Near You

Pick Up In Store Near You

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (16) from $11.89   
  • New (9) from $22.79   
  • Used (7) from $11.89   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$22.79
GreatBookPrices
Seller since 2008

Feedback rating:

(16163)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand New, Perfect Condition, Please allow 4-14 business days for delivery. 100% Money Back Guarantee, Over 1,000,000 customers served.

Ships from: Westminster, MD

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
$22.80
indoo
Seller since 2007

Feedback rating:

(22540)

Condition: New
BRAND NEW

Ships from: Avenel, NJ

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
$24.44
EuroBooks
Seller since 2008

Feedback rating:

(4071)

Condition: New
New Book. Shipped from UK within 4 to 14 business days. Established seller since 2000.

Ships from: Horcott Rd, Fairford, United Kingdom

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
$25.33
PaperbackshopUS
Seller since 2009

Feedback rating:

(7149)

Condition: New
New Book. Shipped from US within 4 to 14 business days. Established seller since 2000

Ships from: Secaucus, NJ

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
$36.15
Extremely_Reliable
Seller since 2007

Feedback rating:

(8175)

Condition: New
Buy with confidence. Excellent Customer Service & Return policy.

Ships from: Richmond, TX

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
$36.21
Fadi sabha
Seller since 2013

Feedback rating:

(26)

Condition: New

Ships from: Amman, Jordan

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$41.67
N & A Records
Seller since 2013

Feedback rating:

(53)

Condition: New
"Brand new, in-stock product. Ships fast and secure. Add to Bag with confidence!"

Ships from: Brooklyn, NY

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
$71.54
PROFESSIONAL & ACADEMIC BOOKSTORE
Seller since 2009

Feedback rating:

(50)

Condition: New
0470104856 ***BRAND-NEW*** FAST UPS shipping, so you'll receive your order FAST! (r'cd within 1-5 business days after shipping in most cases) We've been in business for over 18 ... years. We provide EXCEPTIONAL customer service. We're open 24/7 to serve you best. **** PLEASE NOTE: UPS does not deliver to PO Boxes or APO addresses, so please be sure to give us a physical street address for delivery. Also, unfortunately, we cannot ship this item to Alaska or Hawaii. Thanks! Read more Show Less

Ships from: Dundee, MI

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$71.54
PROFESSIONAL & ACADEMIC BOOKSTORE
Seller since 2009

Feedback rating:

(50)

Condition: New
0470104856 ***BRAND-NEW*** FAST UPS shipping, so you'll receive your order FAST! (r'cd within 1-5 business days after shipping in most cases) We've been in business for over 18 ... years. We provide EXCEPTIONAL customer service. We're open 24/7 to serve you best. **** PLEASE NOTE: UPS does not deliver to PO Boxes or APO addresses, so please be sure to give us a physical street address for delivery. Also, unfortunately, we cannot ship this item to Alaska or Hawaii. Thanks! Read more Show Less

Ships from: Dundee, MI

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
Page 1 of 1
Showing All
Close
Sort by

More About This Book

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, John & Sons, Incorporated
  • Publication date: 3/26/2007
  • Edition number: 1
  • Pages: 552
  • 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:

Review Guidelines
Add Recommendations
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  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.

  • 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  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.

  • 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)