Trade in Yours
For a £0.25 Gift Card
Trade in
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Tell the Publisher!
I’d like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Access 2000 Developer's Handbook: Desktop Edition v.1: Desktop Edition Vol 1 [Paperback]

Paul Litwin , Ken Getz , Mike Gilbert
4.5 out of 5 stars  See all reviews (8 customer reviews)

Available from these sellers.


Trade In this Item for up to £0.25
Trade in Access 2000 Developer's Handbook: Desktop Edition v.1: Desktop Edition Vol 1 for an Amazon.co.uk gift card of up to £0.25, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Special Offer until June 30, 2013: Receive an additional £5 promotional Gift Card, when you trade-in at least £10 worth of books. Learn more

Book Description

19 Aug 1999 0782123708 978-0782123708 Volume 1: Desktop Edition
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

  • Paperback: 1664 pages
  • Publisher: John Wiley & Sons; Volume 1: Desktop Edition edition (19 Aug 1999)
  • Language: English
  • ISBN-10: 0782123708
  • ISBN-13: 978-0782123708
  • Product Dimensions: 23 x 19 x 6.9 cm
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (8 customer reviews)
  • Amazon Bestsellers Rank: 458,805 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

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.

Inside This Book (Learn More)
First Sentence
Chances are, if you're reading this book, you've already decided that Microsoft Access 2000 (we'll refer to it hereafter as Access 2000) is a worthy platform for your development endeavors. Read the first page
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

4.5 out of 5 stars
4.5 out of 5 stars
Most Helpful Customer Reviews
6 of 6 people found the following review helpful
By A Customer
Format:Paperback|Amazon Verified Purchase
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.

Comment | 
Was this review helpful to you?
4 of 4 people found the following review helpful
4.0 out of 5 stars Not for the fainthearted 3 July 2004
Format:Paperback
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.

Comment | 
Was this review helpful to you?
4 of 4 people found the following review helpful
5.0 out of 5 stars Simply in a class of its own 14 May 2000
By A Customer
Format:Paperback
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!
Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
By A Customer
Format:Paperback
This is excellent, well organised and very informative. Unfortunately it does not cover ADP's too well - this is promised in volume 2. Otherwise this book will save you much time - especially considering the distinctly dodgy online help available within Access 2000.
Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
3.0 out of 5 stars Thick. A lot of paper, but substance? 14 Dec 1999
By A Customer
Format:Paperback
This book is very heavy. In places it explains things well, however the index is a bit thin, and the organization of the book unfathomable - I have (so far) failed to find the thread! Topics are started and seem to be resumed 400 pages later. As a reference to ACCESS it fails.

It may not be a book on SQL, but SQL is fundamental to Access - this book introduces you to SQL, but you are never on first name terms.

It may be that I am the wrong buyer - I have a lot of programming experience, but have not used ACCESS before. The book does not tell you how to manipulate access aside programming (it does have a lot of nooks and crannies!), and assumes (perhaps rightly) that you will program almost everything, and making less use of the wizard driven built in functions in access (rather tedious). Nonetheless exactly what various properties (eg in forms and queries) do is important.

I still can't tell DAO from ADO. ACCESS functions on a number of different levels - with this book, you are not quite clear how much they overlap, or where you are.

It just doesn't meld together despite its >1500 pages.

Finally for such a big book it would be nice to have an online version, rather than just a few examples (and sales pitches for shareware) on the CD. Perhaps if you've the time to read all 1500 pages and work all the examples it is great?

Disappointed but maybe its me (hence 3* rather than less). Alternatively if you know ACCESS well(and don't need the book) this may be a great buy.

Sorry.

Comment | 
Was this review helpful to you?
4 of 5 people found the following review helpful
5.0 out of 5 stars The standard 25 Jan 2000
By A Customer
Format:Paperback
If you develop application ivolving Access (97 or 2000) you must own this book. That's it.
Comment | 
Was this review helpful to you?
By A Customer
Format:Paperback
I purchased this book on the recommendation of our local Access SIG group leader. He spoke highly of authors' Access 97 Handbook. I am new to Access and VBA. I was anxious to come up to speed quickly. I first purchased "Sams Teach Yourself Microsoft Access 2000 in 21 days" by Paul Cassel and Pamela Palmer. That book put me on the right path. After almost completing that book, I started tackling some complex automation projects. This book accelerated my learning to an amazing degree. This handbook explains the ADO Model, the Object Model and Automation very clearly and logically. The examples are excellent and the companion CD is really useful.

The only topic this book does not cover is the DDE (Dynamic Data Exchange). On the other hand, after reading the book, I realized that the DDE is not necessary for automation since the Object Model is more powerful and efficient.

I recommend this book to anyone who has the need to use VBA for automation and for extending the standard capability of Access 2000.

Comment | 
Was this review helpful to you?
By A Customer
Format:Paperback
Absolutely the must-have book for every serious Access developer.

This book is what a professional Access developer is looking for, and much more.

Don't look any further, buy this book.

In dept coverage of the real development stuff. Drills down into the utmost detail, in particular with reports-design, controling the printer.

Excelent advanced SQL teaching, plus the new ANSI-94 SQL.

My conclusion: This book is amazing

Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Listmania!

Create a Listmania! list

Look for similar items by category


Feedback