Hello
I am completely new to Microsoft Access. I've tried to use Excel for what I am trying to achieve, but I think it needs a more robust database approach.
I would like to create a simple database.
Fields:
First Name
Last Name
Unique ID
Job Role
Job Level
Location
Month
I would like to keep track of employees and any changes happening to them such as: job role, job level and location (and to be able to pull out data by month)
I would like to set up a database, so that external users (line manager) can go to the form: Select their employee, change a job level and select a commencement date of the change (e.g. June).
This will mean that from June onwards, this employee will show with a new job level, but if we pull out the data for May the same year, the old job title will show.
I would also like people to be able to add a new record (new starter).
How do I start? Please help
Thank you
Ewa