Shop now Learn more Shop now Shop Clothing clo_fly_aw15_NA_shoes Shop All Shop All Amazon Fashion Cloud Drive Photos Shop now Learn More Shop now Shop Fire HD 6 Shop Kindle Paperwhite Shop now Shop Now Shop now

Customer Reviews

3
3.7 out of 5 stars
5 star
1
4 star
0
3 star
2
2 star
0
1 star
0
Access Data Analysis Cookbook (Cookbooks)
Format: PaperbackChange
Price:£33.50+Free shipping with Amazon Prime

Your rating(Clear)Rate this item
Share your thoughts with other customers

There was a problem filtering reviews right now. Please try again later.

1 of 1 people found the following review helpful
(The last paragraph is a short review!)

The idea of these cook books is you can dip in and find specific solutions to specific problems all coded up for you, or to have a similar examples to look at. This specific book is for Microsoft Access databases and most examples are for the 2007 but can be applicable for most versions. It looks at queries and VBA (mostly using ADO, not DAO, but both covered).

I'm experience with Access and read this cover to cover to broaden my horizons. For me it was interesting and useful but didn't really teach me too much new. I can see this working best for someone new to Access once they've read an introductory book. The beauty of these sort of books is being focused on specific problems and solution rather than generally how to do things.

If you getting this to read lots of fancy data analysis techniques I think it will be disappointing. The import, financial (includes charts) and statistical chapters should be useful but it's not going to give you loads and loads to go away and work with. I'd call it more a data manipulation cookbook.

The layout of the book is nice and simple and neat. There's plenty of nicely and clearly layed out code and tables. The book is soft cover, 340 pages long with 10 chapters:
1 - Query Construction
2 - Calculating with Queries
3 - Action Queries
4 - Managing Tables, Fields, Index and Queries
5 - Working with String Data
6 - Using programming to Manipulate Data
7 - Importing and Exporting Data
8 - Data and Time Calculations
9 - Business and Financial Problems
10 - Statistics

The first 3 chapters aren't really going to teach you too much beyond what a normal introductory book will so can be seen as a good recap or a bit of a waste.

Chapter 4 is interesting as it shows you how to programmably amend tables. Chapter 5 should be interesting to the newer user and a few bit for the more experienced. Chapter 6 was pretty interesting and introduces the important commit and roll back for transaction. Chapter 7 is good a dealing with a range of data sources so specifications and VBA with excel, outlook and XML (a lot on XML).

Chapters 9 and 10 are interesting to show you some quite long chunks of code to do some neat financial and statistical tasks and calculations.

The code is neat but I would say some is over verbose when near identical chunks of code are repeated when one chunk and an extra if or select statement would do.

I would recommend this book to someone fairly new to access as a good source of examples that could be applied to a specific set of tasks or give you the template / foot in to complete your own specific tasks. More experience access users may find it less useful. Either way I'd recommend you have a look at the contents in some detail to see if it covers areas of interest, especially the first three chapters on queries which are pretty standard. Also bear in mind the data analysis name might be a bit misleading; the book covers it but its not wall to wall nor as broad as the name might suggest.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
1 of 1 people found the following review helpful
on 10 January 2010
This book is simply excellent. It assumes intelligent engagement with the issue of data analysis. It assumes some experience of Access: it doesn't hand-hold. It is written in a gently laconic style; and, because it's discursive, all the more engaging. My copy is full of PostIts, a sure sign of constant use. I hope it will be updated this year (2010) to include discussion about the new version of Access due this summer.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
on 2 September 2013
Bought this product for someone else so cannot comment on it other than it was delivered quickly and intact and reasonably priced.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
     
 
Customers who viewed this item also viewed

Professional Access 2013 Programming
Professional Access 2013 Programming by Teresa Hennig (Paperback - 5 Sept. 2013)
£29.59
 
     

Send us feedback

How can we make Amazon Customer Reviews better for you?
Let us know here.

Sponsored Links

  (What is this?)
  -  
Watch this Free On-Demand Webinar & Learn How to Make It Easy Now!
  -  
Award-Winning Data Analysis Tool. Fast & Simple. Get a Free Trial!
  -  
Download our strategic white paper: How to Create a Data-Driven Dynasty