I want to have some user functionality in my Access application.

I want a user log into the application using a username and password, and keep track of who did enter data.

I have a field in most tables that want to store the user that created the record. That field must be filled automatically and must not be visible to the user so he can't change it.

Could you guys teach me what do I need to do?
A step by step list would be great.

I know some VBA (variables, modules, procedures, data types, flow control, objects, properties, methods, ... basic stuff)

Thanks for your help!:)

You will want to search on those keywords:

User Level Security
Audit Trail