Access 2002 is the core database application within the Office XP suite. Using VBA (Visual Basic for Applications), the user can create his or her own programs in what is essentially a subset of the Visual Basic programming language.
Using VBA with Access is a tremendously powerful technique, as it allows you to create great user interfaces (like forms or reports) as a front end to actual data storage and manipulation within the database itself.
What does this book cover?
This book is a revision of the best-selling Beginning Access 2000 VBA, reworked to provide a rich tutorial to programming Access 2002 with VBA. New material covers the enhanced options in Access 2002 for publishing data to the Web, handling XML, integrating with SQL Server Desktop Engine, and so on.
Who is this book for?
This book is for the Access user who already has a knowledge of databases and the basic objects of an Access database, and who now wants to learn how to program with VBA. No prior knowledge of programming is required.
Customer Reviews
Average Rating:
Rating: - Missing Files Make A Potentially Good Book Mediocre
I was looking for a book that had theory and enough exercises to improve my fluency in use of VBA. This book has the theory but, due to an obviously extremely flawed production process, fails to include the chapter by chapter sample files on its CD that the authors claim are included. This severely constrains its overall utility. Also, as another reviewer has indicated, the authors sometimes play fast and loose with some of their explanations. I could probably overlook this, if the sample files ... Read More
Rating: - Have you guys bothered to go to their website?
All wrox books ship without CDs. You are supposed to download the code from their website.
Shame on you who can't be bothered to visit their site even once!
Rating: - Content is great- CD is lacking
The book itself is GREAT! Lots of great concepts and tips, etc. The only problem is the book ships with a CD that does not have all of the chapter examples! On page 29 it states they provide a file for each chapter, specifically for the work they have done in that chapter. None of the chapter by chapter examples are on the disk. You have to email the company to get them to send you the disk.
Rating: - Good Start Fizzled badly!
I had to use this book for a class on "Database Programming". I took the class to (1) get credit for taking a class and (2) to get more help with Access and VBA for work. This book started out excellent, good explaintion very informative and after about chapter 6 it fizzles, with inconsistancies lack of all the information. Code wasn't included on the cd. They could have shown how to build a form that was needed for the chapter. Everyone in our class was given 100 pts for two modules because the book ... Read More
Rating: - Try it out, Why it didn't work?
It is not for beginners. It should be called "An Introduction to Access VBA", because it is very theoretical, and the authors seem not have the knowledge of the difficulties the beginners in programming are faced, when trying to run the code by simply copying it from the text.For example, in the ulterior version refering to Access 97, if you dont have the cursor on the name of the procedure or function you wont get it running when the run button or run menu is clicked. That is an information that a beginning ... Read More