Access 2000 VBA Handbook [Paperback]

Novalis (Author)

Book Description

Publication Date: August 5, 1999 | ISBN-10: 0782123244 | ISBN-13: 978-0782123241

Want to get the most out of Access? Then you need to know VBA.

Access 2000 is here, and never has the power of Access depended so much on VBA programming. This makes the Access 2000 VBA Handbook essential reading if you want to use Microsoft's popular database product to its full advantage. If you're an Access user, you'll benefit from step-by-step coverage of VBA basics that will simplify your work. If you're a developer, you'll master the high-end techniques introduced in the latest release-so you can stay on top of your job.

You'll learn how to:
* Create databases and projects
* View and print reports
* Run queries to find specific records
* Automate complex and time-consuming procedures
* Synchronize forms and tables
* Understand the ADO and DAO models
* Customize the user interface
* Access data using OLE DB and ODBC
* Create VBA procedures for navigating a database or project
* Use object properties and methods to write VBA procedures
* Create relationships between forms
* Execute commands using SQL statements in VBA code
* Use ActiveX controls in your VBA procedures

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.

From the Back Cover

Want to get the most out of Access? Then you need to know VBA.

Access 2000 is here, and never has the power of Access depended so much on VBA programming. This makes the Access 2000 VBA Handbook essential reading if you want to use Microsoft's popular database product to its full advantage. If you're an Access user, you'll benefit from step-by-step coverage of VBA basics that will simplify your work. If you're a developer, you'll master the high-end techniques introduced in the latest release-so you can stay on top of your job.

You'll learn how to:

• Create databases and projects
• View and print reports
• Run queries to find specific records
• Automate complex and time-consuming procedures
• Synchronize forms and tables
• Understand the ADO and DAO models
• Customize the user interface
• Access data using OLE DB and ODBC
• Create VBA procedures for navigating a database or project
• Use object properties and methods to write VBA procedures
• Create relationships between forms
• Execute commands using SQL statements in VBA code
• Use ActiveX controls in your VBA procedures

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: 8.9 x 7.4 x 2.1 inches
• Shipping Weight: 3.4 pounds
• Average Customer Review: 3.8 out of 5 stars  See all reviews (15 customer reviews)
• Amazon Best Sellers Rank: #1,068,596 in Books (See Top 100 in Books)
  • #37 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

85 of 85 people found the following review helpful:

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

By 

JRK "jkunz" (N.H.) - See all my reviews

This review is from: Access 2000 VBA Handbook (Paperback)

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" - See all my reviews

This review is from: Access 2000 VBA Handbook (Paperback)

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

This review is from: Access 2000 VBA Handbook (Paperback)

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.