New to Access... please help

[albrad84]

I am new to Access but come from a programming background and I need to create a Skills Management Database for my company. This is basically where we find out the skills of all the employees so that the project managers can easily find people who would be suitable to a particular project.

So for each employee added to the system, I want to put in basic information about them (name, department, title, etc.) along with the skills they have (selected from a pre-defined list) and the amount of experience they have with that particular skill (in years).

The problem I'm having is that because one employee might have 1 skill and another might have 100, I'm not quite sure how to store this in a table. In object-oriented programming languages, I would create a new "skill object" and could create as many as I wanted for each employee. But with Access, I'm not quite sure how to set this up. Can you create new objects of tables? Or is there a way to have a variable number of fields in a table?

Any help would be greatly appreciated...

 

[TheEvilBankers]

I would create an employee table, skills table (the predefined skills) and lastly a table called employee skills. In this table I would have employeeID, SkillID and experience.

Then make a form where you select an employee, then a subform where you select their skills from a drop down box and enter the years of experience.

This is a simplified explanation.

K