Access 2010 provides various types of data macro actions that you can attach to table events to automate your application. With data macros, you can:
Verify that an invoice is balanced with the invoice detail line items before saving the record.
Mark an employee as inactive after you create a termination record.
Prevent a record from being saved if it violates a composite key index.
Send an email to the database administrator if an unexpected error occurs within the application.
Prevent any data from being edited, added, or deleted from a table.
Email individual employee schedule details to all employees.
Create new schedule records based on the previous week’s schedule or a labor plan template.
Delete all schedule records within a ...