Newbie Table Setup

[debl5]

I want to set up a database of my work experience. I think it will be useful in pulling different job skills and accomplishments to help me in configuring a resume to a specific job. I also thought it would be useful as an exercise to brush up on long dormant skills. If my being as stuck as I am now is any indication, I think they are long dead skills, not dormant.

I would appreciate help in how to set up the tables. Here's what I have so far:

Table One - Jobs
Company Name
Job Title
Start Date
End Date
Supervisor
Supervisor extension

Table Two - Companies
Company Name
Address
City
State
Zip
Phone
URL
Notes

Table Three - Accomplishments
Accomplishment Detail

Table Four - Skills
Skill Category

Table Five - Junction Table
primary key accomplishments


primary key skills

Each job has a list of accomplishments that can be categorized into one or more skill categories. If I write general accomplishments (like supervising people), they can relate to more than one job.

Ultimately I want to be able to pull a list of all jobs that relate to certain skills, all accomplishments that relate to certain skills, and all accomplishments related to a certain job.

I'm just not sure how to apply more than one category to an accomplishment. I understand (vaguley) the concept of building a junction table with the primary key from both the accomplishment and skills tables, but my head starts to hurt after that...

Any words of wisdom to get me headed in the right direction would be GREATLY APPRECIATED!! Thanks

[RuralGuy]

I would suggest starting with an existing sample template from MS and modify it to your needs.

[debl5]

I would suggest starting with an existing sample template from MS and modify it to your needs.

Any suggestions or recommendations on where to find one?

Thanks for your help.

[RuralGuy]

Access knows where to look. New>Template or under Help for the OnLine templates.