Beginning Access 2002 VBA and over 2 million other books are available for Amazon Kindle . Learn more

Sign in to turn on 1-Click ordering.
Trade in Yours
For a 0.25 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading Beginning Access 2002 VBA on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Beginning Access 2002 VBA (Programmer to Programmer) [Paperback]

Robert Smith , Dave Sussman , Ian Blackburn , John Colby , Mark Horner , Martin Reid , Paul Turley , Helmut Watson
4.0 out of 5 stars  See all reviews (1 customer review)
Price: 36.99 & FREE Delivery in the UK. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock.
Dispatched from and sold by Amazon. Gift-wrap available.


Amazon Price New from Used from
Kindle Edition 30.48  
Paperback 36.99  
Trade In this Item for up to 0.25
Trade in Beginning Access 2002 VBA (Programmer to Programmer) for an Amazon Gift Card of up to 0.25, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

13 Feb 2003 0764544020 978-0764544026 Pap/Cdr
What is this book about?

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.

Product details

  • Paperback: 976 pages
  • Publisher: John Wiley & Sons; Pap/Cdr edition (13 Feb 2003)
  • Language: English
  • ISBN-10: 0764544020
  • ISBN-13: 978-0764544026
  • Product Dimensions: 23 x 18.5 x 5.5 cm
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 1,399,502 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

From the Publisher

This book is for the Access user who already has a basic knowledge of databases, and the basic objects of an Access database, and now wishes to expand on their existing knowledge of Access by learning to program in VBA. No prior knowledge of programming is necessary.

This book will also be useful to readers who have programmed a little in other languages, perhaps Visual Basic or VBScript, and need a primer into VBA and its use within Access. --This text refers to an out of print or unavailable edition of this title.

From the Back Cover

If you are using Access and want to go to the next level, you need to learn VBA. As part of Visual Basic®, VBA allows you to use some of the tremendously powerful programming techniques. In this book, we show you how VBA gives you complete control over the way your users view and interact with your Access databases.

This is the next level of Access skills, presented to you here in a clear tutorial style.

This book is a revision of the best–selling "Beginning Access 97 VBA" and "Beginning Access 2000 VBA" books, reworked to provide a rich and comprehensive guide to programming Access 2002 with VBA.

Who is this book for?

This book is designed for people with experience using Access databases, who now want to learn how to program them with VBA. No prior knowledge of programming is needed.

This book is also a useful reference and tutorial for those with some VBA experience or knowledge of other programming languages.

In this book you will learn how to:

  • Write your first VBA program – how to structure code, control programs, respond to events, and use objects
  • Create powerful Access user interfaces
  • Publish your data on the internet using the improved functionality of Access 2002
  • Debug your programs, and increase their performance and usability with robust error handling
  • Improve the performance and security of your database by using the SQL Server® Desktop Engine
  • Access your data efficiently with SQL, DAO, and ADO
  • Add support for multiple users and integrate with other Office XP™ applications

"We picked up "Beginning Access 2000 VBA" because we needed to be productive quickly. This is the one book that will take you from playing with Access to programming in Access. This book became a favorite with those that had no programming experience and with our experienced programmers too. We ended up having to buy more copies."
—Norm Yates (Network Manager, Maine Maritime Academy, USA) on the previous edition.

Inside This Book (Learn More)
First Sentence
In this chapter, we've worked our way through the process of creating part of an Access application with one aim in mind - to deliberately hit a brick wall. Read the first page
Explore More
Browse Sample Pages
Front Cover | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

5 star
3 star
2 star
1 star
4.0 out of 5 stars
4.0 out of 5 stars
Most Helpful Customer Reviews
2 of 9 people found the following review helpful
4.0 out of 5 stars A definite good buy 17 Feb 2004
Provides a detailed explanantion of VBA allowing easy entry into the world of VBA programming. A must for the user or programmer wanting greater flexibility from Access
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 3.1 out of 5 stars  8 reviews
12 of 12 people found the following review helpful
2.0 out of 5 stars Good Start, but loses it about 150 pages into the book 28 July 2003
By Spider Monkey - Published on
I knew how to do all the basics in access, Make forms, reports, basic queries, and basic access pages--so I got this book hoping to expand on the one area i was foreign to--VBA.
The first 150 pages were great, very clear and like any WROX book, they do these 'do it yourself' examples where they make you type out some code.
After roughly page 150, I began to get sucked into a quagmire of theory and less and less practical application. I went into this book hoping to answer the single question 1. What practical uses of VBA can i employ in my bio-tech work environment? As I proceeded into the book I realized that I was being lost in theory and -0- practical application. The book sure tells you what an Array is, what Functions are, Methods, operators, etc--but you know what? I sure wish there were some practical examples! good lord, there is an entire chapter on the history of DAO stuck in the middle of useful information.
This book for the most part is a massive amount of theory which is used in THEIR context, not one that one could think 'hey..that might be useful!'---on page 226 I realized I had found something that might be useful to me: a way to count how many records are in a table. Excellent. It only took 226 pages to get there. But other than that--I have 250 pages of information stored in my brain and can't think of any practical use for them! The book has a large 'ice cream' database that it uses for examples, but its really really just not very helpful.
Its method of teaching I think contains way too much theory and far too little practical training and experience. If you already know VBA or another language, sure this will be a decent review--but if you don't know any language well like me, but you DO know access fairly well minus the VB aspect, this book will leave you clueless at the entrance of chapter 5.
My favorite line? Page 228 "You should be getting a feel for the VBA code by now, so we won't explain every line that we write"
Ah, wonderful--not only am I left in the dust due to excessive amounts of theory which I have not been able to use, but now they're not going to explain every line.
Anyway, I usually like the Wrox books--like their javascript book, but this one is just terrible. If you are new and you want something to help you with the fundamental uses of VBA and its practical application, LOOK ELSEWHERE. If you want a reference book on how specific areas in VBA work--this book will be a decent refresher.
6 of 6 people found the following review helpful
5.0 out of 5 stars Excellent book to use to come up to speed 11 May 2003
By J. J. Kwashnak - Published on
A number of books out there look at Visual Basic for Applications, but this is the only one so far that focuses on the newest version of Access. I found this book to be invaluable in cutting through the clutter and getting me straight to the practical applications of VBA. The authors take you through basic programming tenants but don't dwell on them. Rather they jump into examples that are very interactive and instructive. Their examples are clear and are good starting points to expand from on your own. It is not an exhaustive reference, but you benefit from it more if you have some decent Access experience. If you don't know a database, you are not going to learn here. But in just a few weeks after reading this book, I find myself going again and again into the examples as starting points for my own projects. And it is amazing how a little bit of programming will impress the users.
There are a couple of mistakes in the book that can inhibit your code from running. In addition, the database supplied has dates of 1998 and 99, but the book uses dates in 2001, so you have to adjust your code in order to get results. And unfortunately WROX has shut down its errata area so you can't really get help with these problems. So don't assume if your code doesn't work, it is your fault. This is where the code on the CD can be helpful - if it doesn't run right it's the program, not the programmer.
Overall with a little patience and work, you can get a huge amount of help from this book.
6 of 7 people found the following review helpful
2.0 out of 5 stars Try it out, Why it didn't work? 2 Aug 2003
By A Customer - Published on
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 book should teach to beginners. This version, refering to Access 2002, is enlarged by new interesting contributions, like to specify records that should be reported using a filter form.I like the way Wrox books are formated, but this book miss revision in text and code.As a beginner in VBA, I can bear errors in text, but when neither the code on the book or on the CD runs, I am disappointed and I would advise only skilled programmers willing to find out why the code didn't work to buy the book.Until a full revision be done, beginners dont buy it. I am longing for a Microsoft Team Access 2002 VBA Step by Step, or a Beginning Access 2002 VBA by John Connell.
5 of 6 people found the following review helpful
1.0 out of 5 stars Good Start Fizzled badly! 2 Dec 2003
By Amazon Customer - Published on
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 was incomplete. There were 12 modules in this class.
I felt cheated. I don't know who to blame the School or the book writer. I want to blame the school for not using a book that has complete code/explanations.
(I have been building databases with Lotus Notes for 7 years. Access is new to me, but programming isn't, so you know my perspective.)
11 of 15 people found the following review helpful
4.0 out of 5 stars Have you guys bothered to go to their website? 2 May 2004
By A Customer - Published on
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!
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category