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 ...

Forms make it easier for you to enter and modify data in your Access database. Once you create a form, you can add tabs to it, making it even easier to navigate. Tabs are especially beneficial when a ...

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 ...