I am a new user and I am currently working on an Access database to have all information on a mentoring project in one place.
So basically the below is the information we need to keep:
Placements - is unique to each client and employer...if the same client is matched to another employer because the first employment was not successful, then a new placement is created. The same goes for the employer.
Appointments - each placement can have a maximum number of 8 appointments. Information like time and date, location, and what was discussed, if mentors spent money (they will be given an allowance if they need to meet clients say at a coffeeshop) needs to be kept here.
Clients - information on clients like name, surname and contact details
Job - the details of the job i.e. hours of work, job title, job description
Mentors - the persons who will be mentoring clients during a placement. Mentors can have various placements to mentor.
Employer - employer contact details, location, etc
How should I go about it?
So basically the below is the information we need to keep:
Placements - is unique to each client and employer...if the same client is matched to another employer because the first employment was not successful, then a new placement is created. The same goes for the employer.
Appointments - each placement can have a maximum number of 8 appointments. Information like time and date, location, and what was discussed, if mentors spent money (they will be given an allowance if they need to meet clients say at a coffeeshop) needs to be kept here.
Clients - information on clients like name, surname and contact details
Job - the details of the job i.e. hours of work, job title, job description
Mentors - the persons who will be mentoring clients during a placement. Mentors can have various placements to mentor.
Employer - employer contact details, location, etc
How should I go about it?