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

Vous voulez voir cette page en français ? Cliquez ici.

Sign in to turn on 1-Click ordering.
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Start reading Beginning Access 2003 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 2003 VBA [Paperback]

Denise M. Gosnell
3.0 out of 5 stars  See all reviews (1 customer review)
List Price: CDN$ 47.99
Price: CDN$ 30.23 & FREE Shipping. Details
You Save: CDN$ 17.76 (37%)
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 (more on the way).
Ships from and sold by Gift-wrap available.
Want it delivered Tuesday, October 21? Choose One-Day Shipping at checkout.


Amazon Price New from Used from
Kindle Edition CDN $28.72  
Paperback CDN $30.23  
Join Amazon Student in Canada

Book Description

Sept. 24 2004 0764556592 978-0764556593 1
What is this book about?

Written by an Access programmer with more than 10 years of VBA experience, this is the perfect guide for Access users who are ready to take their databases to the next level, or for programmers who are new to Access or VBA.  Veteran Access developer Denise Gosnell shows readers the ins and outs of Access VBA and provides plenty of source code, and fully developed sample applications to guide you along the way.

Not only do readers learn to build “stand-alone” desktop applications, but readers also learn how to integrate Access applications with Web Services, and SQL Server.

Special Offers and Product Promotions

  • Join Amazon Student in Canada

Customers Who Bought This Item Also Bought

Product Details

Product Description

From the Back Cover

VBA–Visual Basic for Applications–is built into various Microsoft®products, including Excel, Word, and Access. VBA enables you to add features to applications that multiply their functionality, and this book will show you how to extend your Access applications with VBA.

You will begin with the programming life cycle, the Visual Basic Editor environment, and essential programming concepts. You’ll move through object-oriented programming concepts, learn to retrieve and update data with ADO, use VBA to create reports programmatically, export Access data to various Web formats, and migrate an existing Access database to an Access project that uses SQL Server®. You’ll learn advanced topics such as working with external DLLs, handling security, creating transactions, and creating custom code libraries. You will also learn how to distribute your application, and using two case studies, you will apply these concepts to a project tracking application and a customer service application. These case studies illustrate some of the more advanced and impressive features your Access applications can include, such as generating e-mails programmatically.

What you will learn from this book

  • Object-oriented programming techniques using VBA
  • How to use built-in objects and create your own
  • How to use ActiveX Data Objects (ADO) to retrieve and update data
  • Methods for creating reports and Web content from the database
  • Techniques for integrating with Office applications
  • How to build SQL Server solutions with Access projects

Who this book is for

This book is for Access users and programmers who have created databases that include tables, forms, and possibly macros. No prior experience with VBA is required.

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

About the Author

Denise Gosnell is a software attorney with Woodard, Emhardt, Moriarty, McNett & Henry LLP, a worldwide intellectual property law firm based in Indianapolis, Indiana. Denise has a unique background in both technology and law, and presently uses her deep technical and legal expertise to counsel hi-tech clients on intellectual property and technical matters.
Denise has ten years of experience creating software applications, ranging from standalone and client-server to enterprise-wide applications. Denise has worked for leading software companies such as Microsoft and EDS, and has earned a worldwide reputation for her technology expertise. She received a Bachelor of Arts degree in Computer Science – Business (summa cum laude) from Anderson University, and a Doctor of Jurisprudence degree from Indiana University School of Law in Indianapolis.
Denise has co-authored five software development books to date: Visual Basic .NET and SQL Server 2000: Building An Effective Data Layer (Wrox Press), Beginning Visual Basic.NET Databases (Wrox Press), Professional .NET Framework (Wrox Press), Professional SQL Server 2000 (Wrox Press), and MSDE Bible (IDG Books). Denise was a featured technology speaker at the Microsoft European Professional Developer’s Conference in December 2001 and has on numerous occasions assisted Microsoft’s Training and Certification group in creating new exams for their MCSD and MCSE certifications. She herself holds the MCSD certification.
Denise can be reached at or

Inside This Book (Learn More)
First Sentence
This chapter will provide an introduction to the world of Access 2003 VBA and programming in general. 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
4 star
2 star
1 star
3.0 out of 5 stars
3.0 out of 5 stars
Most helpful customer reviews
3.0 out of 5 stars Not quite what I expected. Sept. 20 2011
Format:Paperback|Verified Purchase
This book wasn't quite what I was expecting as I found it a bit too advance however I think I will still be able to use some of the code included. I'm not totally disappointed but I think the term Beginning is a bit misleading.
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 3.7 out of 5 stars  11 reviews
37 of 38 people found the following review helpful
5.0 out of 5 stars A Good Starting Point for Access VBA Dec 15 2004
By R. Fisher - Published on
I spent some time looking at various titles that covered VBA for Access. Ms.Gosnell's offering Access 2003 VBA was not the first book I purchased on the subject, but was the one that I have worked through and found to be very useful. (I took the other one back) It is arranged in a logical way and doesn't dwell on database theory and planning, although it offers some useful tools to aid in that process. It gets down to the subject quickly and leads the reader through a development sequence that includes examples that are practical and that I could put to work the next day. The text is clear and the programing examples are easy to follow and implement. They are also downloadable. She does assume that you are reasonably Access literate but doesn't get bogged down in jargon. It is a great place to start for a VBA novice.
17 of 18 people found the following review helpful
5.0 out of 5 stars Great Beginner to Intermediate Book on Access and VBA May 23 2006
By damo74 - Published on
I must highly recommend this book by Denise Gosnell. After skimming through about 20 books on the subject at a super bookstore in Melbourne, I decided this book was the best by far. I must admit, I am beginning to become slightly discouraged at the amount of books out there - especially on PHP and MySQL that I decided to bite the bullet and learn Access and Visual Basic programming.

This book gives you great examples and you CAN go to any chapter depending on your current skill level without being thrown on a tangent of fancy techniques and confusing explanations. All I want in a book, is someone to TEACH me through step by step explanations and well thought out sample exersizes. Denise has a wonderful ability to write and keep up your enthusiasm to keep perservering. I highly commend everyone give this book a go and you will see what I am talking about.

Thank you Denise, I look forward to reading some more of you work in the near future.
14 of 15 people found the following review helpful
5.0 out of 5 stars Good Programming practices Nov. 6 2005
By Jason Hall - Published on
I have been programming in VB for about 12 years and I found this 'Beginning' book VERY useful. Most books give you syntax on how to write certain 'things' but fail to give you good programming practice examples. This may not be pointed out to a novice user, but if you are familiar with any type coding and 'read' between the lines, one will notice great coding examples. Shows you examples of what to place in modules to separate business logic from the user forms from database logic, and etc. Great examples Denise. Please keep up the good work. Most books will have you type the same info in every VB module or form showing functionality without showing good separation of logic and good programming practice. I fully enjoyed this book and hope to hear more from Denise in future books....
8 of 8 people found the following review helpful
5.0 out of 5 stars Excellent book! Nov. 15 2007
By Gary L. Alford - Published on
I've never coded in VBA. I've always relied on the macros in MS Access to do everything I needed to do. However, I picked this book up to try and learn a few new things. By the time I got through chapter 6, I was writing VBA code like it was nothing.

Incredible text written so the novice user can understand it with excellent hands-on examples and exercies both provide a tremendous self educational experience for the most basic of VBA programmers (such as myself).
1 of 1 people found the following review helpful
5.0 out of 5 stars Excellent VBA book! Sept. 30 2009
By E. H. Williams - Published on
I consider myself an advanced Access user but I want to be able to use VBA to make my db's sing and dance. I've invested many dollars on VBA books (paper and electronic) to try and get my head around the process of programming VBA but they have all too quickly go deep into details that I don't consider the meat and potatoes of VBA but the garnish. Of all the books I've purchased, this is the first and only one that I've been able to actually follow past the 2nd chapter. Denise Gosnell wrote this for the person who is not a programmer but wants to learn how. I recommend this book to anyone that wants to learn how to use VBA in their Access db's.
Search Customer Reviews
Only search this product's reviews

Look for similar items by category