Access 2010 Macros: The Power of the Macro
Streamline your database with Macros.
Move over repetitive clicks! Here comes Macros. Access 2010 enables you to write macros attached to tables with a new feature called data macros. With macros you can create and save a set of command for a combination of clicks. So, you don’t have to add the same combination clicks any longer. Now isn’t that a relief?
As you use Windows Live to streamline your e-mails, similarly you can streamline your database with Macros. Data macros allow you to attach logic to tables and logic. Which means that when you add logic on a table then all the data and forms added in that table inherits that logic. By clicking on the Macro tools, you will see that the Macro Builder has been completely revamped for easy access. The search button will help you to spot quickly the similar files or data in your saved folders. This enables a faster access to all your data and files in your database. You can also add the existing macros from your database to a new one that you are building. The easy drag and drop feature will only make the building process a smooth one.
Adding comments to all your macros is crucial as it improves the readability of your macro. You can also use data macros to validate and ensure the accuracy of data in a table. There are two main types of data macros:
- Event-driven data macro: these are macros that are triggered by table events.
- A named or Standalone data macro: this type of data macro are associated with specific table but not with any specific event.
A smooth logical flow of actions is guaranteed with the introduction of this new user interface. After you have successfully created great many complicated Macros easily, you can share them on various platforms. Windows Live allows you to share your macros either by email or blog it for all your colleagues to view.
Macro Designer enables the simplification of complicated macro while minimizing coding errors at the same time. So, get smart and automate repetitive tasks with the improved editor, Macro Designer. You will soon learn that Macros is a great productivity tool.