Customer Reviews

Microsoft Access Data Analysis: Unleashing the Analytical Power of Access

5 star:		(16)
4 star:		(3)
3 star:		(1)
2 star:		(1)
1 star:		(1)

 

 

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.

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.

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.

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!

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.

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!

Needing to go beyond Excel? Wanting to start using Access for all your data analysis needs? This is the book for you. Great primer for those Access developer books. Takes you from the beginning into some pretty cool advanced topics. Data discussed in examples is also available for download. A must have for anyone using MS Access for any data analysis project.

I have been working with data analysis and generation of metrics for the last three years. Even in that seemingly short time plenty of puzzling problems about data analysis using MS Access had built up in my gray cells. I was able to apply the concepts from a number of the authors examples with immediate positive results. This is a book I keep handy at my desk.

If you are looking for a way to explain to your users/clients the core benefits of using Access versus Excel and when it makes sense to use both, then read this book. I think Michael Alexander explains it very well.

If you want to be successful at analyzing data with MS Access, then study this book.

If you are an experienced Excel user, like me, and every time you tried to learn Access you always gave up, because you consider it too dificult to understand or simply because you do not have any time at all, THIS IS THE BOOK. Give a try and you won't regret.

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 has not many application examples, if any.

This makes sense, because statistics and its presentation tools as are pivot tables and pivot charts in their varied forms, are user and application specific. So, this book is small with merely 12 chapters in or around 338 pages and the rest of the book to complete the 486 pages of content is made up of apendices, meaning that it's more of a reference book to whet your appetite to use Access as a Data Analysis tool and move away from Excel, which I strongly, strongly recommend you do as soon as possible for the power of Access as a fully functional database software.

Overall, it's a very good book, but I gave it a 4 out of 5, because if you already use pivot tables and pivot charts in Access, you will mostly be using the apendices for reference on formulas and VBA functions, which is a little overpriced for what it delivers. If you already use access to analyze data to the pivot table and charts level, you won't be needing much of its content, so I'd recommend you buy a used copy of the book.

Otherwise, if you're ready to move to data analysis from Excel to Access, this is the book for you to get you started and making you a true expert in managing Access' powerful features.