Skip to Main Content
Access Cookbook
book

Access Cookbook

by Andy Baron, Ken Getz, Paul Litwin
February 2002
Intermediate to advanced content levelIntermediate to advanced
720 pages
21h 37m
English
O'Reilly Media, Inc.

Overview

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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

ADO.NET Cookbook

ADO.NET Cookbook

Bill Hamilton
Access Cookbook, 2nd Edition

Access Cookbook, 2nd Edition

Ken Getz, Paul Litwin, Andy Baron
Access Data Analysis Cookbook

Access Data Analysis Cookbook

Ken Bluttman, Wayne S. Freeze
Access Hacks

Access Hacks

Ken Bluttman

Publisher Resources

ISBN: 0596000847Supplemental ContentCatalog PageErrata