Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Anybody can read Kindle books even without a Kindle device-with the FREE Kindle app for smartphones and tablets.
Access 2007 VBA Programming For Dummies

Access 2007 VBA Programming For Dummies [Kindle Edition]

Joseph C. Stockman , Alan Simpson
3.8 out of 5 stars  See all reviews (6 customer reviews)

Print List Price: 16.99
Kindle Price: 10.40 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: 6.59 (39%)
* Unlike print books, digital books are subject to VAT.


Amazon Price New from Used from
Kindle Edition 10.40  
Paperback 11.55  
Kid's and Teen books from £0.99 on Kindle
Browse our selection of top children's and teen title in our one week sale, with top titles from only £0.99.Browse the sale here

Customers Who Bought This Item Also Bought

Product Description

Product Description

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.

From the Back Cover

Customize combo and list boxes Go beyond forms and reports and build custom database solutions Need to know how VBA works in Access 2007? This plain–English guide introduces you to the fundamentals of VBA programming, helping you get the most out of your Access apps and giving you practical code examples for immediate use in your databases. You′ll see how to control Access through VBA and apply powerful real–world VBA solutions. Discover how to Create simple VBA programs Program Access forms Manage Access tables with SQL and recordsets Test and debug your code Use VBA with multiple databases Integrate with other Office apps

Product details

  • Format: Kindle Edition
  • File Size: 15447 KB
  • Print Length: 412 pages
  • Page Numbers Source ISBN: 0470046538
  • Publisher: For Dummies; 1 edition (21 May 2007)
  • Sold by: Amazon Media EU S. r.l.
  • Language: English
  • ASIN: B004OC07C6
  • Text-to-Speech: Enabled
  • X-Ray:
  • Average Customer Review: 3.8 out of 5 stars  See all reviews (6 customer reviews)
  • Amazon Bestsellers Rank: #165,998 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Author

Discover books, learn about writers, and more.

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

3.8 out of 5 stars
3.8 out of 5 stars
Most Helpful Customer Reviews
3 of 3 people found the following review helpful
4.0 out of 5 stars Access 2007 VBA Progamming 13 July 2010
I found this book did what it said "On the tin". It allows you to write your own programmes in VBA or, in my case, use the provided examples and edit them to acheive what you need.
Comment | 
Was this review helpful to you?
9 of 10 people found the following review helpful
5.0 out of 5 stars An excellent reference 16 July 2009
I have been programming in VBA in its various forms for many years and bought this book to use as a reference rather than a beginners guide. I was well pleased with it as it was easy to find the appropriate sections and allowed me to identify changes from an earlier version. It would also be excellent as a beginners book as it progresses in easy stages with no need for much previous knowledge, it does assume computer and microsoft knowledge at a fairly basic level however I do not think that anyone is going to embark on or even know VBA exists without this basic knowledge.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
3.0 out of 5 stars VBA Education 3 Dec 2011
This book certainly assumes you know quite a bit about Access so not sure it's that great for anyone who doesn't have that basic knowledge AND some understanding of Logic and programming concepts. In some ways I found it too basic and in others not comprehensive enough in terms of the explanations. The samples help but still leave a lot of unanswered questions in my mind. I think there's not enough explanation of how to really use the VBA programming window(s) and their associated help facilities, which really are the key to learning the syntax and keywords. The examples used are not particularly relevant in my opinion and I could think of better sample solutions. However, it does give a good "broad brush" overview and if you persevere you will have the basics to move forward.

I wish there was a reference to an associated online web-site where you could ask for specific help, i.e. ask specific questions on items you don't understand. Perhaps my expectations were higher and my previous career experience with some of the historic programming languages created a mind set that was not completely "in tune" with the authors thought process.

Would I recommend it, yes, but with reservations. It really depends where you are starting from.
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know

Popular Highlights

 (What's this?)
Although a Sub procedure can accept incoming data through its arguments, it cant return any data to Access or other VBA procedures. A Function procedure, on the other hand, can accept incoming data and return a value. &quote;
Highlighted by 7 Kindle users
Named arguments provide an alternative to putting arguments in a specific order. &quote;
Highlighted by 6 Kindle users
A VBA procedure is a series of instructions written in VBA code that tells an application (like Access) exactly how to perform a specific task. &quote;
Highlighted by 5 Kindle users

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category