Beginning Access 2000 VBA (Paperback)

~ (Author), Dave Sussman (Author) "You can achieve a great deal in Access without ever knowing anything about programming at all..." (more)
Key Phrases: frmcompany form, tblsales table, intelligent navigation buttons, Private Sub, Visual Basic, Jane's Diner (more...)

Editorial Reviews

Product Description

Access 2000 is the fifth version of the hugely successful desktop database from Microsoft. When it was first released in 1992, Access immediately gained praise for its ease of use and power. Each release of Access has added features and increased usability, and with Access 2000 we now have a unified development environment for the whole of the Office 2000 suite of applications. Visual Basic for Applications (VBA) is the programming language that gives Access its real power, allowing you to automate complex tasks and create applications with more scope and flexibility than is possible with its default forms and macros. VBA has a simple syntax allowing even complete novices to learn programming with very little effort, and this book illustrates the concepts with plenty of examples and exercises.

Who is this book for?

This book is for users who already have a basic knowledge of databases and the basic Access objects, such as tables, queries, forms and reports. You now want to expand on your existing knowledge of Access and wish to learn how to program in VBA. You don't need any prior programming experience, although a basic knowledge of Access macros would be helpful.

What does this book cover?

• Constructing a substantial example application with VBA
• Mastering the foundations of Visual Basic for Applications
• Understanding the concepts behind classes and objects
• How Automation can be used to link Office applications
• Creating custom objects using the Class Module feature
• How to debug your programs and implement robust error handling
• Adding support for multiple users
• Publishing your Access database on the Internet
• How to optimize and add polish to your finished database application

From the Publisher

This book is for the Access user who already has a knowledge of databases and the basic objects of an Access database such as tables, queries, forms and reports, but now wants to learn how to program with VBA. You don't need any prior programming experience, although a basic knowledge of Access macros would be helpful. --This text refers to an out of print or unavailable edition of this title.

See all Editorial Reviews

Product Details

• Paperback: 896 pages
• Publisher: Wrox (April 3, 2000)
• Language: English
• ISBN-10: 0764543830
• ISBN-13: 978-0764543838
• Product Dimensions: 8.7 x 7.2 x 2.1 inches
• Shipping Weight: 2.8 pounds (View shipping rates and policies)
• Average Customer Review: 3.9 out of 5 stars  See all reviews (30 customer reviews)
• Amazon.com Sales Rank: #381,740 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #24 in	Books > Computers & Internet > Microsoft > Applications > Office 2000
  #62 in	Books > Computers & Internet > Databases > Beginning & Introductory
  #72 in	Books > Computers & Internet > Microsoft > Development > VBA

Customer Reviews

Most Helpful Customer Reviews

33 of 34 people found the following review helpful:

4.0 out of 5 stars Excellent, excellent tutorial. (Did I mention excellent?), June 18, 2000

By	Daniel Lamarche "D. Lamarche" (Melbourne, VIC, Australia) - See all my reviews (REAL NAME)

This review is from: Beginning Access 2000 VBA (with CD-ROM) (Paperback)

I have about 12 books on Access development in my bookcase and this is one that I can't stop reading. Why? Because it's done like I think a good beginners book should be. Many books contain a lot of babbling and not enough 'good' examples. This one is different.

Hundreds of useful examples, well explained, waiting to be typed (or used from the CD) can be found. The book explains very well their choice of using DAO over ADO, I thing it's a very good idea. As far as I'm concerned, I thing it's one of the best solid introduction to Access VBA you can find. As an Access teacher, I found some very good concepts and approaches in their projects.

You're very familiar with Access interface? Was exposed to VBA a little? Willing to bring your apps to new heights? Want to see some examples? Then this book IS for you. The pace is reasonable, the writing is great, there are easy to more complex concepts explained. As the title implies, this is a beginning VBA book, not a developer's handbook. But don't be misled by the word 'Beginning', there is serious stuff in there like Class objects, networking issues and approaches to solving good problems.

You're tired of books saying, you could do this or do that without explaining how? This book is not like that. Finally, a book that left out that Northwind omnipresent database and came up with something different!

17 of 17 people found the following review helpful:

3.0 out of 5 stars It's Good But Not For Absolute Beginners, March 7, 2003

By A Customer

This review is from: Beginning Access 2000 VBA (with CD-ROM) (Paperback)

This is a solid book, nicely written, and the authors have obviously put a lot of thought and good effort into it. However, in it's introduction, the authors advise that you don't really need to know anything about programming in order to understand the book. In my experience that's not correct. While a beginner can understand parts of the book, you soon get the feeling that you are in over your head. It gets into fairly complex code quite quickly. It would be a great book if you are taking a class or have a teacher to explain the parts that need clarification. But for a beginner like myself trying to learn VBA on my own, it's too much too soon. Another thing that this book (or any book) could do to help you learn is provide a lot of problems at the end of each chapter for you to try and apply what you learned, sort of the way we learned algebra in high school.

Evan Callahan's Book, Step By Step Microsoft Access VBA is a much more basic beginner's book. It takes you by the hand and gets you writing code quickly. It does not take you very far into VBA, but does get you going.

The next book I'd recommend is VBA Handbook by Susan Novalis. It's a much more gentle intro than is Sussman's book. In fact, after you learn Novalis' book you will probably be ready for Sussman's book.

17 of 17 people found the following review helpful:

2.0 out of 5 stars Definitely NOT recommended for the beginner, February 16, 2002

By A Customer

This review is from: Beginning Access 2000 VBA (with CD-ROM) (Paperback)

I bougth this book and discovered that it was not for someone like me just learning Access VBA.

In fact I had to buy Access 2000 VBA Handbook by Susann Novalis (ISBN 0782123244) simply this book did not cut is for me as a beginner. If you are starting out and know little or nothing about Access VBA DO NOT BUY THIS BOOK. Instead I recommend Novalis.

With Novalis, you will learn to create forms, print to list box, sort records, create recordset, simple SQL and much more that can get you started on creating greate Access databases using VBA.