Access Cookbook, 2nd Edition (Paperback)

by Andy Baron (Author), Kenneth Getz (Author), Paul Litwin (Author)
Key Phrases: object library, web part connections, financial symbol, Private Sub, Public Function, End Sub (more...)

Editorial Reviews

Product Description
Access power users and programmers at all levels, from the relatively inexperienced to the most sophisticated, will rely on the Access Cookbook, Second Edition for quick solutions to gnarly problems. Each of the book's "recipes" examine a particular problem--problems that commonly occur when you push the upper limits of Access, or those that are likely to trip up a developer attempting to design a more elegant Access application --even some things you never knew Access could do. Fully updated for Access 2003, it's also one of the first books to thoroughly explore new support for .NET managed code and XML. All of the practical, real-world examples have been tested for compatibility with Access 2003, Windows XP, and Windows Server 2003. This updated new edition also covers Access and SharePoint, Access and SmartTags, Access and .NET; and Access and XML.

About the Author
Andy Baron is a senior consultant at MCW Technologies, a Microsoft MVP (Most Valuable Professional) since 1995, and a contributing editor for Advisor Media and Pinnacle Publications. Andy is co-author of the Microsoft Access Developers Guide to SQL Server

Ken Getz is a senior consultant with MCW Technologies and splits his time between programming, writing, and training. He specializes in tools and applications written in Visual Studio .NET and Visual Basic. Ken is co-author of best-selling several books,

Paul Litwin is the president of Litwin Consulting, providing development, mentoring, and training in ASP, ASP.NET, Visual Basic, SQL Server, XML, Microsoft Access, and related technologies. Paul was the founding editor of the Smart Access Newsletter and r

Product Details

• Paperback: 840 pages
• Publisher: O'Reilly Media, Inc.; 2nd edition (March 1, 2004)
• Language: English
• ISBN-10: 0596006780
• ISBN-13: 978-0596006785
• Product Dimensions: 9.1 x 7.2 x 1.6 inches
• Shipping Weight: 2.6 pounds (View shipping rates and policies)
• Average Customer Review: 4.6 out of 5 stars See all reviews (22 customer reviews)
• Amazon.com Sales Rank: #68,688 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #3 in	Books > Computers & Internet > Microsoft > Applications > Office 2000
  #44 in	Books > Computers & Internet > Microsoft > Development > SQL Server

Customer Reviews

Most Helpful Customer Reviews

42 of 45 people found the following review helpful:

5.0 out of 5 stars Well, it's about damn time!, June 9, 2002

By	C. J. Elder (Santa Maria, CA United States) - See all my reviews (REAL NAME)

This review is from: Access Cookbook (O'Reilly Windows) (Paperback)

This is the book that the Access programming community has needed for years! It uses a Problem - Solution - Discussion format instead of the usual academic "let's disect Access's capabilities, throw them at you in little bits, and let you figure out the WHY later" format. Even the table of contents is much more readable and understandable. You know the reason for reading the chapter right from the start, not at the end.

Don't get me wrong. I'm not bashing the multitudes of other Access reference type books, it's just that we finally have a book that fills a BIG gap. Once you read this book, you'll have more use for the others. This book and the others complement each other nicely.

The format of this book is not exactly new, however. Rob Krumm's programming for dummies books have used this format for years (albeit not as explicitly), which is why I enjoyed them so much and always hoped he would go beyond the beginner level Access programming books. Access Cookbook does exactly that, and in a very refreshing way.

Two things about this book were a big surprise to me. 1. Ken Getz wrote it and 2. O'Reilly published it. I couldn't think of 2 better choices! Ken Getz takes his high level expertise and writing style and transforms it into a new book that opens up his experience to a much wider audience. THANK YOU! THANK YOU! THANK YOU! And then there's good ole O'Reilly publishing who have always had a talent for presenting a very academic subject to a less academic audience without loss of rigor.

"Cookbook" is an ok word for the title I guess, but I think "Storybook" may be more fitting, because I find that when I start a section of a chapter, I just can't put down the book until I see how the section ends. Likewise, when I start reading a Discussion section, I have to read it all before I put the book down and hit the keyboard. I even use this book for bedtime reading!

Enjoy!

20 of 20 people found the following review helpful:

5.0 out of 5 stars Recipes for Access Developer Success, May 21, 2005

By	JRK "jkunzvt" (VERMONT) - See all my reviews

The Access Developer's Handbook Set (search ISBN: 0782140114) and in particular, Volume 1: Desktop Edition (search ISBN: 0782123708) is my definitive resource to approximately 4 years of Access development. I've got more stickies and highlights in this set than all other Access books combined. So when I came across the Access cookbook and realized that the same two indispensible authors (Getz & Litwin) put together a resource of Access developer solutions, I had to have it.

This book has not let me down. It is certainly geared towards the intermediate to advanced Access professional developers who already understand the basics of Access and more importantly, who also understand the shortcomings of Access and the benefits of getting around those shortcomings. There are about 170 solutions in this book that are segmented into 18 chapters of high-level topics such as Queries, Forms, XML, UI, VBA, Windows APIs, even Smart Tags. I would be really surprised to find someone who picked up this text, thumbed through the solutions, and found that there was nothing they could get out of this book.

I would say that if you are developing a professional Access front-end and/or database, you owe it to yourself to buy this book and review each solution before you release or ship your product. I did, and found either new answers and existing improvements to many of the things I was struggling with during my development cycles.

12 of 12 people found the following review helpful:

5.0 out of 5 stars A book for Access Developer & Power Users, June 20, 2003

By	Henry W. Jenkins (Queen Creek, AZ USA) - See all my reviews (REAL NAME)

This review is from: Access Cookbook (O'Reilly Windows) (Paperback)

Although I am an Access Developer (6 years), I have purchased no fewer than 15 - 20 books on Access 97, 2000, 2002.
Access Cookbook I purchased in late 2002 primarily for the first word at the top of the cover page - "Solutions".
True to the meaning, this book provides "how to " programming solutions that I have struggled with and needed over the past last 6 years.
Explanations are concise, and clear. And you get a CD with the examples which is worth many times the book costs.
I have other books by the authors; Developers Handbook for Acces 97 and 2000, and VBA for Developers. These books (1500 pages) primarly benefit the intermediate to advanced users.
The Access Cookbook should be a extremely helpful even to the beginning users (which we all were at some point).
Enjoy.