Sorry, this item is not available in
Image not available for
Color:
Image not available

To view this video download Flash Player

 


or
Sign in to turn on 1-Click ordering
More Buying Choices
Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Microsoft Access Data Analysis: Unleashing the Analytical Power of Access [Paperback]

Michael Alexander
4.5 out of 5 stars  See all reviews (23 customer reviews)

List Price: $39.99
Price: $31.70 & FREE Shipping on orders over $35. Details
You Save: $8.29 (21%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 7 left in stock (more on the way).
Ships from and sold by Amazon.com. Gift-wrap available.
Want it Tuesday, July 15? Choose One-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Book Description

January 4, 2006 076459978X 978-0764599781 1
  • Go beyond Excel(r) with Access's more powerful analysis capabilities
  • Get better visibility into your data with custom views
  • Scale up your data pool without limitation
  • Master the four fundamentals of data analysis
  • Discover shortcuts with the helpful Input Mask Wizard
  • Integrate your data with the web and enterprise data sources
  • Avoid the common pitfalls of data crunching
  • Harness VBA to improve data analysis
  • Leverage information from the field with real-world scenarios

Companion web site
See examples from this book firsthand, in our companion web site at www.wiley.com/go/accessdataanalysis. The site also includes templates and tools to get you started.


Frequently Bought Together

Microsoft Access Data Analysis: Unleashing the Analytical Power of Access + Access Data Analysis Cookbook + Access Database Design & Programming (3rd Edition)
Price for all three: $93.46

Buy the selected items together


Editorial Reviews

From the Back Cover

  • Go beyond Excel® with Access's more powerful analysis capabilities
  • Get better visibility into your data with custom views
  • Scale up your data pool without limitation
  • Master the four fundamentals of data analysis
  • Discover shortcuts with the helpful Input Mask Wizard
  • Integrate your data with the web and enterprise data sources
  • Avoid the common pitfalls of data crunching
  • Harness VBA to improve data analysis
  • Leverage information from the field with real-world scenarios

Companion web site

See examples from this book firsthand, in our companion web site at www.wiley.com/go/accessdataanalysis. The site also includes templates and tools to get you started.

About the Author

Michael Alexander is a Microsoft Certified Application Developer (MCAD) with more than 13 years experience consulting and developing office solutions. Michael started his career in consulting and development at the White House Communications Agency in Washington DC where he spearheaded the development of a standalone HRIS system for the White House’s Military Office. He parlayed his experience with VBA and VB into a successful consulting practice in the private sector, developing middleware and reporting solutions for a wide variety of industries. He currently lives in Plano, TX where he serves as the director of an analytical services department of a $700 million company. In his spare time, he runs a free tutorial site, www.datapig technologies.com, where he shares basic Access and Excel tips with intermediate users.

Product Details

  • Paperback: 552 pages
  • Publisher: Wiley; 1 edition (January 4, 2006)
  • Language: English
  • ISBN-10: 076459978X
  • ISBN-13: 978-0764599781
  • Product Dimensions: 9.1 x 7.5 x 1.2 inches
  • Shipping Weight: 1.6 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (23 customer reviews)
  • Amazon Best Sellers Rank: #816,778 in Books (See Top 100 in Books)

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

Most Helpful Customer Reviews
34 of 34 people found the following review helpful
5.0 out of 5 stars Practical number crunching with Access March 23, 2006
Format:Paperback|Verified Purchase
Many times have I been tasked to automate analysis with an application and I have always recommended Excel for doing anything with numbers and analyzing them. Doing anything like this with Access is usually a mystery and it takes a long time to put together until now. I was very skeptical since I have many Access books that do not go into detail about how to use Access in an analytical setting. The other books that I have just concentrate on programming, application developing or just simple that just teach you the basics of Access. This book puts it all together for you and even does a little VBA sampling so you can learn to use the analysis with an application you might already have.

I was extremely suprised at the way this book was composed with smart but simple step by step examples. The first few chapters saved me a ton of time after I learned many built-in functions for cleaning up data. The collection of functions in the appendix are a gold mine since these help you create expressions and also teach you by defining their meaning and use. After reading this book about a month ago I have been using Excel less and less to do my number crunching and reporting. I was a slave to the updating of cells, links,formulas and cleaning data that was given to me every week, month, and quarters. Now I just imported all my data to Access where I can analyze more data ,better and alot quicker than that other program.... I forget what that was, Oh yeah Excel.

You HAVE to get this book in your Access library if you do any work with data analysis and number crunching for financials or statistics. For all of you in any IT field like me that get told to "whip up" a program to crunch some statistics or financials.... this book will be the one to save your butt, it did it for me.
Comment | 
Was this review helpful to you?
22 of 22 people found the following review helpful
5.0 out of 5 stars Microsoft Access has never been that helpful January 18, 2006
Format:Paperback
I had many doubts this book would turn out like every other Microsoft Access book -- too much stress on Microsoft Access with much less to say about how to smartly use it. I was positively surprised. The book's focus on data analysis appplications like pivot tables and descriptive statistics made Access of much more use than I ever thought it would be.

I would strongly recommend buying this book. It has definitely changed the way I look at Microsoft Access.
Comment | 
Was this review helpful to you?
10 of 10 people found the following review helpful
Format:Paperback
Michael Alexander has done an excellent job of exploding the myth that Access can't do data analysis. Most people see Excel as the place to analyse data but when it comes to large volumes of data or related data sets Excel struggles to cope. Access is a great tool for handling large or complex data sets, but it isn't the most intuitive program when it comes to making sense of your data. This is where this book really comes to the rescue. It offers a wealth of information and ideas on how to use Access' built-in analytical tools as well as building your own with the help of Access Macros, SQL and VBA. There is a useful and concise section on Access basics for those new to the program, so both new and existing Access users can benefit from the author's clear explanations and many practical examples. If you have reached the point when it's time to move your data from Excel into Access, or maybe you are already an Access user and you need some expert guidance, this book will provide the inspiration and guidance you need.
Comment | 
Was this review helpful to you?
11 of 12 people found the following review helpful
By Shaz
Format:Paperback
First, let me start off by saying that this book is NOT for beginners. You need to have a good understanding of the different types of queries and functions before reading this.

That being said, once you're past the basics, you will find this book to be SO helpful. It breaks every topic down, provides warnings about certain pitfalls, and shows step by step with screen prints how to go about more complicated functions.

I love this book...enough to where I read it because I want to, not because I have to. If someone can write a technical book that makes an ordinary person like myself want to sit down and read it all, you know it's worth buying!
Comment | 
Was this review helpful to you?
6 of 6 people found the following review helpful
5.0 out of 5 stars A must-have for your Access library February 18, 2006
Format:Paperback|Verified Purchase
I have just spent 30 minutes randomly leafing through this book by Michael Alexander and my first impression is that this book is excellent. In the first 15 minutes alone I saw (1) a way to add the Rank to the output of a query (I could this before using a Make Table query and adding an ID field but this book's method is better), (2) getting a frequency distribution using one query (I could do this but my method using a linked query takes longer), and (3) parsing strings in a field separated by commas (this is exactly what the output looks like coming from a ERP system and I could do this using multiple Append queries, but again this book's method is better). The book also actually talks about gems like the Domain Aggregate Functions and the very valuable Switch function. This book is a must have for anyone that spends time in an auditing, forensic accounting, or general data interrogation role and that uses Access queries on archived data. The book is well-written and easy to follow, the topics are nicely grouped, and the screen shots are generic enough that you could follow along irrespective of whether you use Access 2000, 2002, or 2003.
Comment | 
Was this review helpful to you?
7 of 8 people found the following review helpful
5.0 out of 5 stars Awesome January 11, 2007
By Elise
Format:Paperback
I too had many doubts and spent a lot of time researching which book to buy or recommend to my students. I teach Access and many other software programs as well as run several businesses (so I use many software programs).

Plus, I spend a good deal of money on books each year myself. I hate to buy a book and feel I wasted my money. This book did not disappoint. It is Awesome--well thought out, well put together, exercises (download from website, not off a disk-great!) are the best I have ever seen! And I have seen enough lousy exercises to know when I see great ones! The author does a great job in common terms explaining every term and steps for success! Beginners will love it. Interm & Adv will love it also--It is not baby talk or demeaning to Interm/Adv students.

Normally, I recommend the series BIBLE for most software programs but not for Access. This is the book I am going to recommend from now on for all levels of students learning Access (except programmers). This is the book I recommend - beginner or not.

Way to go to the publisher Wiley for finding a great author for this subject and to the author Micheal Alexander! Awesome! 5 Stars!
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
5.0 out of 5 stars I like it.
I like it. It does what I want and I would buy another one if needed and recommend it to friends.
Published 5 months ago by Lee
5.0 out of 5 stars This book has unleashed my love for Access
I don't normally review books. But this books definitely deserves a review. If you are one of those folks looking to transcend the limitations of MS Excel but are intimidated by... Read more
Published on July 1, 2010 by queend
5.0 out of 5 stars Very helpful
This book has been very helpful to me in a role that is data analysis intensive. I recommend you have some understanding of access before you purchase this book.
Published on March 16, 2010 by Richard P. Krabbenhoft Jr.
3.0 out of 5 stars Book Review
The book was good but not what I was looking for. I wanted a book to assist with developing Access application to analyze data trends.
Published on February 10, 2010 by Howard Stugard
5.0 out of 5 stars Great book
This book is the best for anyone who doesn't have any SQL experience and needs to use the MS Access every day for some type of analysis. Read more
Published on October 8, 2009 by Lik
4.0 out of 5 stars Wonderful!
So, there you are at your Access job interview. You are a whiz at VBA, ODBC, SQL queries that boggle the mind and creating cool forms. Read more
Published on May 2, 2008 by Mike
2.0 out of 5 stars Well organized but poor explanations for "on the go" use.
Perhaps the biggest short coming of this book is the author's assumption that you will sit down and read the book from cover to cover. Read more
Published on July 8, 2007 by Cathy
4.0 out of 5 stars Very useful book
Yes, that's a very useful book. And the title don't lies, is a book for people that know the basics of access and wants to walk on the possibilities on data analysis.
Published on June 2, 2007 by R. M. Drudis Biscarri
5.0 out of 5 stars For Intermediate Users
This book is not for novices. However, slack a bit of deep programming. This book shows you the power inside MS Accesss through the macros and wizards. Read more
Published on May 11, 2007 by Osmin Magaña
4.0 out of 5 stars Great book.
I just bought this book for 28 USD, and when I got it I thought it had not much content. As I flipped through its pages, I found out it only describes how to use Access, but it... Read more
Published on April 15, 2007 by Electrical Residential Service
Search Customer Reviews
Search these reviews only

Citations (learn more)
This book cites 1 book:



What Other Items Do Customers Buy After Viewing This Item?


Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Forums

There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
Topic:
First post:
Prompts for sign-in
 



Look for Similar Items by Category