Access 97 Developer's Handbook (Sybex) (Paperback)

~ (Author), (Author), Mike Gilbert (Author) "Learning the history of Access changes..." (more)
Key Phrases: replicated design master, nonreplicated database, design master status, End Function, Private Sub, End Select (more...)

Editorial Reviews

Product Description

Here's the book the Access community relies on! Packed with tips, tricks, secrets, undocumented features, and tons of reusable source code, this indispensable guide is your ticket to developing bulletproof applications. Learn how to build more efficient databases, design better user interfaces, develop client/server applications, and plan for interoperability. The companion CD includes all examples from the book, a library of reusable code, ready-to-use subroutines and user-interface objects, and great freeware and shareware utilities.

Product Details

• Paperback: 1544 pages
• Publisher: Sybex Inc; 3rd edition (January 1997)
• Language: English
• ISBN-10: 0782119417
• ISBN-13: 978-0782119411
• Product Dimensions: 9 x 7.5 x 2.6 inches
• Shipping Weight: 5.4 pounds
• Average Customer Review: 4.7 out of 5 stars  See all reviews (67 customer reviews)
• Amazon.com Sales Rank: #700,497 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #92 in

  Books > Computers & Internet > Microsoft > Databases

Customer Reviews

Most Helpful Customer Reviews

44 of 44 people found the following review helpful:

5.0 out of 5 stars Not For Beginners; Best Book For Advanced Access Programmers, December 7, 1999

By A Customer

Short and Sweet: If you are just learning Access, this book will probably drive you insane. It is NOT for beginners who wish to learn about tables, queries, reports, etc. This book is about CODE. However, if you are an intermediate/advanced VBA programmer, this book is a MUST! (I have 2 copies - one at home and one at work.) It will teach you coding techniques that I have not seen elsewhere - and it explains them well. I have many books on Access and some have taught me excellent coding that is not covered in this book. However, if I had to choose just ONE Access book to work with, this would be it. Overall, it is simply the best.

36 of 36 people found the following review helpful:

5.0 out of 5 stars Outstanding 1500 Page Reference. I listed the Index below., August 7, 2000

By	Conrad B. Senior (Easton, CT United States) - See all my reviews (REAL NAME)

.

A great book for an intermediate or advanced database programmer.

If your goal is to get really good at MS Access this is the book for you. It is an outstanding reference for specific information on whatever topic you are interested in. If you only find one or two interesting chapters below, you may want to pass on this one.

Not the kind of book you can master overnight. Remember how to eat an Elephant-one bite at a time. This book is too complex to digest except in small bites. I strongly recommend that if you are into databases and want to master this material, that you open this book every day (or as often as possible), and highlight a new topic and put some effort into using it. A good second reference is Microsoft's "Jet Database Engine Programmer's Guide."

Index:

1. What's New in Access 97

2. The Access Event Model

3. Using VBA Class Modules

4. Database Design

5. Access SQL

6. Using Data Access Objects

7. Controlling Controls

8. Topics in Form Design and Usage

9. Topics in Form Report Design

10. Controlling Your Printer

11. Shared Office Programmability

12. Developing Multiuser Applications

13. Master Replication

14. Securing Your Application

15. Developing Client-Server Applications

16. Error Handling and Debugging

17. Application Optimization

18. Accessing DLLs and the Windows API

19. Harnessing Wizard Magic

20. Using Access as an Automation Client

21. Controlling Access as an Automation Server

22. Building Add-Ins

23. Web-Enabling Your Applications

24. Using Source Code Control

Appendix A: The Reddick VBA Naming Conventions, Ver. 4.0

Appendix B: Startup and Global Options

46 of 49 people found the following review helpful:

5.0 out of 5 stars A Must Have!, November 23, 1999

By	Robert F. Bote (Earth, Northern Hemisphere) - See all my reviews (REAL NAME)

When you are finished with those boring tutorials from other authors, buy this book! It will boost your skills to the next level by providing working solutions for you to build upon and inspire you. A 'Must Have' for anyone passionate about Access programming.

For those that say this book is not for beginners, this was my 1st Access book. Most other books are filled with boring tutorials and instructions, but this one cuts to the chase. It has the most bang for your bucks.

If you know how to use Access but want to learn how to create solutions with it, get this book!