O'Reilly logo

Access™ 2007 Bible by Gavin Powell, Joseph C. Stockman, Jennifer Reardon, Michael R. Groh, Michael R. Irwin, Cary N. Prague

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

Part II. Programming Microsoft Access

IN THIS PART

This part explains the art and science of Visual Basic for Applications (VBA) programming. Very few professional-quality Access applications have been written without liberal use of the VBA programming language and its capabilities. VBA provides you with powerful tools for adding capabilities and flexibility to your applications.

VBA is a fully qualified programming language and is used in many other Microsoft products, including all the main members of the Microsoft Office suite (Word, Excel, and PowerPoint), in addition to Microsoft Access.

Many user requirements simply cannot be implemented without using VBA code. VBA code provides functionality that goes far beyond simply opening forms and reports and controlling the user interface. You'll use VBA code to validate data, as well as transform and combine data in new and interesting ways. VBA code is used to import and export data, respond to user input, and handle the mistakes inevitably made by users.

VBA code enables you to seamlessly integrate with the other applications in Microsoft Office. For instance, using a surprisingly small amount of code, you can implement a very powerful mail-merge system by combining Access ...

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