Beginning Access 2002 Vba (Programmer to Programmer)

By Robert Smith, David Sussman, Dave Sussman, et al.

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.

• Format: Paperback
• Language: English
• ISBN: 0764544020
• ISBN13: 9780764544026
• Release Date: February 2003
• Publisher: Wrox Pr Inc
• Length: 945 Pages
• Weight: 3.50 lbs.
• Dimensions: 8.8" x 1.8" x 7.0"

Customer Reviews

Best Access VBA text I've seen so far

This is about the 10th book on Access VBA that I've read, and it is by far the best. The presentation is complete, and more importantly, logical. After studying this book, I finally feel like I understand how the various features work.

Where have all the Macros gone?

After developing in Access & SQL Server for a number of years, I was always intimidated by VB development and had made a conscious effort to develop "work-arounds" for my lack of hard-coding skill. However, my current project required that I take-over and inherit someone else's work. Imagine my horror when I discovered that the person who built the database I had to maintain had done so almost entirely in VBA (and didn't document a single word of code). Where were all the macros? Where had my happy place gone? I begrudgingly accepted the fact that I would have to learn VBA in order to fix this database and support it. Although I'm not quite through the book, I felt like it was written specifically for guys like me. You must know your Access and your basic theory of database, but if syntax and coding experience is what you need, this book is great. I plan on getting the "Professional" version by Wrox as well.

Wanna be an Access geek?

This book is an intermediate reference which I would NOT recommend to the absolute beginner. Get Evan Callahan's book of nearly the same title. THEN get this book because I have found it to be an invaluable reference. Great how-to examples for every common programming task. You WILL be a true Access geek when you get through this book. For graduation, treat yourself the Developer's Handbook. You'll actually understand what's in it.