Category: Book
Used starting at $21.46
New starting at $22.99
Buy itChart a course for more effective data analysis with Access 2007. With this resource, you’ll learn how Access 2007 offers powerful functionality that may be better suited to your data analysis needs. Learn to analyze large amounts of data in meaningful ways, quickly and easily slice it into various views, automate redundant analysis, and save time—all using Access. If you know a bit about table structures and formulas as well as data analysis, start thinking outside the chart.
| Publisher | Wiley |
| ISBN | 0470104856 |
| Features |
|
| Format | Paperback |
| Author | Michael Alexander |
| EAN | 9780470104859 |
| Label | Wiley |
| Dewey Decimal Number | 005.7565 |
| Studio | Wiley |
| Number Of Pages | 552 |
| Title | Microsoft Access 2007 Data Analysis |
| Publication Date | 2007-03-26 |
| Manufacturer | Wiley |
Review by Thomas G. McDowell, 2010-08-17
This is a very good book for doing exactly what the title says. Easy to follow and there are a lot of useful tips on how to design queries and perform solid data analysis using Access. This is not a beginners book on how to use Access but a good learning tool once a few Access fundamentals have been learned elsewhere.
The Kindle edition has problems. Many of the screen shots of the actual examples (in particular of the query builder) are not readable on the kindle (and aren't readable on the kindle for PC), unfortunately for many of the sections this renders the information useless since it means you can't actually read the instructions for what is being demonstrated.
The hardcopy book is a 5 the Kindle version a 1 or 2. Hopefully the Kindle version can be reformatted and redistributed.
Review by Sam Ramsey, 2010-08-01
I consider myself an advanced Excel user. I've recently started using Excel to analyze very large datasets... and have quickly started to realize that Excel may not be the best tool for the job. I was running Subtotals on a 600,000+ line spreadsheet, which was taking HOURS for the progress bar to move.... a coworker saw what I was doing and put the same dataset in Access and got the result I wanted in minutes. That was my "aha!" moment with Access.
After that experience I've tried learning Access by taking an online course (from Microsoft), and reading 1 other book... They just didn't work for me. I'm pretty computer savvy but I just couldn't "get" Access. I'm so used to Excel. So I've been struggling with this.
I've got my new Kindle DX and decided to see what books on Access were out there. Downloaded several samples, and ended up purchasing this one.
This book is targeted towards people like me -- advanced Excel users who realize that Excel isn't always the right tool for the job, who want to learn Access, but have had trouble figuring it out. PERFECT. Exactly what I needed.
It's well written and well paced. It starts out with a lot of comparisons between Excel and Access. I feel like everything is "clicking" now and I'm quickly realizing how incredibly powerful Access is. I wish I had found this book 6 months ago when I started trying to learn it because the online class I had taken, and the other book I had read just didn't work for me. This book has been a life-saver!
I would like to comment specifically on the Kindle edition of this book... I have a Kindle DX. I must admit that I am disappointed in the quality of the pictures. This is not a fault of the Kindle, but a fault of the book. Some of the screenshots (even with zooming in) have such poor quality that it can be difficult to see what is going on. It didn't stop me from getting what I needed out of the book, but that was a little disappointing.
Also one other thing -- I was pleased to find out that the publisher, on their website, has posted all of the databases / tools that are included on the CD-ROM that comes with the regular version of the book. That is much appreciated. There are sample databases that you follow along with. I noticed that, for some of the other Access books on Kindle, the publishers do not offer the additional electronic content online.
All in all, this book was a life-saver for me and has helped me learn Access. I would highly recommend it to other Excel users who are having a hard time making the switch.
Review by Jacob Holmsgaard Fischer, 2010-02-14
a really good book for "beginners" who is familiar with the basic concept of relationel databases og controllers/analysts who final have discovers the limitations of excel.
It takes you thru the most needs stuff, to get to started. Has good examples that are easy to understand.
Review by A. Gautam, 2008-09-27
has a quick and well written introduction to creating queries in Access. Also covers some more advanced data analysis tools. Well worth the investment.
Review by M. Haslip, 2008-08-10
I just ordered Microsft Access 2007 Data Analysis, and paid the extra $ to use the "Amazon Online Reader" option.
Upside: as promised, I am able to immediately view the entire book using the Online Reader :-). The material seems excellent and I'm anxious to start working with the solutions the author is trying to provide me, but . . .
Downside: the Online Reader image quality is fuzzy, and renders the small font images and screen captures in the book illegible :-( Tres' aggravating since the details of the solutions are spelled out in text that I Just Can't Quite Read. I'm chomping at the byte for the postman to bring my hard copy!
I have emailed a query to Amazon's customer service folks, asking if there is a user-end fix for this dilemna. But, unless they have a solution, I would have to opin that the book itself appears well written and informative, but the Online Reader Option for this and other manuals with graphics needs refinement before I spend any more money on the service.
PS - Yes, the OnLine Reader problem is not limited to this book. A second book, different author, different publisher, which I purchased on-line Amazon Digital rights to at the same time is also fuzzy at best and the small type is not legible. //
Microsoft Excel and Access Integration: With Microsoft Office 2007
Used starting at $21.06
New starting at $22.55
Microsoft Office Access 2007 Inside Out (Microsoft Office Access Inside Out)
Used starting at $19.99
New starting at $30.99
Access 2007 VBA Programmer's Reference (Programmer to Programmer)
Used starting at $23.35
New starting at $23.25