Home / MS-Access / Getting Started

Creating Table Data Macros

In Microsoft Access 2010, you can define a data macro to respond to different types of table events that would otherwise require the use of writing Microsoft Visual Basic code or the creation of macros attached to forms and reports. The unique power of data macros in Access 2010 is their ability to automate responses to several types of table events without forcing you to learn a programming language. The event might be a change in the data, the creation of a new record, or even the deletion of an existing record. Within a data macro, you can include multiple actions and define condition checking so that different actions are performed depending on the values in your table fields or criteria you specify.

In this tutorial:

  1. Uses of Data Macros
  2. The Data Macro Design Facility
  3. Access New Logic Designer
  4. Working with Before Events
  5. Grouping Macros
  6. Using If Blocks to Create Conditional Expressions
  7. Raising Errors in Data Macros to Cancel Events
  8. Testing Your Data Macro
  9. Defining Multiple Actions
  10. Collapsing and Expanding Actions
  11. Moving Actions
  12. Preventing Duplicate Records Across Multiple Fields
  13. Before Delete
  14. Working with After Events
  15. After Update
  16. After Delete
  17. Working with Named Data Macros
  18. Saving Named Data Macros
  19. Calling Named Data Macros
  20. Renaming and Deleting Named Data Macros
  21. Analyzing Errors in the USysApplicationLog Table
  22. Using Parameters
  23. Using Local Variables
  24. Working with Return Variables
  25. Debugging Data Macros
  26. Understanding Recursion in Data Macros
  27. Sharing Data Macro Logic