Using data macros


show more Using data macros provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Using data macros

A Data Macro allows you to perform an action upon adding, updating, or deleting a record. When a customer's order is marked as complete, it would be nice to automatically send them an e-mail letting them know their olive oil has been shipped. To do this, open up the Orders table. Go up to the Table tools Ribbon and choose Table. Then click on After Update. A Macro window will open. In the first box, select If and type in a square bracket to start a field name and start typing OrderStatus.

You'll get a little dropdown with the possible matches in your database. We'll go ahead and double-click on OrderStatus, and it puts it in there. Type in = "complete". The quotation marks show that it's a text value. In the next box down, choose SendEmail. A box with parameters will open. In the To field, type in square bracket, Customers!, another square bracket, and EmailAddress and end the bracket.

The first one tells us to look in the Customers table. sSparated by the exclamatio...

Using data macros
Video duration: 2m 16s 3h 30m Beginner

Viewers:

Using data macros provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...