So do we have a solution for Triggers in Access like we have in SQL Server, Oracle etc?. I think yes we do have but the branding and outfit is just a little bit different.
The above pic shows the options to write events just the way you write triggers allowing you to write an event/trigger before change, before delete, after insert, after update, after delete.
Now you can select an Event type to further work on and you can use a conditional statement to express your logic choosing the action from the right pane. This way you can use if else, looping blocks and can check the data on the particular stage and can filter, edit and undo the data based upon your requirement.