Access VBA Programming [Paperback]

Charles Brown (Author), Ron Petrusha (Author)

Book Description

ISBN-10: 0072231971 | ISBN-13: 978-0072231977 | Publication Date: August 23, 2004 | Edition: 1

Take a look at this great application of VBA and learn to expand the capabilities of Access with simple programming. Author Charles E. Brown shows you step-by-step how to create your own code, work with Object-Oriented Programming, and more. Plus, discover and utilize key programming concepts that can be applied beyond VBA.

Editorial Reviews

From the Back Cover

Harness the full power of Access using VBA programming

Expand the range of your Access proficiency with VBA programming using this guide designed specifically for Access power users. With the provided online sample database, learn VBA fundamentals, then discover how to connect Access and VBA through ActiveX Data Objects (ADO), and how to extract, manipulate, and retrieve data using SQL queries. Benefit from expert advice on error handling, get the most out of forms, reports, and tables, and save time with VBA coding and debugging tips. From the basics to advanced techniques, this comprehensive treatment provides you with the information you need to produce the exact results you desire.

• Call up forms and reports using VBA
• Build dynamic Data Access Pages
• Program and assign record data sources to forms and reports
• Create objects and learn how to reference them
• Learn the fundamentals of SQL and how to use it in VBA
• Understand the ADO object model and its components
• Use modules, declare variables, build looping and decision structures, use procedures and functions, and build arrays
• Generate recordsets based on dynamic criteria
• Use Office menus and toolbars to invoke your code
• Develop applications that multiple users can run at the same time

ABOUT THE AUTHORS: Charles E. Brown has taught VBA programming to many beginner programmers, and has produced VBA code for Swiss Bank Corporation, the US government, NASA, and Price Waterhouse Accounting. Ron Petrusha is a computer book author and editor with over 25 years of experience in developing computer applications.

About the Author

Charles E. Brown (New Milford, NJ) has been a computer trainer and consultant for nearly 21 years. In the process he has developed and delivered training for many Fortune 500 companies including Exxon, Johnson & Johnson, RJR Reynolds/Nabisco, and the US Government. He has trained such diverse topics as Microsoft environment and the Microsoft .NET environment. In addition, he delivers programming training in Java for Learning Tree International. He has taught VBA and has done VBA programming for Swiss Bank Corporation, the US Government, NASA, and Price Waterhouse Accounting.

Product Details

• Paperback: 464 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (August 23, 2004)
• Language: English
• ISBN-10: 0072231971
• ISBN-13: 978-0072231977
• Product Dimensions: 9.1 x 7.3 x 1 inches
• Shipping Weight: 1.7 pounds (View shipping rates and policies)
• Average Customer Review: 3.7 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #768,912 in Books (See Top 100 in Books)

More About the Author

I am an author with several books available about internet design and programming. My books are:

Beginning Dreamweaver MX 2004
Fireworks MX 2004 - Zero to Hero

I was also a contributor to The Marcromedia Studio MX Bible.

In addition, I am a classical pianist, guitarist, and organist.

Customer Reviews

Most Helpful Customer Reviews

21 of 23 people found the following review helpful:

3.0 out of 5 stars For beginning (not experienced) programmers, November 26, 2004

By 

Christopher Rettig (Cincinnati, OH United States) - See all my reviews
(REAL NAME)   

This review is from: Access VBA Programming (Paperback)

The 1st half gives you a quick and sparce overview of what you can do without VBA. It spends lots of time interducing the reader to database design, queries, forms, and tables. If you have any idea what any of these are, you will get nothing out of the 1st half of the book.

The 2nd half introduces the reader to not just VBA but primarily to the concept of programming. I would say it is about 40% general programming (procedures, variables, scope, etc.), 30% idle banter, 20% useless graphics, and 10% Access specific code.

If you have any programming experience, you'll be wasting your time searching for the hidden nuggets in this book. If you are new to Access and to programming, this book is a good into.

5 of 5 people found the following review helpful:

4.0 out of 5 stars A Good Introduction, March 11, 2006

By 

John A Lee III "jal3" (San Antonio, TX) - See all my reviews
(REAL NAME)   

This review is from: Access VBA Programming (Paperback)

My programming skills are minor and predate Windows as the main operating system in use. I know a few basic principles but have never been a "programmer". This book will not make me one but it goes a long way towards giving me the skills to reacquire some basic competency.

The text sets out some basic ideas about data structures and ways to manipulate them. These are general principles and have little to do with programming Microsoft Access but they are needed skills. Then the real lessons begin as the principles are used to learn how to manipulate Access objects and the Access environment. It is done is a thoughtful and logical manner which makes sense and which is easy to understand. It is a good introduction.

The code examples a fairly easy to follow and do a good job of making their points even when they are only read instead of tried. Actually trying the examples makes the learning process more complete. If I had one major gripe about this book it is that it did not ship with a disc. The examples are available by download over the net but are not included in the purchase. This make work fine for some but I got started in out of the way motel rooms without highspeed access. I would have rather paid a few dollars more and gotten what I need.

Still, as I said before, it is a good introduction.

1 of 1 people found the following review helpful:

4.0 out of 5 stars Steve's review of Brown's Access VBA Programming, September 17, 2006

By 

S. Todd - See all my reviews
(REAL NAME)   

This review is from: Access VBA Programming (Paperback)

Breadth of coverage was great, but I felt it lacked enough good lengthier program examples. A case study (small application example) or 2 would have been nice. Book is terse and well-written and organized.