Access 2000 is an important part of the Office 2000 program suite, and is available on both the Premium and Professional editions of Office 2000. Access has traditionally been the Office suite database program par excellence. It still remains that way, but with Office 2000 the face of Access is changing. This book will look at the traditional role of Access and its future uses in the Office suite.
Using VBA (Visual Basic for Applications), the user can program his or her own programs in what is essentially a subset of the Visual Basic programming languages. This is tremendously powerful, as it allows you to create great User Interfaces (forms etc), as a front end to actual database storage and manipulation. This continues to be one of the great strengths of programming Access VBA.
This book updates, expands and improves Beginning Access 97 VBA Programming, in an Office 2000 setting. All the great tutorial content, teaching people how to program with VBA in Access is there, but now majorly rewritten to take account of Office 2000.
Updated to take account of the Office 2000 facilities
Constructs a substantial example application with VBA
Database theory taught in the Wrox Beginning style
What does this book cover?
In this book, you will learn how to
Construct a substantial example application with VBA
Master the foundations of Visual Basic for Applications
Understand the concepts behind classes and objects
Understand how Automation can be used to link Office applications
Create custom objects using the Class Module feature
Debug your programs and implement robust error handling
Add support for multiple users
Publish your Access database on the Internet
Optimize and add polish to your finished database application
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.
Customer Reviews
Average Rating:
Rating: - DAO, not ADO
Although the authors were very clear in the beginning that they focused on DAO, it was not until I read 195 pages that I really understood what that meant. For other novices that may be reading this that don't know the difference between DAO and ADO: if you are making an Access (.mdb) file, get this book (because it uses DAO language); if you are making an Access Project (.adp) file, then this book does not emphasize the language you need (which is ADO).
Rating: - Good intermeditate learning tool
This is a good resource for taking the steps from standard uses of Microsoft Access into allowing the programmer flexibility using VBA. Lots of relevant examples and isa good companion with more technical resources which do not have extensive explanations. A more usable library of functions might be beneficial. Much better than a $1500 Advanced VBA course.
Rating: - Ice Cream Overload
I hate cutsie-pie programming books with cutsie-pie programming examples of cutsie-pie business applications. The ice cream example contributed to this book's ability to provide me with almost 900 pages of non-help. When I write a programming book, I will use sample apps that deal with a firearms dealership or tracking down the world's terrorists. Something more macho.
I echo the other readers' sentiments about ADO -- altough, to be fair, this was written for an audience who probably ... Read More
Rating: - How to make VBA impossibly confusing
The book seems to be written with the objective of showcasing how much the authors know about VBA without imparting any of this understanding to the reader. "Don't try to understand this now, we will explain it later" is used in almost every chapter. The concepts and syntax are poorly narrated and the text suffers from the needless and boring injection of the authors humor. If you wish to understand VBA, buy the Access 2000 VBA handbook by Susan Novalis. I learned more that I could practically ... Read More
Rating: - Only two complaints
Overall, yes it is a very good book, but I have two issues with it. 1. The authors sometimes give code examples that use functions/syntax that are not explained until several chapters later. They inevitably state something to the effect 'Don't worry about such-and-such, it will be covered in chapter whatever.' In the meantime, I still can't do anything with what I'm learning. 2. (and more significantly)By the author's own admission, they chose to focus on DAO rather than ADO. Maybe at ... Read More
- Good intermeditate learning tool
- Ice Cream Overload
- Only two complaints
