- 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)
- #345 in Books > Computers & Internet > Microsoft Windows > Applications > Excel
- #1115 in Books > Computers & Internet > Computer Science > Databases > Data Storage & Management > Database Management Systems
- #1572 in Books > Computers & Internet > Computer Science > Databases > Applications > Microsoft Access
- See Complete Table of Contents
The Excel Analyst's Guide to Access Paperback – 6 Apr 2010
|New from||Used from|
- Choose from over 13,000 locations across the UK
- Prime members get unlimited deliveries at no additional cost
- Find your preferred location and add it to your address book
- Dispatch to this address when you check out
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.
To get the free app, enter your mobile phone number.
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?
Top Customer Reviews
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.
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.
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.