O'Reilly logo

Microsoft® Access® 2010 24-Hour Trainer by Truitt L. Bradly, Geoffrey L. Griffith

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required