Microsoft Access 2007 Data Analysis and over one million other books are available for Amazon Kindle. Learn more
Buy New
$28.48
Qty:1
  • List Price: $39.99
  • Save: $11.51 (29%)
FREE Shipping on orders over $35.
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Trade in your item
Get a $6.70
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Microsoft Access 2007 Data Analysis Paperback – March 9, 2007

ISBN-13: 978-0470104859 ISBN-10: 0470104856 Edition: 1st

Buy New
Price: $28.48
32 New from $14.99 32 Used from $4.49
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$28.48
$14.99 $4.49

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student



Frequently Bought Together

Microsoft Access 2007 Data Analysis + Excel 2007 Advanced Report Development + Microsoft Excel and Access Integration: With Microsoft Office 2007
Price for all three: $87.69

Buy the selected items together

NO_CONTENT_IN_FEATURE

Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Product Details

  • Paperback: 552 pages
  • Publisher: Wiley; 1 edition (March 9, 2007)
  • Language: English
  • ISBN-10: 0470104856
  • ISBN-13: 978-0470104859
  • Product Dimensions: 1.1 x 7.3 x 9.1 inches
  • Shipping Weight: 1.6 pounds (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (13 customer reviews)
  • Amazon Best Sellers Rank: #186,493 in Books (See Top 100 in Books)

Editorial Reviews

From the Back Cover

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 www.wiley.com/go/access2007dataanalysis

About 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.

More About the Author

Mike Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on advanced business analysis with Microsoft Access and Excel. He has more than 16 years experience consulting and developing Office solutions. Michael has been named a Microsoft MVP for his ongoing contributions to the Excel community. Visit him at www.datapigtechnologies.com.

Customer Reviews

4.2 out of 5 stars
5 star
6
4 star
5
3 star
1
2 star
1
1 star
0
See all 13 customer reviews
Has good examples that are easy to understand.
Jacob Holmsgaard Fischer
It's refreshing to see a book about data-crunching with Access (instead of how to create a "contact database" or something like that).
JC Carlisle
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

Most Helpful Customer Reviews

28 of 28 people found the following review helpful By Truitt L. Bradly on April 21, 2007
Format: Paperback
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 Office - Access - Most Valuable Professional 2007
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
13 of 15 people found the following review helpful By JC Carlisle on May 16, 2007
Format: Paperback
It's refreshing to see a book about data-crunching with Access (instead of how to create a "contact database" or something like that). Clearly written with concrete examples.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 10 people found the following review helpful By Jonathan C. Anthony on April 22, 2008
Format: Paperback
This is an excellent text, it was used in my CIS 2640 Business Reports and Analysis class at Western Michigan University in the Spring of 2008. I learned a great deal about building tables and queries in Access, a tool that will come in handy in almost any business related work. It's user friendly, and I feel is a good price for what it offers, and is designed from a beginner to someone who is experienced in Office 2003, looking to update their skills.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 10 people found the following review helpful By Thomas G. McDowell on August 17, 2010
Format: Paperback Verified Purchase
This is a very good book for doing exactly what the title says. Easy to follow and there are a lot of useful tips on how to design queries and perform solid data analysis using Access. This is not a beginners book on how to use Access but a good learning tool once a few Access fundamentals have been learned elsewhere.

The Kindle edition has problems. Many of the screen shots of the actual examples (in particular of the query builder) are not readable on the kindle (and aren't readable on the kindle for PC), unfortunately for many of the sections this renders the information useless since it means you can't actually read the instructions for what is being demonstrated.

The hardcopy book is a 5 the Kindle version a 1 or 2. Hopefully the Kindle version can be reformatted and redistributed.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 6 people found the following review helpful By Theresa Becker on January 20, 2008
Format: Paperback
I purchased this book as a textbook for an Access class I am taking. It is a very good source to help with the class. I especially like to be able to go to the site listed on the book and work with the data on line. This helps me to practice the different tasks the book is teaching. I recomend this to anyone who is learning Access.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 11 people found the following review helpful By M. Haslip on August 10, 2008
Format: Paperback
I just ordered Microsft Access 2007 Data Analysis, and paid the extra $ to use the "Amazon Online Reader" option.
Upside: as promised, I am able to immediately view the entire book using the Online Reader :-). The material seems excellent and I'm anxious to start working with the solutions the author is trying to provide me, but . . .
Downside: the Online Reader image quality is fuzzy, and renders the small font images and screen captures in the book illegible :-( Tres' aggravating since the details of the solutions are spelled out in text that I Just Can't Quite Read. I'm chomping at the byte for the postman to bring my hard copy!
I have emailed a query to Amazon's customer service folks, asking if there is a user-end fix for this dilemna. But, unless they have a solution, I would have to opin that the book itself appears well written and informative, but the Online Reader Option for this and other manuals with graphics needs refinement before I spend any more money on the service.
PS - Yes, the OnLine Reader problem is not limited to this book. A second book, different author, different publisher, which I purchased on-line Amazon Digital rights to at the same time is also fuzzy at best and the small type is not legible. //
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 3 people found the following review helpful By A. Gautam on September 27, 2008
Format: Paperback
has a quick and well written introduction to creating queries in Access. Also covers some more advanced data analysis tools. Well worth the investment.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Search

What Other Items Do Customers Buy After Viewing This Item?