Microsoft® Access® 2010 Inside Out

Uses of Data Macros

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 ...