BN.com Gift Guide

Access VBA Programming / Edition 1

Paperback (Print)
Buy New
Buy New from BN.com
$27.28
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 94%)
Other sellers (Paperback)
  • All (30) from $1.99   
  • New (10) from $1.99   
  • Used (20) from $1.99   

Overview

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.
Read More Show Less

Product Details

  • ISBN-13: 9780072231977
  • Publisher: McGraw-Hill Professional Publishing
  • Publication date: 8/23/2004
  • Series: Programming Ser.
  • Edition number: 1
  • Pages: 464
  • Product dimensions: 7.40 (w) x 9.10 (h) x 0.92 (d)

Meet 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.
Read More Show Less

Table of Contents

Ch. 1 Introduction to VBA for applications 3
Ch. 2 Designing an Access application 13
Ch. 3 Access development without VBA 27
Ch. 4 Customizing the Access environment 47
Ch. 5 Introducing the VBA programming environment 63
Ch. 6 Programming fundamentals using VBA 79
Ch. 7 Understanding the Visual Basic editor 113
Ch. 8 VBA language components 139
Ch. 9 Sub procedures 165
Ch. 10 Debugging VBA code 181
Ch. 11 Function procedures 201
Ch. 12 Forms 217
Ch. 13 Reports 233
Ch. 14 Menus and toolbars 253
Ch. 15 Changing the Access environment 269
Ch. 16 Database security 283
Ch. 17 Access and the Microsoft Office environment 301
Ch. 18 Access and the Web 315
Ch. 19 Upgrading 333
Ch. 20 Multiuser applications 349
Ch. 21 Beyond Microsoft Access 367
App The DoCmd object 385
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)