By Ken Getz, Paul Litwin, Andy Baron
February 2002
Pages: 718
ISBN 10: 0-596-00084-7 |
ISBN 13: 9780596000844
(Average of 3 Customer Reviews)
This book has been updated—the edition you're requesting is OUT OF PRINT. Please visit the catalog page of the latest edition.
The latest edition is also available on Safari Books Online.
Access Cookbook provides solutions to practical user interface and programming problems for the Microsoft Access power user or programmer who is running up against some of the apparent limits of the software. The book contains a comprehensive collection of problems, solutions, and practical examples for Access power users and programmers at all levels, from the relatively inexperienced to the most sophisticated.
Full Description
- Specifying query criteria at runtime, rather than at design time
- Restricting the user to a single row of a form
- Preventing a report from printing if it has no records
- Making slow forms run faster
- Insuring that user interface objects present a uniform, consistent appearance
- Controlling a printer's paper source programmatically
- Referencing data from multiple SQL Server databases in a single Access Data Project page
- Using contact information from an Access database when sending email using Outlook
Register your book | Submit Errata | CD-ROM
Browse within this book
Cover | Table of Contents | Index | Sample Excerpts | Colophon
Book details
First Edition: February 2002
ISBN: 0-596-00084-7
Pages: 718
Average Customer Reviews: (Based on 3 Reviews)
Featured customer reviews
Access Cookbook Review, September 09 2003
This is the book that just gave me the answers I was looking for. I make several program in Access for a long time (about 3 years) and the book gave me the clues that I could use in many applications.
The book is a summery of all kind of solutions to typical problems or shortcommings that a moderate Access-programmer will meet during the development of several application
For me it was the right supplement to book I already own of access
Access Cookbook Review, August 28 2003
Typical incomplete tome...
One piece of code that I was looking for referenced another piece of code that was omitted! (acbMakeListTable).
...as I said, typical.
If you've got time to waste, this book is for you.
Access Cookbook Review, May 22 2002
I found the book to be an excellent resource. My only wish was that it was even bigger since the format allows you to open the book to any subject and dive right in. Once you inhale the information you can't help but want more.
As a pseudo-VB programmer (actually an energy analyst that uses databases as a daily job function), I love the approach of this book: Problem, Solution, Discussion. Gets me right to the point and actually brings up other issues worth considering. The style of writing is almost like having a real-life Access guru right in your cubicle giving you the full story. I especially appreciated the orientation of the book where you are encouraged to copy the VB code examples in their entirety and figure them out for yourself later (after reading the solution and discussion of course). Many other books require you to start at chapter 1 and make the proverbial employee's database from scratch. If you skip a chapter to find a meaningful function or section, you generally have to make your database conform to the example in order to work. Not so with this book - it provides concrete examples that are free standing and generally provide more information (due to being self contained) that what is even described in the book. I like that. Lastly, the code examples are excellent for my level of VB.
So, I highly recommend this book - it now stands alongside my Access 97 gigantic reference manual on my desk and I suspect this book will become equally dog eared and worn.
Thanks for a great book.
Michael - 5/22/02
PS - I do have one complaint - the CD contained only Access 2000 examples that took up 63MB of space. Since the CD can hold upwards of 70MB, it would be nice to include the Access 97 code examples as well. Fortunately I downloaded them from your website. Thanks for making the files available.
Media reviews
"a good book with clear code and some interesting suggestions about solutions for a wide range of problems."
--Computer Shopper, Aug 2002
"If you've ever wondered how to create an Access query that uses case-sensitive criteria or how to keep a report from breaking at an inappropriate spot, check out 'Access Cookbook' by Ken Getz, Paul Litwin, and Andy Baron (O'Reilly & Associates, $49.95, ISBN 0-596-00084-7). The authors show you how to overcome these problems--and much more--for Access 97, 2000, and 2002...'Access Cookbook' isn't for the newbie Access user, but if you've worked with Access for a few months and want to improve your Access database's user interface or advance your Access programming skills, this is the book for you. The results are sure to be delicious."
--James E. Powell, The Office Letter, May 13, 2002
"The cookbook style is great for technical books. Not a reference book, but not a tutorial either, an interesting mix of both, which allows the author to present practical solutions without worrying about complete coverage of the domain... The 'Access Cookbook' contains a lot of useful material. And it isn't hidden amongst the dross as in many books about software. The cookbook style is well used to present an extremely high signal to noise ratio for this type of book..If you use Access to create applications then you will certainly find some useful recipes in this book. I suspect you will find many; I've used Access for many things over the years and found some very useful solutions and better ways of doing things I had worked around."
--Sam Holden, Computer Science Undergraduate Society, May 2002
"The title pretty well says it all, and if you work with Access or plan to or even just want to know some of the things Access can do, you need this book."
--Jerry Pournelle, Byte.com, April 8, 2002
"The 'Access Cookbook' really surprised me by how it covers topics regarding Microsoft Access that none of the other reference books talk about. I have an extensive Access reference collection, and the Access Cookbook far outshines them in practical solutions to real, practical development problems, and also covers innovative ways to do things that you might not otherwise think of doing?I've been developing in Access for more than a year, and the Access Cookbook has shown me things that I never dreamed could be done inside of an 'application' versus a full-blown Visual Basic development environment. The 'Access Cookbook' is an excellent addition to any Microsoft Access developer's library."--Donna Lamb, St. Louis Visual Basic User's Group, March 2002
