52

Introduction to VBA

Visual Basic for Applications (VBA) is a programming language that is included with Access and most of the other Office 2010 products. VBA allows a user of Access to write a kind of Visual Basic code to provide custom functionality for a database application. VBA is very closely tied to all of the Office applications and makes it very easy to create custom code that works directly with a specific Office application and the code objects contained within it. Although you've already created some VBA code in previous lessons, these next several lessons discuss creating VBA code in much more depth.

LESSON SETUP

This lesson is designed to provide information about the Visual Basic programming language and the basics of writing VBA code. You should be familiar with creating databases, working with the basic objects in an Access database, and the Visual Basic Editor. Otherwise, completing this lesson does not require any other specific knowledge of Access or VBA code.

WRITING VBA CODE

Writing VBA code is by far the hardest part of learning to use Access, but the rewards are endless. Using VBA code, you can program almost any functionality desired into an Access database application. Now that you have a pretty good understanding of the major features that VBE has to offer and how it can be used, you can put that knowledge to use and begin learning how to write VBA code.

Visual Basic for Applications is a derivative of Microsoft's Visual Basic programming language, ...

Get Microsoft® Access® 2010 24-Hour Trainer now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.