O'Reilly logo

Microsoft Access 2013 Inside Out by Jeff Conrad

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 2013 provides various types of data macro actions that you can attach to table events as well as inside named data macro objects to automate your web app. With data macros, you can do the following:

  • 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 any data from being edited, added, or deleted from a table.

  • Create new schedule records based on the previous week’s schedule or a labor plan template.

  • Delete all schedule records within a specific time frame.

As you’ll learn in Chapter 8 Access 2013 supports user interface macros to control application flow in your views and to respond to user actions. You can ...

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