Access VBA Programming For Dummies [Paperback]

Alan Simpson (Author)

List Price:	CDN$ 41.99
Price:	CDN$ 29.13 & this item ships for FREE with Super Saver Shipping. Details
You Save:	CDN$ 12.86 (31%)
	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

In Stock.
Ships from and sold by Amazon.ca. Gift-wrap available.

Only 1 left in stock--order soon (more on the way).

Want it delivered Tuesday, May 29? Choose One-Day Shipping at checkout.

Product Details

Paperback: 408 pages
Publisher: For Dummies; 1 edition (Aug 13 2004)
Language: English
ISBN-10: 0764574116
ISBN-13: 978-0764574115
Product Dimensions: 23.4 x 18.8 x 2.1 cm
Shipping Weight: 612 g
Amazon Bestsellers Rank: #290,850 in Books (See Top 100 in Books)
- #47 in Books > Computers & Internet > Microsoft > Development > VBA

Would you like to update product info or give feedback on images?

See Complete Table of Contents

Product Description

This friendly, easy-to-use guide shows experienced Access users how to use
VBA (Visual Basic for Applications) to build Access databases and applications, but also covers programming fundamentals for nonprogrammers
Includes practical, ready-to-use VBA code examples that readers can type or copy and paste from the Web into their own database projects
Explains basic VBA skills and concepts for nonprogrammers, such as procedures, variables, and loops
Covers more advanced topics, such as record sets and other programming activities that are unique to Access programming
Author has written more than ninety computer books and has been working with databases since the early 1980s

From the Back Cover

Find out how to make your databases do your bidding

The fun and easy way® to program for Access 2003, 2002, and 2000

Even if you still think "code" means the way spies talk to each other, this book will ease you into programming before you know it. Soon you’ll be able to use VBA to make Access do things it can’t do by itself, customize your databases, and even automate mundane chores like converting numbers to words for check printing.

Discover how to:

Use the VBA editor
Work with variables, constants, and arrays
Create recordsets with SQL
Control lists with code and export data to files
Debug your code
Synchronize forms and reports

The Dummies Way

Explanations in plain English
"Get in, get out" information
Icons and other navigational aids
Tear-out cheat sheet
Top ten lists
A dash of humor and fun

See all Product Description

Inside This Book (Learn More)

First Sentence
Welcome to Access VBA Programming For Dummies. Read the first page

Explore More
Concordance

Tag this product

(What's this?)

Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items.

Customer Reviews

There are no customer reviews yet on Amazon.ca

5 star:		(0)
4 star:		(0)
3 star:		(0)
2 star:		(0)
1 star:		(0)

Share your experience with this product with others

Create your own review

Most Helpful Customer Reviews on Amazon.com ^(beta)

Amazon.com: 4.1 out of 5 stars (7 customer reviews)

42 of 44 people found the following review helpful

5.0 out of 5 stars Good Quick Way to Start Learning VBA, Oct 13 2004

By John Matlock "Gunny" - Published on Amazon.com

This review is from: Access VBA Programming For Dummies (Paperback)

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.

2 of 2 people found the following review helpful

4.0 out of 5 stars Good overall, though not perfect., Mar 23 2008

By Ryan Hagglund "Superlegoboy" - Published on Amazon.com

This review is from: Access VBA Programming For Dummies (Paperback)

"Access VBA Programming for Dummies" definitely helped me in breaking into the world of Access VBA programming. The first half is especially good at explaning things in such a way that most anyone with a basic level of understanding of Access could benefit. I did run into some problems with some of the code which I used as templates for my database project, however. The solution I found suggested that the book should be using the '&' sign for combinations rather than the '+' sign, which appears to cause problems in some situations. Thus, it seems to have some mistakes in it.

2 of 3 people found the following review helpful

3.0 out of 5 stars Takes Work to Use Example Code, Feb 23 2008

By Always Having 2 Learn Stuff "The Learner" - Published on Amazon.com

This review is from: Access VBA Programming For Dummies (Paperback)

This book has lots of code snippets, but so many of them are out of context of actual usage (within class and standard modules) that the beginner is really left to READING about things rather than trying them. This is a mistake on the part of the Dummy editors. The authors need to give the beginning Dummy the ability to play with the code. It does no good to explain controls and then not provide the code to create the form or even provide the form for the reader to play with and practice. There are some sample files included, but they are far from useful and don't even follow the book. For example, the Chapter 6 Sales Tax form isn't included. I'd look for a book that gave you more examples for practice. Failing that, it's not a BAD book; it may take another book or two used along with this book which really defeats the concept of a Dummy book. Dummys need practice, not reading material.

› Go to Amazon.com to see all 7 reviews 4.1 out of 5 stars