Jump Start VBA Skills with MS Access Macros
(Page 1 of 5 )
Macros help to speed up the performance of certain repetitive tasks when using an application. They are used extensively in all office-related software. As a programmer, you can leverage the built-in macro object in MS Access to get a head start in understanding VBA. This article explains how.
Introduction A macro is a construct to automate programming steps in an application. For example, suppose you want to go to different parts of a document, and change a number of things. Additionally, you want to do this for a number of similar documents. Then you would write a macro, which, by just pressing one button, makes all the changes you want on every document you want to change. Because of this capability, macros are extensively used. They are used in all office applications.
In the Microsoft world the different macros in the Office programs like Word, Excel, Access and others developed at different times, and existed independently. They found a common ground in Visual Basic for Applications, or simply VBA. Learning VBA will help you go a long way toward understanding VB, the programming language and VBScript, the scripting language for Internet applications.
This tutorial is about leveraging the built-in macro object in MS Access to learn VBA. This is not a compendium of VBA; it simply covers how to use a macro to learn VBA. In this tutorial I will show a few basic steps that you could adopt to find out more about VBA. Of course the value of books, both online and offline, cannot be overstated. As the title says, this is just a jump start. As a first step, we will create a few macros, which will be used to bring out the VBA program behind the macro.
Next: Creating and running a macro in MS Access: opening the macro designer >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
/ 28 
