I use two DateTime fields for that: Created and Modified. Set the default for Created to Now() and use data macro or VBA to update Modified to Now() when the record is changed/edited.
How would a history work and look? Also, the username would come from who every logs into that PC?
Most of the time, we just use one log in, so that would have to change?
I was just wondering what your actual requirements were. If you need to know how the data was progressively changed from the original value, you are probably looking at an audit trail.