How do I make a database for multiple employee resumes?

[Guest]

I need to create a database to quickly search through thousands of resumes.
It needs to have their name, location, and current job title. With a way to
attach their entire work history to it. I have taken all the classes I can
but I am still not one hundred percent sure how to do it. I would love to
have any suggestions.

 

[John W. Vinson]

I need to create a database to quickly search through thousands of resumes.
It needs to have their name, location, and current job title. With a way to
attach their entire work history to it. I have taken all the classes I can
but I am still not one hundred percent sure how to do it. I would love to
have any suggestions.

There are probably several ways depending on just what you need, but I'd see
at least the following tables:

People
PersonID <Primary Key - autonumber or some RELIABLE unique identifier; SSN
is probably neither legal nor reliable enough but lots of folks use it anyway>
LastName
FirstName
<location fields, other biographical data>

Jobs
PersonID <link to People>
Employer
StartDate
EndDate <leave NULL for current job>
JobTitle
<other info as needed about this person in this job>


John W. Vinson [MVP]

 

[Guest]

Thank you, also how would I attach their work history to the Jobs table?
Because currently I receive them in my email. and i am needing to be able to
see their entire work history for their placement.

 

[John W. Vinson]

Thank you, also how would I attach their work history to the Jobs table?
Because currently I receive them in my email. and i am needing to be able to
see their entire work history for their placement.

My suggested Jobs table has fields for the information that you described in
your initial post.

If you're asking how to have an EMail message (in completely free format, I'm
guessing) automagically parsed to extract the job title, start date, end date,
etc. then all I can say is that such a task almost certainly requires a USB
interface... Using Someone's Brain.

Can you control the structure or format of the emails?

John W. Vinson [MVP]