Microsoft Access 2000/Visual Basic for Applications Fundamentals [Paperback]

Evan Callahan (Author)

Book Description

ISBN-10: 0735605920 | ISBN-13: 978-0735605923 | Publication Date: May 7, 1999

A teach-yourself guide to using the Access macro language to take control of Access. The easy-to-follow lessons include clear objectives and real-world business examples so you can learn exactly what you need to know, at your own speed. Users learn to create macros and applications for themselves and their business units. The CD offers real-world samples to support each lesson.

Editorial Reviews

Amazon.com Review

If you've stopped using Access database wizards because you've become one, you may want to look to Microsoft Access 2000 Visual Basic for Applications Fundamentals to further your programming knowledge. Written for Access 2000 application developers, or those switching from other applications, its programmed lessons offer about 15 hours of instruction on customizing events, writing and debugging code, working with new features like Web connections and interoperability, and creating your own applications from scratch.

The book's format makes learning easy, with easily digestible chunks of information, previews and reviews, appropriate illustrations, and many hands-on opportunities. All the files you'll need for learning are provided on the enclosed CD-ROM, so if you've already got Access 2000 running you can be poking around under the hood in minutes.

Even if you've never programmed before, you'll find Microsoft Access 2000 Visual Basic for Applications Fundamentals useful for getting started. With a little patience and a lot of practice, you'll whip your data into shape until it perfectly suits your needs. --Rob Lightner

About the Author

Evan Callahan is President of Callahan Software Solutions, a consultancy focusing on database and other software solutions and technical communications. Clients have included Microsoft, General Dynamics, Online Training Solutions, and a variety of accounting, real estate, and environmental firms. He is the author of "Troubleshooting Your Web Page" and "Microsoft Access Visual Basic for Applications Step by Step", published by Microsoft Press. Evan worked for Microsoft Corporation from 1989 to 1995, where he created documentation and sample applications for Microsoft Access and Visual Basic. His background includes extensive experience in database design, technical communications, web-based marketing, and management.

Product Details

• Paperback: 475 pages
• Publisher: Microsoft Press (May 7, 1999)
• Language: English
• ISBN-10: 0735605920
• ISBN-13: 978-0735605923
• Product Dimensions: 8.8 x 7.7 x 1.1 inches
• Shipping Weight: 1.8 pounds
• Average Customer Review: 3.8 out of 5 stars  See all reviews (23 customer reviews)
• Amazon Best Sellers Rank: #1,138,105 in Books (See Top 100 in Books)
  • #33 in Books > Computers & Technology > Microsoft > Applications > Office 2000

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

38 of 38 people found the following review helpful:

3.0 out of 5 stars A simplified overview of application development with VBA, December 17, 2000

By 

"cmjreview" - See all my reviews

This review is from: Microsoft Access 2000/Visual Basic for Applications Fundamentals (Paperback)

The book is an introduction to the technique used within VBA programming and shows in very general terms how and what can be achieved, by using VBA to program Access 2000. It is only useful for a limited audience since it is neither an introductory programming book, nor a VBA reference book.

If you have no previous programming experience, I recommend "Learn to program with Visual Basic 6" by John Smiley (ISBN 1902745000), which will give you a solid programming foundation to build upon. If you have programming experience, I recommend "Applications Development in Access 2000" by Baldwin and Paradice (ISBN 076007108X).

Of the so-called "Real-world Business Examples" as stated on the cover, you will find several of them to be "cold-coded". Which means the results are static and written directly into the code. One of the very first things you will be warned against in most programming courses.

The book shows an example of automated data entry, in which the application automatically writes the city, state/province and country based on the postal code entered. If you followed the book's example you would have to include every single combination in your code! Imagine the work needed to update and maintain the data, let alone write several lines of code for every postal code.

It gave me many ideas on how I could add automation to my applications, but not the knowledge to actually do it.

27 of 27 people found the following review helpful:

5.0 out of 5 stars A great book for beginners, September 6, 1999

By 

Douglas "drdoug62" (MAGEE, Montserrat) - See all my reviews
(REAL NAME)   

This review is from: Microsoft Access 2000/Visual Basic for Applications Fundamentals (Paperback)

As an individual who has only used the "automated features" of Access development, I found this book to be a great help. Yes...as other reviewers have pointed out the book is very basic. It is well written, however, and does a nice job of presenting programming without getting a newbie (such as myself) in over her or his head. Overall, this book made me more knowledgable about programming, more confident in my own efforts, and hungry to learn more. Isn't that what a good book should do?

21 of 21 people found the following review helpful:

5.0 out of 5 stars THE best book for the absolute beginner, October 29, 2000

By 

Steven Sebelius (Moorhead, MN USA) - See all my reviews
(REAL NAME)   

This review is from: Microsoft Access 2000 VBA Fundamentals/Mastering Set (Training Kit) (Paperback)

Callahan takes the newbie by the hand and reviews the basics of VBA in a very useful and easy to understand style. If you've mastered the basics of Access and want to see how they do all that cool stuff in forms and reports, this is a great place to start. BUT if you've already done a little programming, this book will waste your time! Go for Beginning Access 2000 VBA by Sussman and Smith. A true intermediate book which no one should try to read until they know some of the fundamentals and a book I keep right next to Access Developers Handbook.