Beginning Access 2003 VBA and over one million other books are available for Amazon Kindle. Learn more
CDN$ 30.23
  • List Price: CDN$ 47.99
  • You Save: CDN$ 17.76 (37%)
Only 1 left in stock (more on the way).
Ships from and sold by Amazon.ca.
Gift-wrap available.
Quantity:1
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Beginning Access 2003 VBA Paperback – Sep 24 2004


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
CDN$ 30.23
CDN$ 4.31 CDN$ 0.83

Best Canadian Books of 2014
Stone Mattress is our #1 Canadian pick for 2014. See all

Customers Who Bought This Item Also Bought



Product Details

  • Paperback: 552 pages
  • Publisher: Wrox; 1 edition (Sept. 24 2004)
  • Language: English
  • ISBN-10: 0764556592
  • ISBN-13: 978-0764556593
  • Product Dimensions: 18.8 x 3 x 20.9 cm
  • Shipping Weight: 898 g
  • Average Customer Review: 3.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: #674,338 in Books (See Top 100 in Books)
  • See Complete Table of Contents

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 dgosnell@uspatent.com or denisegosnell@yahoo.com.

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
Concordance
Browse Sample Pages
Front Cover | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

3.0 out of 5 stars
5 star
0
4 star
0
3 star
1
2 star
0
1 star
0
See the customer review
Share your thoughts with other customers

Most helpful customer reviews

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? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 11 reviews
37 of 38 people found the following review helpful
A Good Starting Point for Access VBA Dec 15 2004
By R. Fisher - Published on Amazon.com
Format: Paperback
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
Great Beginner to Intermediate Book on Access and VBA May 23 2006
By damo74 - Published on Amazon.com
Format: Paperback
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
Good Programming practices Nov. 6 2005
By Jason Hall - Published on Amazon.com
Format: Paperback
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
Excellent book! Nov. 15 2007
By Gary L. Alford - Published on Amazon.com
Format: Paperback
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
Excellent VBA book! Sept. 30 2009
By E. H. Williams - Published on Amazon.com
Format: Paperback
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.


Feedback