|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 27th, 2005, 08:33 PM
|
|||
|
|||
need help for employee skills database design
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 
|
|
#2
October 28th, 2005, 03:50 AM
|
|||
|
|||
|
need help for employee skills database design
Consider beginning with 3 tables:
tblEmployees ================ EmployeeID ..... tblSkills ================ SkillID SkillTitle tblEmployeeSkills =============== EmpSkillID EmployeeID SkillID SkillLevel -- Duane Hookom MS Access MVP "sgopus" wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Database Design Tools | Thomas Kroljic | Database Design | 12 | October 25th, 2005 03:34 PM |
| Auto Compact with Runtime Access? | Gordon Jones | General Discussion | 8 | October 21st, 2005 04:55 PM |
| Multiple Options Group | Patty Stoddard | Using Forms | 19 | August 4th, 2005 02:30 PM |
| Exclusive access to the database | Steve Huff | General Discussion | 17 | December 24th, 2004 06:23 PM |
| What is MDE | Charlie | General Discussion | 4 | August 24th, 2004 04:15 PM |
Linear Mode
