From the course: Access: VBA
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Work with data macros
- [Presenter] Data macros add macro capabilities to tables. One common use for data macros is to send an email when table data meets a predefined condition. For example, the macro can send an email if a customer from Oregon places an order. In this movie I will show you how to create a data macro. I've opened the course database, and I need to display the tables that are available. So, I'll go to the tables section. And you might see a different list of tables based on what you've done already, but I want to work with customers, so I will double click the customers table to open it in table view. Now that the table is open, I can go to the table contextual tab on the ribbon. And in after events I can click after insert. Access opens a data macro window, and I can select my actions. In this case, what I want to do is select the if action for program flow from over here in the action catalog. If for some reason you don't see the action catalog, for example, if you close it accidentally,…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.