Access Cookbook
Publisher: O'Reilly Media
Final Release Date: February 2002
Pages: 720

Access Cookbook contains a comprehensive collection of problems, solutions,and practical examples for the Access power user or programmer who is running up against some of the apparent limits of the Access user interface or of Access application development. The diverse problems and solutions presented here are of interest to Access power users and programmers at all levels, from the relatively inexperienced to the most sophisticated.

Each of the book?s 14 chapters focuses on a particular topic area related to the Access environment or Access programming. Within each chapter, individual items follow a standardized format. The authors first pose the problem, and then present its solution. Finally, a discussion follows, which consists of extended analysis of the solution, an insightful examination of how Access works, or interesting programming techniques that are used in the solution but that you can also apply elsewhere.

The kinds of problems posed and solved in the book include the following:

  • 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

The accompanying CD-ROM includes Access databases that contain the solutions for all problems presented in the text.

Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
O'Reilly MediaAccess Cookbook
 
3.3

(based on 3 reviews)

Ratings Distribution

  • 5 Stars

     

    (0)

  • 4 Stars

     

    (2)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (1)

  • 1 Stars

     

    (0)

Reviewed by 3 customers

Sort by

Displaying reviews 1-3

Back to top

(0 of 1 customers found this review helpful)

 
4.0

Access Cookbook Review

By Ed Blom

from Undisclosed

Comments about O'Reilly Media Access Cookbook:

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

(0 of 1 customers found this review helpful)

 
2.0

Access Cookbook Review

By Hugh Hemington

from Undisclosed

Comments about O'Reilly Media Access Cookbook:

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.

(1 of 1 customers found this review helpful)

 
4.0

Access Cookbook Review

By Michael

from Undisclosed

Comments about O'Reilly Media Access Cookbook:

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.

Displaying reviews 1-3

Back to top

 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?