It's not possible if you're working directly with tables.

Using foms, you have to put code into the form's BeforeUpdate event to
update the row's LastChanged field (which, of course, you have to add to the
table yourself)

You might find what Allen Browne has at
http://www.allenbrowne.com/AppAudit.html to be useful.