Access 2000 Programming for Dummies (Paperback)

~ (Author) "The purpose of this book, to put things as simply as possible, is to help Access users become Access programmers..." (more)
Key Phrases: invalid zip code, copied control, domain aggregate functions, End Sub, Year Maintain, End Property (more...)

Editorial Reviews

Product Description

If the thought of programming databases casts a dark shadow on your soul, then let this book light up your life. Whether or not you've gone through the programming wringer before, Access 2000 Programming For Dummies clues you in to simpler ways to produce dynamic databases and applications. Uncover the secrets of professional database development and let this book reveal the many added features of Access 2000 that you'll quickly be taking advantage of.

Step up to the unlimited possibilities of such Access features as SQL (Structured Query Language), OLE/DDE (Object Linking and Embedding/Dynamic Data Exchange), and wizards, and discover all your programming options. Best-selling author Rob Krumm shows you how to do everything from building your own programs by using Access 2000 to building supercharged database applications by using ActiveX controls and SQL statements. Krumm also shares his personal methods for error-free code testing, and he's included an entire CD of sample code.

Stop wondering what would make your Access programming easier and pick up Access 2000 Programming For Dummies to discover the quickest way to get your databases up to speed.

From the Back Cover

Code Samples Get You Up and Running — Fast!

The Secrets of Professional Database Development — Made Simple

Whether you're an Access novice or an experienced Access developer, Access 2000 Programming For Dummies® is all you need to give your Access database applications the power and functionality you're looking for. This indispensable resource cuts through the confusion with practical, plain-English coverage of all the newest Access 2000 capabilities and step-by-step instructions for creating and testing custom applications. The bonus CD-ROM includes hundreds of lines of useful code to help you get started! Valuable Bonus CD Includes:

• Author-generated sample code to give you an Access programming jump start

Shareware programs are fully functional, free trial versions of copyrighted programs. If you like particular programs, register with their authors for a nominal fee and receive licenses, enhanced versions, and technical support. Freeware programs are free, copyrighted games, applications, and utilities. You can copy them to as many PCs as you like — free — but they have no technical support. System Requirements: Pentium 75 or faster PC running Windows 95 or later, or Windows NT 4.0 or later; Microsoft Access 2000 installed; 32 MB RAM; CD-ROM drive, double-speed (2X) or faster.

Inside, get expert advice on how to:

• Publish your database information as easy-to-browse Web pages
• Create custom in-house applications for tables, forms, and reports
• Test your code reliably and efficiently
• Build your own dialog boxes and customized wizards
• Package and deploy your custom applications with the Package and Deployment Wizard
• Harness the power of Access features like OLE/DDE
• Use the VBA Error Handler to make code correction a snap
• Build supercharged database applications using ActiveX controls and SQL statements

See all Editorial Reviews

Product Details

• Paperback: 456 pages
• Publisher: For Dummies (July 30, 1999)
• Language: English
• ISBN-10: 0764505653
• ISBN-13: 978-0764505652
• Product Dimensions: 9.1 x 7.2 x 1.1 inches
• Shipping Weight: 1.6 pounds (View shipping rates and policies)
• Average Customer Review: 2.8 out of 5 stars  See all reviews (10 customer reviews)
• Amazon.com Sales Rank: #996,550 in Books (See Bestsellers in Books)

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

  #87 in

  Books > Computers & Internet > Microsoft > Applications > Office 2000

Customer Reviews

Most Helpful Customer Reviews

10 of 11 people found the following review helpful:

4.0 out of 5 stars Well worth it!, February 19, 2000

By	Camera addict "Love it!" (Fayettleville, NC USA) - See all my reviews

Thank goodness for the "for Dummies" folks! They took a complicated program, and made it simple(r). I come back to this book again and again. This book is not (intended) for the professional developer, but even they would likely find something useful in this book. If you are anything less than a lifelong Access programmer, and don't mind a bit of humor in your references, GET THIS BOOK! If it included all the great stuff that was in the '97 version, it would be PERFECT!

6 of 6 people found the following review helpful:

3.0 out of 5 stars Great Guide for Patient People, May 7, 2001

By	Yaakov Chase "ykvchase" (Lakewood, NJ USA) - See all my reviews

As others have previously stated, the book is full of errors. That being said, I loved the book.

The book has helped me jump from a beginner to an intermediate user of Access.

I would recommend the title only for those with a background in programming who just need to apply their knowledge to Access. If you have no knowledge of programming, forget about undrstanding this book.

I liked the author's approach to teaching the Access/VBA programming environment/language. Like *Special Edition Using Access 2000* the use of VBA is strongly recommended as apposed to using Macros. In fact both books do not delve into Macros at all. If you feel you need to learn about Macros, I strongly recommend *Running Access 2000*.

The book has very little fluff and gets you right into programming.

Perhaps the book was just perfect for me at where I was in using Access. You definitely need to know the basics of Access before reading this book.

5 of 5 people found the following review helpful:

2.0 out of 5 stars Editor Needs to Read "Editing for Dummies", April 17, 2000

By	Edward E. Austin (USA) - See all my reviews

I got a lot of use out of the Access 95 version of this book. Unfortunately, the edition for Access 2000 smells (and this is a very descriptive word to use) of being rushed to print. It is filled with errors that a thorough review should have caught, e.g., the CD doesn't load per the instructions in the book, the first data file on the CD doesn't run because of duplicate subroutine names, figures don't show what the text says they should, errors in coding examples. I think the potential buyer would be smart to wait for the second edition. Unless you already know Access well enough to fight through the errors, this book is not the one for you.