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.

Microsoft introduced its Access database product about 20 years ago, and it remains popular due to its ability to link and import data from a variety of sources. Either through ODBC or native drivers, ...

This section describes how to retrieve DBMS data by using the statements and components of the SQL Procedure Pass-Through Facility to access DBMS data. The Pass-Through Facility uses the SAS/ACCESS ...