Access Cookbook

Solutions to Practical User Interface & Programming Problems

Ken Getz, Paul Litwin, Andy Baron

688 pages, parution le 28/02/2002

Ajouter à une liste

Indisponible

Résumé

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.

Contents

Preface

Queries
Forms
Reports
Developing and Distributing Applications
Taming Your Printer
Managing Data
Exploring VBA in Microsoft Access
Optimizing Your Application
Making the Most of Your User Interface
Multiuser Applications
The Windows API
Using Data Access Pages
Working with SQL Server Data

Index

L'auteur - Ken Getz

Ken Getz has written several best-selling books on Microsoft Access, VBA, and Visual Basic. His Access development books have sold more than 250, 000 copies worldwide. Ken is currently working on courseware, books, and video training on .NET, and has co-recorded a 25-hour series on ASP.NET for AppDev. He is a frequent speaker at technical conferences and DevDays, and regularly writes for a number of trade publications including MSDN Newsletter and asp.netPRO. Recent books by Ken include:

L'auteur - Paul Litwin

He is one of the founders of Deep Training (www. deeptraining. com), a developer-owned training company providing training and mentoring services in Microsoft. NET. He is the Editor-in-Chief for asp.netPRO (www. aspnetpro. com), a monthly magazine for the ASP.NET programmer, the author of several programming books, and the Conference Chair for Microsoft ASP.NET Connections (www.asp-connections.com).

Caractéristiques techniques

	PAPIER
Éditeur(s)	O'Reilly
Auteur(s)	Ken Getz, Paul Litwin, Andy Baron
Parution	28/02/2002
Nb. de pages	688
Format	17,7 x 23,3
Couverture	Broché
Poids	1036g
Intérieur	Noir et Blanc
EAN13	9780596000844