£31.99
FREE Delivery in the UK.
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
The Excel Analyst's Guide... has been added to your Basket
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 3 images

The Excel Analyst's Guide to Access Paperback – 6 Apr 2010

3.0 out of 5 stars 5 customer reviews

See all 4 formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
£31.99
£16.98 £17.12
Note: This item is eligible for click and collect. Details
Pick up your parcel at a time and place that suits you.
  • Choose from over 13,000 locations across the UK
  • Prime members get unlimited deliveries at no additional cost
How to order to an Amazon Pickup Location?
  1. Find your preferred location and add it to your address book
  2. Dispatch to this address when you check out
Learn more
£31.99 FREE Delivery in the UK. Only 1 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.
click to open popover

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone

To get the free app, enter your mobile phone number.



Product details

  • Paperback: 624 pages
  • Publisher: John Wiley & Sons; 1 edition (6 April 2010)
  • Language: English
  • ISBN-10: 0470567015
  • ISBN-13: 978-0470567012
  • Product Dimensions: 18.8 x 3.1 x 23.6 cm
  • Average Customer Review: 3.0 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon Bestsellers Rank: 1,169,305 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

From the Back Cover

Use the right tool for the job

Like many managers, accountants, and analysts, you′ve been using Excel for data analysis. It′s a good tool, but you′re beginning to find its limitations frustrating. You′re looking for more scalability. More transparency of analytical processes. The ability to separate data from presentation.

Access makes it all possible, and this guide helps you add Access to your analytical toolbox. Learn the essentials of using Access, basic and advanced analysis techniques, how to build reports, and much more. Then you can choose the right tool for every job.

  • Easily move data between Excel and Access

  • Normalize and store Excel data in a structured relational database

  • Use Access to analyze large amounts of data

  • Use Excel pivot tables with Access data

  • Build reports and implement dashboard–style visualizations

  • Report Access data using Excel′s presentation layer

  • Automate redundant reporting and analysis using Excel and Access macros

  • Save time and increase productivity by automating redundant processes using VBA

  • Get external data using SQL, ADO, and XML

About the Author

Michael Alexander is a Microsoft MVP and a veteran consultant. He creates and shares video tutorials with the Microsoft Excel and Access communities via www.datapigtechnologies.com. Mike has written several books on advanced business analysis, including Microsoft Access 2007 Data Analysis, also from Wiley.


What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

3.0 out of 5 stars
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback Verified Purchase
I bought this mainly for the section on connecting excel to access which I'm finding really useful . i consider myself as a long time power user of excel and occasional dabbler with access this book is helping me get up to speed with the more recent versions of access .
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
This is a clear well-written guide to using Access instead of misusing Excel for database analysis.
The book sets out clear worked examples from a sample database. The database can be downloaded from the publisher's website. This is not the website address given in the book, but you are redirected and can find the database with a little searching.
When you have downloaded the sample Access database (it is quite large)you will find that you cannot use Office 07 to open it. The database is "not recognised". The worked examples are therefore not available to you.
Two emails to the publisher asking for help were completely ignored.
As the use and understanding of the book depends on working through and understanding the examples, the book is useless.
Let me repeat that. This book is unusable, completely useless.
I would not buy any item from this publisher - John Wiley & Sons.

(As an aside, it would make more sense to include the database stuff on a CD included with the book.)

Amazon should withdraw this book as it is not of merchantable quality in my opinion,and it may be illegal to sell it.
1 Comment 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
Our Bookkeeper loves it! Nice condition too :-)
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
This book is an exact copy of his previous one:
[...]

To bleed unsuspecting people of their hard earned money he changed the title and used different cover. I'll not be purchasing any future books from this author.

Having owned his previous book (the one above) and judging by the title I was expecting to find detailed and in depth coverage of how to properly normalize complex Excel's flat data into relational tables, some solid explanation of database theory, couple of chapters on how to build complex reports from within Access and best practices on the usage of Excel as a presentation layer and Access as a database - this book has none of that even though back cover mentions them...

If you're an Excel analyst and want to learn data analysis with Access this book is decent but if you're looking to properly integrate Access and Excel and are new to databases then you'll need something else.

In the 'Acknowledgements' section the author is thanking some Dick Kusleika as the best tech editor he ever worked with this made me chuckle as the index for this book only goes to the letter 'B'... . Well done to Dick (best tech editor in the world) and Michael for producing the first technical book in the world without an index section.

This book is going back straight to Amazon for a refund.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
This book is exactly what I need. An Excel user since 1991, I have previously tried and failed to get to grips with Access.

Although I hoped to use Access 2000 the exercise file downloaded from Wiley used the Office 2007 formats. The book is of little value if you can't use the exercise files.

I had to buy Microsoft Access 2010 (PC DVD) and that opened the example database with no problems. As far as I can see readers will also benefit from having Excel 2010, though Excel 2007 ought to do.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse


Feedback