Access Tutorial 12: An Introduction to Visual Basic

the same. This tutorial is an introduction to a handful. of programming constructs that apply to any third. generation language, not only Visual Basic for …

More PDF Content

Access Tutorial 12: An Introduction to Visual Basic
Page 1
© Michael Brydon (brydon@unixg.ubc.ca) Last update: 25-Aug-1997 Next Home Previous 1 o f 16 Access Tutorial 12: An Introduction to Visual Basic 12.1 Introduction: Learning the basics of programming Programming can be an enormously complex and difficult activity. Or it can be quite straightforward. In either case, the basic programming concepts remain the same. This tutorial is an introduction to a handful of programming constructs that apply to any “third generation” language, not only Visual Basic for Applications (VBA). Strictly speaking, the language that is included with Access is not Visual Basic—it is a subset of the full, stand-alone Visual Basic language (which Microsoft sells separately). In Access version 2.0, the subset is called “Access Basic”. In version 7.0, it is slightly enlarged subset called “Visual Basic for Appli- cations” (VBA). However, in the context of the simple programs we are writing here, these terms are interchangeable. 12.1.1 Interacting with the interpreter Access provides two ways of interacting with the VBA language. The most useful of these is through saved modules that contain VBA procedures. These procedures (subroutines and functions) can be run to do interesting things like process transactions against master tables, provide sophisticated error checking, and so on. The second way to interact with VBA is directly through the interpreter. Interpreted languages are easier to experiment with since you can invoke the interpreter at any time, type in a command, and watch it execute. In the first part of this tutorial, you are going to invoke Access’ VBA interpreter and exe- cute some very simple statements.
Page 2
Learning objectives 12. An Introduction to Visual Basic Next Home Previous 2 o f 16 In the second part of the tutorial, you are going to create a couple of VBA modules to explore looping, conditional branching, and parameter passing. 12.2 Learning objectives What is the debug/immediate window? How do I invoke it? What are statements, variables, the assignment operator, and predefined functions? How do I create a module containing VBA code? What are looping and conditional branching? What language constructs can I use to

Download Access Tutorial 12: An Introduction to Visual Basic pdf from fisher.osu.edu, 16 pages, 134.5KB.
Related Books

One Response to “Access Tutorial 12: An Introduction to Visual Basic”

  1. Exceptional tutorial! You saved me a lot of frustration. Honestly, thanks.

Leave a Reply