We work in 7 states I want to build a skills database so i can search for particular skills, sometimes excluding people based on home state for travel reasons..
i am editing a free student template
Novice
Windows XP 
Access 2010 32bit
We work in 7 states I want to build a skills database so i can search for particular skills, sometimes excluding people based on home state for travel reasons..
i am editing a free student template
Competent Performer
Windows Vista Access 2010 (version 14.0)
My advice would be to start with a People table (primary key PersonID), a Skills (primary key SkillID) table and a PersonSkills Table that links the two (contains PersonID and SkillID).
Novice
Windows XP Access 2010 32bit
I appreciate your advice, .. i am actaully a fair hand at excel and PC generally but have no access experience... the people and skills tables yopu mention are they available in a template form or is it something i will build from scratch?
Competent Performer
Windows Vista Access 2010 (version 14.0)
I don't know of a template that has these tables. You will likely have to build it from scratch.
Moderator
Windows XP Access 2003
There is a free data model here that may be a starting point. You may want to exclude parts - depending on your needs.
http://www.databaseanswers.org/data_...king/index.htm
The key will be to get your data structures( tables and relationships) correct so they match your requirements.
Calculating Expiry Date -
transfer multiple excel files to multiple tables in Access
Posting Permissions
Reply With Quote