Access 97 Programming for Windows for Dummies (Paperback)

~ (Author) "The purpose of this book, to put things as simply as possible, is to help Access 97 users become Access 97 programmers..." (more)
Key Phrases: zip list, immediate pane, domain aggregate functions, End Sub, Private Sub, Year Maintain (more...)

Editorial Reviews

Product Description

Access 97 is finally out, and it has more than ever to offer even the most demanding database user. Find out just how much this popular program has to offer in Access 97 Programming For Windows For Dummies. This plain-English Access reference features in-depth, results-oriented coverage of all the newest Access capabilities.

If you've never programmed Access before, you'll find Access 97 Programming For Windows For Dummies not only a quick and thorough primer to get you up to speed, but also a long-term resource you'll turn to again and again as you expand the functionality, performance, and ease-of-use of the databases you program. Plus, the companion CD-ROM contains two bonus chapters and lots of sample source code used throughout the book.

With best-selling author Rob Krumm as your guide, you'll discover how to...

• Build your own programs using the rich Access Basic programming language
• Test code reliably and efficiently with Krumm's own foolproof methods
• Deploy the power of SQL (Structured Query Language) to integrate multiple database sources
• Harness the power of built-in Access features, such as OLE/DDE (Object Linking and Embedding/Dynamic Data Exchange) and Wizards that lead you step-by-step through many tasks
• Create and distribute Access 97 applications by using the Microsoft Office 97 Developer Edition Tools (ODE Tools)

From the Back Cover

Bonus CD Includes Author-Generated Sample Code!

This Is the Perfect Guide for Exploring Everything from Access 97 Programming Basics to Designing Custom Applications! The secret to powerful, productive database applications lies in using the power of programming. It's right there, built into Access, and with Access 97 Programming For Windows® For Dummies®, you can transform your tables, forms, and reports into a sleek, custom-designed application that will give your business or organization information at their fingertips. Rob Krumm has created a guide to programming that will give you the start you need to create the customer database applications you have always wanted. About the CD Valuable bonus CD includes author-generated sample code to help you program in Access and bonus chapters about debugging and Web publishing. System Requirements: PC with Windows 95; Microsoft Access 97; and a CD-ROM drive Ask for For Dummies® Books, the Fun and Easy Way to Find Out about Computers. Also look for C++ For Dummies®, 2nd Edition, the fun and easy way to discover programming with C++, and OLE For Dummies®, the fast and friendly way to make your programs easier to use.

Inside, find helpful advice on how to:

• Get your Access databases to start doing the work themselves by writing programs in VBA
• Publish your database information as easy-to-browse Web pages
• Impress all of your analyst friends with your knowledge of standard query language (SQL) — the key to database power
• Turn your Access forms and reports into powerful tools for processing and analyzing data
• Understand the basics of client/server databases
• Apply loads of practical examples that you can put to work for you today
• Build your own dialog boxes and customized wizards

See all Editorial Reviews

Product Details

• Paperback: 414 pages
• Publisher: For Dummies (March 31, 1997)
• Language: English
• ISBN-10: 1568846967
• ISBN-13: 978-1568846965
• Product Dimensions: 9 x 7.3 x 1 inches
• Shipping Weight: 1.4 pounds (View shipping rates and policies)
• Average Customer Review: 3.4 out of 5 stars  See all reviews (17 customer reviews)
• Amazon.com Sales Rank: #1,252,473 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

15 of 15 people found the following review helpful:

5.0 out of 5 stars The best beginners programming book I've ever read!, October 10, 1999

By A Customer

I bought this book only because it was the only Access VBA book I could find at the time. After starting with it, I found others. I now have a library of 6 VBA books, but this is the only one I call my "bible" for programming VBA. This book covers ALL of the basics and is easier to read then any other VBA book I have ever read. My hat is off to Rob Krumm!!!!

14 of 14 people found the following review helpful:

4.0 out of 5 stars Excellent access book, but definitely not for a dummy, April 26, 2000

By A Customer

This is among the best computer books i bought. It is a bridge between a beginner access user and a beginner access programmer. It answered a lot of my access VB questions and opened me a window of SQL. Easy to follow, welll organized and excellent CD samples. However, the book required a certain amount of knowledge of VB programming. I could not have enjoyed it without my previous experience in VB. Be carefully, real dummies!

9 of 9 people found the following review helpful:

4.0 out of 5 stars Embed HTML in VBA!, May 17, 2000

By	Spud (Bynum, NC USA) - See all my reviews

I bought this book last fall and I still keep referring to it. I picked up something from almost every chapter that I could use in my databases. It doesn't waste time covering general Access features. The Dummies title is misleading, because you have to have a fair amount of Access knowledge to be able to get through it. But you won't need any programming knowledge. (If you do, try VBA for Dummies)

It gives a good description of what a recordset property is and how it works with bookmarks. It tells how to pass parameters to procedures, the difference between seek and find, and it's got a little bit about ActiveX.

The book comes with a CD that has two extra chapters on it. The "Publishing Data for the Web" chapter has allowed me to set up forms that create web pages automatically when the forms are closed. I can keep my web data current without having to remember to do it. It showed me how to embed the HTML code directly into VBA code. It even describes how to manage a web site from inside Access. The second chapter has more debugging info and ways to document your database.