need help for employee skills database design

G

Guest

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

Skills database advice 3
Access Switchboard Question - MS Access 2010 0
Employee Hours Database 3
Creating an DB for an Office Tota/Skills 15
Opening for Solutions Architect with 8 years + Years of Exp in Bangalore 0
Access Employee testing checklist 0
Many to Many Relationship 3
design to select combinations of multiple values 2

Top