O'Reilly logo

Microsoft® Access® 2010 Inside Out by Jeff Conrad and John Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required