Logging and Auditing

[Adrian Lodge]

Hey,

I have an inventory control database program where the
user chooses when and how much inventory was removed and
added.

I have a table showing all interactions. How can I make a
log or audit of everything that is done on that program?
I will obviously need a new table for users, but how would
i automatically export data daily, weekly, etc.

Thanks in Advance,
Adrian