Data Macros in Microsoft Access
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
• How to Use Data Macros to Track Chang...
Data Macros in Microsoft Access
You are watching this video now!
How to Use Macros in MS Access
• How to Use Macros in MS Access
Join me on Patreon!
/ mackenziedataengineering
Demo of my BZ RDP Cloaker:
https://www.patreon.com/posts/how-to-...
Want the code from this video?
http://mackenziemackenzie.com/downloads
Interested in transforming your career or finding your next gig?
https://system.billzone.com/careers.html
Want my team to do a project for you? Let's get to it!
https://system.billzone.com/smdeproje...
Contact form you can find at http://www.mackenziemackenzie.com/
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/...
Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenz...
#msaccess
