The title doesn't exactly cover the complexity of this task - I'm in the process of creating a database that records all members who have applied to this organization and current members of the organization. This database has to include their skill set, previous jobs, qualifications both professional and courses taken from which institute, whether they were appointed in the the organization before etc. It has to allow for efficient searches for appropriate candidates (based on qualifications etc) who are already in the database if a job should arise, searches to notify when an employee's appointment is to end etc. Currently using Microsoft Excel and there are over 500 + records. I'm in the beginning stages of creating an ERD and going thru normalization - my problem is not all attributes can be single valued.......example they want a field that explains the responsibilities held in previous jobs or a field that explains why an employee was dismissed - (it's easy for data that is pre-defined or single value if you know what I mean)......I am wondering if MS Access would be the best choice for this or is there a way I can mix it up? Any advice or opinions much appreciated.
This is my first real database that I'm creating so a little inexperienced so appreciate any advice.
Thanks for any help