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 Access is a powerful database management system (DBMS) designed to help you efficiently store, organize, and analyze data. Whether you’re managing a small business, tracking personal ...

Microsoft Access is a database management system program that combines the relational Access Database Engine with a graphical user interface and software development tools. In Microsoft Access, you ...

When you create a Microsoft Access table, Access will automatically create a primary key to your database table. Still, you can also specify the field you want as the primary key for your database ...