Customer Reviews


3 Reviews
5 star:
 (1)
4 star:    (0)
3 star:
 (2)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
Share your thoughts with other customers
Create your own review
 
 

The most helpful favourable review
The most helpful critical review


1 of 1 people found the following review helpful
5.0 out of 5 stars An excellent 2nd book about Access
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...
Published on 10 Jan 2010 by I. S. Simpson

versus
1 of 1 people found the following review helpful
3.0 out of 5 stars 4 Star for Novice, 2 Star for Experienced
(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...
Published on 6 July 2012 by Hagrid's Umbrella


Most Helpful First | Newest First

1 of 1 people found the following review helpful
5.0 out of 5 stars An excellent 2nd book about Access, 10 Jan 2010
This review is from: Access Data Analysis Cookbook (Cookbooks) (Paperback)
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.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


1 of 1 people found the following review helpful
3.0 out of 5 stars 4 Star for Novice, 2 Star for Experienced, 6 July 2012
By 
Verified Purchase(What is this?)
This review is from: Access Data Analysis Cookbook (Cookbooks) (Paperback)
(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.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


3.0 out of 5 stars Access Data Analysis, 2 Sep 2013
Verified Purchase(What is this?)
This review is from: Access Data Analysis Cookbook (Cookbooks) (Paperback)
Bought this product for someone else so cannot comment on it other than it was delivered quickly and intact and reasonably priced.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


Most Helpful First | Newest First

This product

Access Data Analysis Cookbook (Cookbooks)
Access Data Analysis Cookbook (Cookbooks) by Wayne S. Freeze (Paperback - 24 May 2007)
£32.50
In stock
Add to basket Add to wishlist
Only search this product's reviews