Beginning Access 2007 VBA (Paperback)

by Denise M. Gosnell (Author)
Key Phrases: corresponding label caption, local disconnected recordset, clscar class, Exit Sub, Private Sub, Exit Function (more...)

Editorial Reviews

Product Description
This book provides you with the tools and techniques you’ll need in order to build more sophisticated solutions. After walking through the features of Access 2007 VBA, you’ll learn all about object-oriented programming and ADO. You’ll then progress to advanced VBA concepts such as working with external DLLs and using automation to control external programs. Plus, two comprehensive case studies presents you with the hands-on experience in building real-world solutions using the concepts covered in the book.

From the Back Cover
If you want to take your Access databases to a more robust level of functionality, then this is the book for you. It provides the tools and techniques you'll need in order to build more sophisticated solutions. You'll find plenty of source code and fully developed sample applications to guide you along the way.

After walking through the features of Access 2007 VBA, you'll learn all about object-oriented programming and ADO. You'll then progress to advanced VBA concepts such as working with external DLLs and using automation to control external programs. And with the help of two comprehensive case studies, you'll gain hands-on experience in building real-world solutions using the concepts covered in the book.

From creating custom objects and reports programmatically to integrating Access with web services and SQL Server, this hands-on guide gets you started quickly.

What you will learn from this book

• Techniques for using ActiveX® Data Objects (ADO) to retrieve and update data

• Steps for building reports and web content from the database

• How to develop SQL Server solutions with Access projects

• Tips for fine-tuning and distributing your application

• Ways to import, link, and export data to and from external data sources

• How to send emails programmatically from your database

• How to create interactive forms, export data to HTML, enhance security, and much more

Who this book is for

This book is for the Access 2007 user who is just getting started in creating their own applications as well as the programmer who is new to Access development. 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.

See all Editorial Reviews

Product Details

• Paperback: 576 pages
• Publisher: Wrox; 1 edition (April 30, 2007)
• Language: English
• ISBN-10: 0470046848
• ISBN-13: 978-0470046845
• Product Dimensions: 9 x 8 x 1.3 inches
• Shipping Weight: 1.8 pounds (View shipping rates and policies)
• Average Customer Review: 1.0 out of 5 stars See all reviews (3 customer reviews)
• Amazon.com Sales Rank: #137,558 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #36 in	Books > Computers & Internet > Microsoft > Development > VBA
  #50 in	Books > Computers & Internet > Databases > Beginning & Introductory

Customer Reviews

Most Helpful Customer Reviews

3 of 4 people found the following review helpful:

1.0 out of 5 stars Most of the codes in the book do not work, December 19, 2008

By	openmind "zenon" (Silver Spring, MD USA) - See all my reviews

It is absolutely unforgivable for this book to be published given that most of the examples in the book do not work. The public should demand its money.

5 of 8 people found the following review helpful:

1.0 out of 5 stars Bad Code for Connecting Access to SQL, May 20, 2008

By	M. Daly "DBA" (Thousand Oaks, CA USA) - See all my reviews (REAL NAME)

I bought this book to review VBA and learn how to connect Access to Microsoft SQL Server. The code for connecting Access to SQL is wrong, and there is no trouble shooting guide. I'm ready to throw this book away, and start over.

5 of 12 people found the following review helpful:

1.0 out of 5 stars Worst Toiletpaper I've Ever Used, April 15, 2008

By	Onlydole "TDole" (Cleveland, OH) - See all my reviews

This book has begun off terribly and really just STUNK up understanding the VBA language. Of course there's useful things here and there, yet this book is done in such a stream-of-consciousness style that it lacks proper communication skills and you really have to read deeply into this book to get what the author is talking about. Only buy this book if you have a good mind, otherwise, pick a different book, or use this one on your hind-side after some super spicy tacos.