Microsoft Access is one of the many programs that the Office package includes, it allows us to make databases , giving you the ability to filter and sort the information in your databases .
With Access we can add one or more tables to organize the data , in addition to adding different fields to these tables .
It has many options and features that make it easier to use than other database managers, such as customizing the quick access toolbar and its main window, which is very similar to other Office applications, which makes its use very intuitive. if we know how to use other Office applications such as Excel.
Another option it offers us is the use of Macros that will make your life much easier and will make working with your database more efficient.
What are Macros and what advantages and disadvantages do they offer
Microsoft Access Macros are tools that automate one or more processes, basically macros allow us to enter certain instructions, commands or patterns so that the program does a certain task automatically.
If for some reason you need to make a list of actions or an action that is repetitive, using macros you can tell the application as if it were a programming language, what you want it to do and how you want it to do it without having to be a professional user or a programmer.
This of course gives many advantages to the user as it allows reducing human participation in the process of updating or editing the database, thus reducing the possibility of errors, if the macros are used properly.
It also reduces the time necessary to do the activities, thus saving not only time but also effort on the part of the user, which increases the productivity and effectiveness of the program, greatly facilitating work.
It also increases the utility of the program as it allows to increase its range of activities, since with the use of macros new functions can be added and adapted to the particular needs of each user.
The main disadvantage that macros can have is that they can be used by malicious people to spread viruses or malware , some of these macros can contain these types of threats that can infect your database, computer or the computers that are connected to yours. .
The use of some of these macros could give entry to viruses or hackers that could infect your computer and access information not only in your database but also on your PC.
Fortunately, more recent versions of the application have Macros Generators that greatly increase the security of the application since they have numerous actions and options and if a macro tries to do an action that is not within the options that the program offers, it will not It will give it the necessary state of trust to function and in this way protect your database and your computer.
Types of Macros in Microsoft Access
There are several types of Macros in this program and depending on your particular need you can choose one of them:
- Independent : they are also known as User Interface Macros, and as this name indicates, they are attached to the user interface options and are used to automate processes and for the program to carry out a set of actions independently.
- Embedded : they are not visible in the navigation panel as they are embedded in the form, report or control in which it was created, even if you make a copy of these, the macro will be embedded in this copy.
- Sub Macro : it is an Access instruction that is part of an independent macro and defines it directly in the macro designer window, its only argument is the name of the macro and it is a string that identifies it.