Access Vba Programming (PROGRAMMING & WEB DEV - OMG) - Softcover

Brown, Charles

Softcover

ISBN 10: 0072231971 ISBN 13: 9780072231977

Publisher: McGraw-Hill Education, 2004

Synopsis

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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.

About this title

From the Back Cover:

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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 21 years. In the process he has developed and delivered training for many of the 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 new Microsoft .NET environment. In addition he delivers programming training in Java for Learning Tree International. Brown has taught VBA to many beginner programmers as well has having done VBA programming for Swiss Bank Corporation, the US Government, NASA and Price Waterhouse Accounting. Brown is the author of Fireworks MX From Zero to Hero and Beginning Dreamweaver MX. He was also a contributor to the Macromedia Studio MX Environment.

About this edition

• Publisher: McGraw-Hill Education
• Publication date: 2004
• ISBN 10: 0072231971
• ISBN 13: 9780072231977
• Binding: Paperback
• Number of pages: 464