Access VBA Programming

Features

• Cover Type: Paperback with 464 pages
• Published by: McGraw-Hill Osborne Media
• Edition: 1st Edition August 23, 2004
• Written in: English
• ISBN 10 Number: 0072231971
• ISBN 13 Number: 978-0072231977
• Book Dimensions: 9.1 x 7.2 x 1.2 inches
• Weighs: 1.7 pounds

Product Description
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.

Back Cover Copy


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 basics 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.

Reader Reviews
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.