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.

---

Product Details

• Amazon Sales Rank: #381083 in Books
• Published on: 1999-07-16
• Original language: English
• Number of items: 1
• Binding: Paperback
• 456 pages

From the Publisher
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!

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

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

About the Author
About the Author Rob Krumm has written 47 books on computers and software since 1983, including Access 97 Programming for Windows?? For Dummies??, and has contributed to such publications as the San Francisco Chronicle, PC World, and InfoWorld. He is a Microsoft Certified Professional specializing in Microsoft Office and SQL.

---

Customer Reviews

Brilliant - no woofle and loads of worked examples
This book is a must for anyone who needs to know Acess with VBA/SQL. It assumes you are familiar with the database window, basic query design, fields and forms - but takes you through worked examples and sample code to produce solid, reliable relational databases. The CD is well thought out and the book is easy reading.

This book was written in a hurry, and it shows.
Rob Krumm's previous Access programming text, Access 97 Programming for Dummies, was an excellent book which taught me everything I needed to know to get my first Access VBA position. This book, however, is very disappointing. Even with two years' Access VBA experience behind me, I found the book very difficult to follow. The task was not made any easier by the dozens of errors, both technical and typographical. Many of these errors - for example, diagrams with incorrect captions or duplicate numbers - are glaringly obvious and should have been picked up by the proof-reader. Furthermore, many of the code samples on the accompanying CD contain syntax errors, making them unusable. If ever there were a book I wish I hadn't bought, this is it.

Access 2000 Programming for Dummies - Best yet
This is the 4th book on VBA for Access 2000 which I have bought and it is the best so far. It introduces the subject at a very basic level and most importantly makes clear the difference between the VB code itself, and the link with Access 2000. Other books I have bought simply drop you into quite lengthy modules (which often don't work when keyed in) and retrospective explanations of what they are supposed to be doing. Granted the pieces of code in the early chapters of this book throw up error messages because the names are apparently ambiguous, but simply change the names (from Basic1, Basic2, etc) to something different and they work OK.