I do not believe Jet (the database engine Access uses) supports table-level triggers, so you'll need to use a macro or VBA code in a form to trigger the extra record.
Follow the steps below on how to create a tabbed form in Microsoft Access: A Field List pane appears on the right. In the Field list pane, you will see a list of fields in your table or tables ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback