Date Updated Column

[David F]

In SQL Server I can use a trigger to populate a "date created" and "date
updated" field.

For example, in my orders table I have a "date created" and "date updated"
field. When a row is added to this table, both of these fields are updated
by the trigger with the INSERT date. Later, if the row is modified, the
"date updated" field is modified with the UPDATE date.

This gives me a nice audit trail for the activity in the table.

Is there any way to accomplish this in Access?

Thanks