Access 2000 VBA Handbook (Paperback)

~ (Author) "The Database Wizard can help you to create database applications for a number of different business and personal scenarios..." (more)
Key Phrases: Expense Reports, End Function, Main Switchboard (more...)

Editorial Reviews

Amazon.com Review

Database front ends are the bread and butter of most Visual Basic programmers, so it pays to know how to build them well (and as efficiently as possible). Access 2000 VBA Handbook does a good job of explaining the power of Visual Basic for Applications (VBA) and how it can be used to create custom interfaces on top of Access 2000 databases. This is a well-written, comprehensively researched book well-suited to aspiring Access developers. It's also a fine resource for programmers who use older versions of Access and want to learn more about the newest version, particularly the new DAO-centric approach to transactions.

The writing style will appeal to those with a modicum of familiarity in general programming concepts and procedures--the sort of knowledge one can gain in a university-level survey programming course. It documents core VBA as it applies to Access but concentrates mostly on explaining the tools available to solve various problems. The book doesn't go overboard with code listings--a greater number of explicitly stated solutions to problems would have made it better. Instead, it presents long, annotated lists of options and parameters. It also documents lots of step-by-step procedures involving Access's graphical user interface. --David Wall

Topics covered: The Database Wizard, the VBA programming environment, basic VBA data and control structures, form design, record manipulation, and Structured Query Language (SQL). Object model coverage includes the Access object model, Data Access Objects (DAO) and ActiveX Data Objects (ADO), with data-access emphasis on DAO.

Product Description

Improve your database productivity with this task-oriented guide to using macro and VBA programming to create custom database applications. Building on your basic knowledge of Access, this book takes you to the next level. Master all the skills you'll need to automate complex processes and to design and deliver applications that meet users' exacting requirements--even if you have no prior programming experience. The companion CD contains code from the book for your reuse and sample databases for hands-on experience.

See all Editorial Reviews

Product Details

• Paperback: 845 pages
• Publisher: Sybex (August 5, 1999)
• Language: English
• ISBN-10: 0782123244
• ISBN-13: 978-0782123241
• Product Dimensions: 9 x 7.6 x 2 inches
• Shipping Weight: 3.1 pounds (View shipping rates and policies)
• Average Customer Review: 3.6 out of 5 stars  See all reviews (13 customer reviews)
• Amazon.com Sales Rank: #543,199 in Books (See Bestsellers in Books)

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

  #31 in	Books > Computers & Internet > Microsoft > Applications > Office 2000
  #61 in	Books > Computers & Internet > Programming > Languages & Tools > Basic
  #93 in	Books > Computers & Internet > Microsoft > Development > VBA

Customer Reviews

Most Helpful Customer Reviews

86 of 86 people found the following review helpful:

4.0 out of 5 stars Using Access with VBA, not Access, March 5, 2001

By	JRK "jkunzvt" (VERMONT) - See all my reviews

This book is intended for VBA beginners, not Access beginners. Make sure you are comfortable using Access (User level suggested Intermediate/Advanced) before thinking about this book. When you want to take your Access databases to the next level with some programming (for example, automating the process of running 4 update queries with all alerts turned off), then it's time to grab this book. Readers with some programming background will find this book much easier than those without, but if you have patience and time anyone can learn from this book. If you have VB/VBA knowledge already, including some ADO/DAO basics, you might find this book too boring or easy. Jump up to Access 2000 Developer's Handbook Set, ISBN 0782123716.

26 of 26 people found the following review helpful:

3.0 out of 5 stars lots of information - but horribly presented, April 23, 2002

By	"tomh2099" (Somerville, NJ USA) - See all my reviews

This book has frustrated me to no end. It jumps from subject to subject with no warning. For example the book explains a little bit of the architecture, then says that an "Access Project" has a different architecture. I thought I was working on an Access Project, oops, much later that I discovered that, an Access Application is not the same thing as an Access Project. Thanks for telling me. And for a good portion of the book, there is no sample code. You learn things by chance, and heaven help you if you try to find something in the index (for example, "subform" is not in the index). Did I learn? Yes. But only because I was taking over a project that had already been written, so the book supplemented the code I was deciphering. Admittedly, part of the problem is in Access itself - too much behind the scenes processing which requires no code. Access also has a number of different interfaces ... I had hoped this book would explain when to use which one and why. No such luck.

37 of 41 people found the following review helpful:

3.0 out of 5 stars Wondering why this book is so complicated?, April 24, 2000

By	Darko Gereš - See all my reviews

For a some time I've been looking for a book which will be simple enough to help me start programing with VBA for Aplication. When I found this un my local bookstore, I hoped it will be the one. Well it's a pretty good book. It cover most of the topic's needed for programing in VBA. But it does'nt have one thing which is most inportant (in my opinion). Like a most of other books on this subjects, this one explain items from VBA for aplication in randomly select order. So it does'nt show you how to start building an aplication from very begining, and it does'nt help you if somethings go wrong in your leyerning from your book. I hope in future this writer will give more space to explanations about possible mistake that one can make in programming.