Access 2007 VBA Programming for Dummies

By Joseph C. Stockman and Alan Simpson

Book Overview

If you've been using Access for a while, you're probably aware of its power and potential and itching to take advantage of both. Access 2007 VBA Programming For Dummies takes you beyond forms and reports and shows you how to use VBA to create killer Access databases and applications. This gentle introduction to VBA programming covers everything you need to get started, including: Basic programming skills and concepts Explanations of modules, procedures, objects, and arguments Access-unique programming activities, including SQL and recordsets How to use the Visual Basic editor Creating dialog boxes, lists, drop-down menus, and functions Integrating with other Office applications Ready-to-use VBA code examples to type in or copy and paste from the Web

Completely revised to reflect all changes found in Microsoft Access 2007, Access 2007 VBA Programming For Dummies gives you access to Access like you've never had it before.

• Format: Paperback
• Language: English
• ISBN: B002DMJU04
• ISBN13: 9780470046531
• Release Date: February 2007
• Publisher: For Dummies
• Length: 416 Pages
• Weight: 1.38 lbs.
• Dimensions: 0.9" x 7.3" x 9.2"

Customer Reviews

Access 2007 VBA

This book is very easy to follow for non expert programer. I recommend for those who want to start learning VBA.

Very, Very Valuable

I own several books on Access 2007 VBA programming, as any programmer would. In hindsight this has been the most valuable resource in adding actual, real world functionality to my applications. It is concice and uses lots of how-to examples. I do not normally like the "...for dummies" books, but this one is a keeper, big time.

VBA For Dummies is a Smart choice

Concise, readable, with tongue-in-cheek humor, this tome has been invaluable to my learning to code in VBA.

Excellent Book on Customizing Access

Some years ago Microsoft created a specialized programming language to allow extensions to be made to the normal modes of operation allowed in their Office suite. The language was fairly well thought out to be applicable to applications as different as word processing, spreadsheets or data bases. They called it Visual Basic for Applications shortened to VBA. It has worked remarkable well. Down theough the years there have been relatively few changes to VBA. This book is on VBA as specifically oriented to the Microsoft Access database program. But if you learn Access VBA, you are not far from knowing how to use VBA on any of the other Office components. While this is an Access book, it is specifically on VBA, it assumes that you already know about how to build a table, and about rows and columns. It also assumes that you have some familiarty with other Access features such as building queries. Access goes to a great deal of effort to avoid having to use the underlying SQL language. There are a couple of chapters on SQL for the total beginner. In the long run, you will probably want to know more. You can't design one book to do everything in about 400 pages. This "dummies" book concentrates on VBA. That's enough for one book. It does a good job on VBA. You may want to fill out your bookshelf with Access for Dummies and SQL for Dummies.