If you own a version of Microsoft Office that includes Access (Office Professional 2010 is the most current version), but you’ve never used it, you’re overlooking a powerful tool for organizing and ...

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 database management system program that combines the relational Access Database Engine with a graphical user interface and software development tools. In Microsoft Access, you ...