Introduction to Access Programming

Introduction to Access programming

    When you create a new database, you typically begin by creating several database objects such as tables, forms, and reports. Eventually, you reach a point where you have to add some programming to automate certain processes and tie your database objects together. This article helps orient you to the programming tools in Access.

What is programming?

    In Access, programming is the process of adding functionality to your database by using Access macros or Visual Basic for Applications (VBA) code.

I use macros or should I use VBA code

    The decision to use macros, VBA, or both depends primarily on how you plan to deploy or distribute the database. if the database is stored on, your computer and you are the sole user, and if you are comfortable using VBA code, you might decide to use VBA to perform most of your programming tasks. However, if you intend to share your database with other people by locating it on a file server, you might want to avoid using VBA for security considerations.

    You should base your decision to use either macros or VBA code on two concerns: security and the functionality that you want. Security is an issue because VBA can be used to create code that either compromises the security of your data or can harm files on your computer. When you use a database that was created by someone other than yourself, you should enable VBA code only if you know the database comes from a trustworthy source.

    You should try to use macros when you can and use VBA programming only for operations that cannot be performed by using macro actions. Furthermore, you should try to use only macro actions that do not require granting trusted status to the database in order to run.

Macro considerations

    Beginning in the Access 2010 release, Access contains many new macro actions that enable you to build more powerful macros than you can build by using earlier versions of Access.Macros provide an easy way to handle many programming tasks, such as opening and closing forms and running reports. You can quickly and easily tie together the database objects (forms, reports, and so on) that you have created because there is little syntax that you must remember.

Please Watching My Video is Below

Design by Vannak Vannaro