In this episode, we're going to take an introductory look at Data Macros in our MS Access database. Data macros perform a similar function to "Triggers" in other database management systems, and they do that by allowing users to execute updates when a record is inserted, or when a record is updated, or other events. For example, when a price is updated in one table, that price update can be logged in another table for a price history. In today's example, we'll log an event record each time a new case management record is added to a database, putting the current user's name on the record in the process. Related Videos: How to Use Data Macros to Track Changes to Field Entries in MS Access https://www.youtube.com/watch?v=WIWrMvks1Wo Data Macros in Microsoft Access You are watching this video now! How to Use Macros in MS Access https://www.youtube.com/watch?v=KWGt_hDHjOo Join me on Patreon! https://www.patreon.com/mackenziedataengineering Demo of my BZ RDP Cloaker: https://www.patreon.com/posts/how-to-block-rdp-98471703?utm_medium=clipboard_copy&utm_source=copyLink&utm_campaign=postshare_creator&utm_content=join_link Want the code from this video? http://mackenziemackenzie.com/downloads For developers looking for a new role, check out and sign up: https://www.toptal.com/qKaO2b/worlds-top-talent Needing to hire technical resources for your project? Get the best: https://www.toptal.com/qKaO2b/worlds-top-talent Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media: https://www.facebook.com/mackenziedataanalytics https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering #msaccess