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.

The VBA procedure Formatting tables using VBA is easy—very little code is required. Knowing which properties to change is the key to getting it right.

Between the 2003 and the most recent versions, the number of rows that can be reached in an Excel sheet has changed significantly. As a result, the VBA codes prevent the portability of your workbook ...

Excel VBA allows you to call an external function or module with a simple "=NameOfFunctionToCall" entry in the code syntax. However, in .NET applications, you should always use the "Call ...