need help for employee skills database design

S

sgopus

I am in the process of desiging a database that contains employee skills
I have resolved most of the problems, except for one that allows for one
employee to have multiple skills and keep a table reflecting that.

My previous experience with databases was not with relational databases only
flat
so this is my actual first attempt at this, could someone direct me to a
sample
database that I could download, and or give me some tips on how to link my
tables
and what to put in them ie fields and etc, thanks bunches..
I understand this is kinda vague , it's the best I can do
 
D

Duane Hookom

Consider beginning with 3 tables:
tblEmployees
================
EmployeeID
.....

tblSkills
================
SkillID
SkillTitle

tblEmployeeSkills
===============
EmpSkillID
EmployeeID
SkillID
SkillLevel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Matching people to skills. 3
Need Help with Macro Security 1
Lookup field from linked tables - can it be done? 2
Help with table setup for many-to-many/categories 3
Many to Many Relationship 3
Creating an DB for an Office Tota/Skills 15
Show employees and others in combo box 3
Hierarchical db - need no-edit option in form 1

Top