Automating Microsoft Access with VBA

by Susan Sales Harkins and Mike Gunderloy

Book Overview

If you use Microsoft Access in your every day business life but haven't learned to fully exploit the program, now's your chance. Automating Microsoft Access with VBA is a thorough introduction to... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0789732440
• ISBN13: 9780789732446
• Release Date: September 2004
• Publisher: Que
• Length: 384 Pages
• Weight: 1.55 lbs.
• Dimensions: 0.9" x 7.5" x 9.2"

Customer Reviews

My Favorite VBA Book So Far

This book has become my favorite VBA reference book so far. It's great for those with an intermediate knowledge of Access and little-to-no knowledge of VBA. It includes practical examples of how to use the code provided in each lesson and concise explanations of why/how the code works. The sections on SQL Structure and Syntax and If/For...Else Statements are very informative, and easy to understand. I've also bought the "Forms, Reports and Queries" book of this series, and would highly recommend them both.

The right book

This book worths my money. All I need to do is to learn the syntax for Access VBA. I already has novice level of general programming. This book has clear and simple explanation of Access VBA syntax through its practical examples. If you want to learn practical and useful syntax for VBA this is the right book for you.

Table of Contents

"Here's the TOC I got from another site in case it helps." Automating Microsoft Access with VBA By Susan Sales Harkins, Mike Gunderloy Publisher : Que Pub Date : September 14, 2004 ISBN : 0-7897-3244-0 Pages : 408 Copyright About the Authors Acknowledgments We Want to Hear from You! Introduction Who This Book Is For What's in This Book Conventions Used in This Book The Sample Code for This Book Contacting the Authors Part I: Laying the Foundation Chapter 1. Why Access? Why VBA? Understanding the Place of Access in Office Understanding Access Programming Choices Chapter 2. Getting Around in the Visual Basic Editor Your First Glance at the Visual Basic Editor Introducing the VBA Modules Entering and Running VBA Code Getting Help on Code Establishing Good Habits in Coding Chapter 3. Using Variables, Constants, and Data Types Declaring Variables and Constants VBA Data Types Referencing Syntax Chapter 4. Using Procedures Understanding Procedure Types Declaring Procedures as Public or Private Passing Arguments Giving a Function a Data Type Implementing Error Handling Debugging Code Chapter 5. Choosing the Right VBA Function Introducing VBA's Built-in Functions Converting Data Types with VBA Functions Working with Date Functions Using Mathematical and Financial Functions Using String Functions Using the Format Function Using the Is Functions for Flawless Processing Interacting Functions Chapter 6. Using Flow-of-Control Statements Branching and Looping Using If...Then...Else Using Select Case Using For...Next Using Do Loops Using GoTo Chapter 7. Working with Arrays Introducing Array Variables Declaring an Array Variable Understanding the Array's Index Working with Array Elements Arrays with Multiple Dimensions Expanding to Dynamic Arrays Chapter 8. Understanding Objects Introducing Objects Reading and Setting Properties Invoking Methods Working with Collections Working with an Object Model Creating Your Own Objects Working with Events Chapter 9. Understanding Scope and Lifetime What's Scope? Measuring the Lifetime of a Variable or Constant Using Static Variables Part II: Working with the Access User Interface Chapter 10. Working with Forms Opening and Closing Forms The Form Module and Event Handling Performing Common Tasks Handling Errors at the Form Level Working with Multiple Form Instances Chapter 11. Analyzing the Acce

An invaluable and continuing reference

Mike Gunderloy and Susan Sales Harkinsdeftly collaborate in Automating Micro-soft Access with VBA to produce an ideal, comprehensive, 408 page introduction and instructional manual enabling the reader to readily take full and ocmplete advantage of VBA's diverse capabilities. With thoroughly "user friendly" instructions for customizing Access database applications to meet business needs, Automating Micro-soft Access with VBA is an invaulauble and continuing reference.

A Quick Lesson for the Non-programming Professional

With Microsoft Access you automatically get a lot of capabilities to do forms and reports based on the data to be put into or taken out of the database you create. You also get a macro capability so that a limited amount of manipulation of this data can be done automatically. Used less frequently but which is far more powerful is the programming language Visual Basic for Applications or VBA. Built into each copy of Access for several versions VBA is there and available for use whenever needed. All that's needed is the skill to write the programs. This is a relatively small book for one on computer software, it's hardly 400 pages. The intent of the book is to get you up and running in a short period of time. It's aimed at the computer professional who use Microsoft Access in a business setting. You are not expected to be a programmer, but by the end of the book you'll be able to program using VBA and to do so quickly. When you know VBA for Access, you'll also be well on your way to knowing VBA for the rest of the Microsoft office suite. The various forms of VBA do have some changes that relate to the underlying structure of the application. But the basic structure of the language itself is the same. There's only one thing I'd like to see added in the next revision of the book, that is a list of the reserved words used by the Access database. Not knowing these has gotten me in trouble a couple of times.