Access Cookbook, 2nd Edition | 
 enlarge | Authors: Andy Baron, Kenneth Getz, Paul Litwin
Publisher: O'Reilly Media, Inc.
Category: Book
List Price: $49.95
Buy New: $28.94
You Save: $21.01 (42%)
New (26) Used (12) from $26.00
Rating:  21 reviews
Sales Rank: 57247
Format: Illustrated
Media: Paperback
Edition: 2nd
Pages: 840
Number Of Items: 1
Shipping Weight (lbs): 2.7
Dimensions (in): 9.1 x 7.2 x 1.6
ISBN: 0596006780
Dewey Decimal Number: 005.7565
UPC: 636920006787
EAN: 9780596006785
ASIN: 0596006780
Publication Date: March 1, 2004
Availability: Usually ships in 1-2 business days
Shipping: International shipping available
Condition: Brand new item. Over 3.5 million customers served. Order now. Selling online since 1995. Order with confidence. Code: B20080722212220T
| |
| Also Available In:
|
| Similar Items:
|
| Editorial Reviews:
Product Description
Not a reference book, and not a tutorial either, the new second edition of the highly regarded "Access Cookbook" is an uncommonly useful collection of solutions to problems that Access users and developers are likely to face as they attempt to build increasingly complex applications. Although using any single "recipe" in the book will more than pay back the cost of the book in terms of both hours saved and frustration thwarted, "Access Cookbook," Second Edition is much more than a handy assortment of cut-and-paste code. Each of the "recipes" examine a particular problem--problems that commonly occur when you push the upper limits of Access, or ones 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. The authors then, in a clear, accessible, step-by-step style, present the problems' solution. Following each "recipe" are insights on how Access works, potential pitfalls, interesting programming techniques that are used in the solution, and how and why the solution works, so you can adapt the problem-solving techniques to other similar situations. Fully updated for Access 2003, "Access Cookbook," Second Edition is 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. Access power users and programmers at all levels, from the relatively inexperienced to the most sophisticated, will rely on the "AccessCookbook" for quick solutions to gnarly problems. With a dog-eared copy of "Access Cookbook" at your side, you can spend your time and energy where it matters most: working on the interesting facets of your Access application, not just the time-consuming ones.
|
| Customer Reviews: Read 16 more reviews...
 One of the most invaluable references I have in my library October 12, 2006
R. L. Henry (Mason, Ohio)
3 out of 3 found this review helpful
I'll keep this brief, as my title says it all. I have been developing access applications on a professional level for many years. Have several applications that large companies use to run there business. This cookbook has helped me in more ways then I can count. I wish I could find more like it. I use it just as a cookbook. Look thru to find a similiar situation that I am trying to solve. The examples are written very well. The code is very exact and on the money. While most of the examples listed are not always exactly like what I'm trying to solve, it definitely gets the creative juices flowing on how to solve my problem.
The other good things, there are several useful "tips" that you can use to implement in many of your applications that will help the users have a better experience.
Definitely a must have if you wish to write serious applications.
Recipes for Access Developer Success May 21, 2005
JRK (VERMONT)
19 out of 19 found this review helpful
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.
Access Developers.. this is a must have! January 20, 2005
JCee (On earth)
12 out of 12 found this review helpful
When I started my job, my first assignment was develop several Access databases. What they wanted was beyond what I knew of Access. After buying this book and Access Database Programming and Design, I was well on my way to develop a quite advanced Access database application. I would ask myself, "I wonder if I can..." After consulting this book for the anwser, BAM! I found it there. This book covers everything from simple VBA to advanced techniques such as incorporating a email system into a database, linked dropdown combo boxes using SQL, and creating VB Form control that tells you who all is currently in a database using ADO and VBA! I would say anyone wanting to cook a mean Access database should definitely pick this one up. It is an invaluable reference if you want to develop professional Access databases with incredible functionality!
I'm a ColdFusion guy, so read this review with that in mind: November 11, 2004
Geoff Lilley (Sacramento, CA United States)
7 out of 7 found this review helpful
This book I would recommend for people who use Access as their back end, and need to add some automation to their back end. It deals mostly with using VBA to solve problems, like:
* How to create an input box where you can get some better info than the standard VBA one
* Call Excel functions, and apply them to Access data
* Figure out which users have a shared database open, if you're
doing a blended Access/CF solution
* Managing report printing (see next set of bullets)
I recommend checking out this book under the following circumstances:
* You have internal and external clients hitting your database. In a situation like that, you can have your internal users access the database using a well-designed Access application, which this book will give you some tricks on how to create.
* In the alternative, you want to manage and analyze your data, and create print reports. That's where Access just as a stand-alone application gives a substantial advantage over any Web technology.
For a ColdFusion developer, there are some topics in this book that probably wouldn't do much good:
* Adding Smart Tags functionality to a database - if you're expanding beyond the reach of Microsoft Office, Smart Tags prove to be a nifty proprietary parlor trick
* Using Access' security management tools to manage user rights to database objects. If I run a Windows server, I would use Challenge and Response to create NTFS based permissions on my pages in my application that manage data. Otherwise, I'll use application-based usernames and passwords, same net result.
* Exporting Access data as XML using pre-defined schemas. Not bad, but ColdFusion has far better technology.
Don't get me wrong - those last three bullets are not any disrespect to this well-written, well-organized guide. I'm just looking at, "What topics would interest you if you're a ColdFusion developer?"
If you do want to learn more about Access database development as an art unto itself, this is not the place to begin. This is the place to arrive at.
Unique resource for experienced access users July 29, 2004
Jack D. Herrington (Silicon Valley, CA)
6 out of 8 found this review helpful
Those familiar with Access may not be familiar with O'Reilly's Cookbook series. The Cookbook series takes common tough problems and provides simple recipes, often with multiple alternative takes, to solve the problem. The value is not only in reference, it also shows you new techniques for using Access or VB is new ways that you may not have thought of.
I highly recommend this book for any experienced Access user, or anyone looking to become an Access expert. This book will stretch your skills and make it easier to nod your head yes when your boss asks you to solve some tricky problem.
|
|
|
