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.

In Microsoft Access, you can add records to an existing table that already as data and resize the columns that contain the fields and data, especially if there is not enough space within the columns ...

Did you know that you could calculate fields in the query in Microsoft Access? If the user wants a calculated field in a query, the user needs to input a name for the calculated field, a colon, and ...