If you need to crunch numbers in Access, you need this book!

books:


	• Microsoft Access Data Analysis: Unleashing the Analytical Power of Access Michael Alexander Wiley, 2006 - 552 pages average customer review:based on 19 reviews view larger image
	for more information click here

highly recommended

Very practical advice from real experience

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.

for more information click here

If you need to crunch numbers in Access, you need this book!

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.

for more information click here

A must-have for your Access library

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.

for more information click here

Microsoft Access has never been that helpful

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.

reviews: 1, 2, 3, page 4

hot

not?

What's your opinion?

Write a review and share your thoughts!

search for books
microsoft access, access, analysis, analytical, data, microsoft, power, unleashing

Impressum / about us