Resume database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to manage quite a few resumes - is Access a good tool for this? If I
am searching for a medical front office manager, can it sort through all of
the resumes and pull up just those that have those key words?
 
Access would be very good at this. For this functionality you need the
following tables:
TblResume
ResumeID
<<Resume Detail Fields>>

TblKeyword
KeywordID
Keyword (keyword could be one or more words)

TblResumeWithKeyword
ResumeWithKeywordID
ResumeID
KeywordID

You would need a search form for specifying the keyword. On this form, a
combobox would work for one keyword a multiselect listbox would work for
multiple keywords.

You would need a query based on TblResumeWithKeyword with appropriate
criteria from the search form in the KeywordID field depending on whether
you wanted to be able to search on one keyword or multiple keywords. This
query would returb all ResumeID that contained the specified keyword.

You would need a results form with a listbox whose rowsource included the
above query and TblResume. You could select the resume you wanted to view
here. The Afterupdate code would open a resume form.

You would need a resume form based on TblResume to display the resume you
selected in the results form.

With a little tweaking you could consolidate some of this but this gives you
the general idea.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Thanks Steve
--
Anne


Steve said:
Access would be very good at this. For this functionality you need the
following tables:
TblResume
ResumeID
<<Resume Detail Fields>>

TblKeyword
KeywordID
Keyword (keyword could be one or more words)

TblResumeWithKeyword
ResumeWithKeywordID
ResumeID
KeywordID

You would need a search form for specifying the keyword. On this form, a
combobox would work for one keyword a multiselect listbox would work for
multiple keywords.

You would need a query based on TblResumeWithKeyword with appropriate
criteria from the search form in the KeywordID field depending on whether
you wanted to be able to search on one keyword or multiple keywords. This
query would returb all ResumeID that contained the specified keyword.

You would need a results form with a listbox whose rowsource included the
above query and TblResume. You could select the resume you wanted to view
here. The Afterupdate code would open a resume form.

You would need a resume form based on TblResume to display the resume you
selected in the results form.

With a little tweaking you could consolidate some of this but this gives you
the general idea.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
Click to expand...
 
Anne said:
I need to manage quite a few resumes - is Access a good tool for this? If
I
am searching for a medical front office manager, can it sort through all
of
the resumes and pull up just those that have those key words?
Click to expand...

I suggest you take a look at X1. It's free and will likely do a much better
job of managing the resumes than something you put together in Access. It
will automtically index them and do lightning fast searches.

My 2 cents worth
 
Back
Top