Product Description

Design, build, and refine Access applications that meet smaller organizations′ special needs.

The latest from internationally recognized Access authorities Getz, Litwin, and Gilbert, the Access 2000 Developer′s Handbook, Volume 1: Desktop Edition offers complete coverage of every aspect of building Access applications for single users and small workgroups, including the advanced topics you′ve got to master to take your work––and your career––to the next level. Inside, you′ll profit from scores of practical examples, carefully devised by the authors to illustrate effective, elegant solutions to real–world challenges.

Coverage includes:
∗ Familiarizing yourself with Access 2000
∗ Understanding the Access event model
∗ Using VBA class modules
∗ Applying sound database design principles
∗ Using Access SQL
∗ Using ActiveX Data Objects (ADO)
∗ Controlling controls
∗ Designing effective forms and reports
∗ Controlling your printer
∗ Taking advantage of shared Office programmability
∗ Using Access as an automation client and server
∗ Debugging and handling errors
∗ Optimizing your application
∗ Accessing DLLs and the Windows API
∗ Adding professional features employed by the Access Wizards
∗ Building add–ins, both MDA files and COM Add–Ins
∗ Using Reddick VBA naming conventions
∗ Managing startup and global options
∗ Using DAO

Product Details

• Amazon Sales Rank: #487028 in Books
• Published on: 1999-08-19
• Original language: English
• Number of items: 1
• Binding: Paperback
• 1664 pages

From the Back Cover
Design, build, and refine Access applications that meet smaller organizations′ special needs.

The latest from internationally recognized Access authorities Getz, Litwin, and Gilbert, the Access 2000 Developer′s Handbook, Volume 1: Desktop Edition offers complete coverage of every aspect of building Access applications for single users and small workgroups, including the advanced topics you′ve got to master to take your work––and your career––to the next level. Inside, you′ll profit from scores of practical examples, carefully devised by the authors to illustrate effective, elegant solutions to real–world challenges.

Coverage includes:

• Familiarizing yourself with Access 2000
• Understanding the Access event model
• Using VBA class modules
• Applying sound database design principles
• Using Access SQL
• Using ActiveX Data Objects (ADO)
• Controlling controls
• Designing effective forms and reports
• Controlling your printer
• Taking advantage of shared Office programmability
• Using Access as an automation client and server
• Debugging and handling errors
• Optimizing your application
• Accessing DLLs and the Windows API
• Adding professional features employed by the Access Wizards
• Building add–ins, both MDA files and COM Add–Ins
• Using Reddick VBA naming conventions
• Managing startup and global options
• Using DAO

About the Author
Paul Litwin, Ken Getz, and Mike Gilbert are co–authors of Access 2, Access 95 and Access 97 Developer′s Handbooks from Sybex. Gilbert and Getz co–authored VBA Developer′s Handbook also from Sybex. Litwin and Getz are co– and sole authors on related other books from other publishers. All three are MVPs on Microsoft′s Access CompuServe Forum, and frequent contributors to Access, VBA, and Office Advisor Magazines.

Customer Reviews

An excellent resource for the experience access developer
If you already know your way around Access and are looking for something to expand your knowledge then this (and volume 2) are the books to have. Detailed and comprehensive, even as a relatively experienced Access developer I learned something the first time I dipped in it.

It's not perfect - the index seems a little scant and in my view the structure seems to be a bit hit and miss - but if you're serious about developing applications in Access there is no better book that I've found.

A note of caution though, this book isn't for those with no experience of Access, Database Design or Visual Basic.

Not for the fainthearted
After readomg sp,e reviews on many books about Access I wanted a book that didnt treat me like a "dummy" and this book certainly devlivers.

I am an intermediate user of ACCESS 2000 and wanted a book that i could use aa reference in the workplace, and already have gained some insight into speeding things up, as well as finally grasping the hows and whys it does things.

This book is certainly not a "how to use Access" as the majority of the book is hard coding, more in VBA and SQL which was ideal for me becuase i wanted to have complete control on things.

If you are after a "how do i do this in ACCESS" kind of book this is not really for you. However if you are a professional and want to learn some new things to help you develop your own solutions this book is ideal. The level of detail is astounding.

In all honestly when this book arrived i spent 20 mins skimming through and though "oh my God" and didnt touch it again for 3 days. However as teh title suggests, it is a Desktop Edition and sure enough come the time 3 days later when I wanted to do something at work, i looked it up in the index and hey presto there was something for me - and all I had to do is look!!

Fantastic book, though like i said alot of the code you will have to be able to understand so it might be worth investing in a VBA book of somesort.

Excellent for hardcore developers, not for people who no nothing or dont quite know VBA/SQL statements.

Simply in a class of its own
Having used Access for some years at a basic to intermediate level, this book gave me the kickstart to move on to the next stage. Quite simply, Excellent!