Designing a Recruting Database

[Guest]

Hey all,
I am using access 2007. I am a recruter for a medium size company. I have
been asked by my supervisor to design a database to track applicants. There
is several thing we would like to track. Here are the tables I thing I will
need. My questions are, 1) will I be able to create a relationship with all
of the tables using the applicant id? 2)I have not been able to figure out
the best way to set up the checklist, any ideas? I relize this is
complicated, but I am am open to suggestions.

tblApllicants
applicantID (primary key, Auto number)
LastName
FirstName
Suffix (drop down)
Address
City
State
Zip
HomeTelephone
CellPhone
Email
DateofBirth (Calender)
DriversLicenseState (drop down)
DLState (drop Down)
ExpirationDate(Calender)
DateResumeReceived (Auto Date)
PositionAppliedFor (Drop Down list)

Tbldemographics
ID Number
Last Name
Age (Auto Calculate from DOB)
Race (drop down)
Sex (drop down)
Media (drop down) how they found out about the position

Tblchecklist (A check list indicating as a certain task in the process is
taken care of).
Completed
Item (Phone interview, mailed a packet etc)
DateCompleted



TblCharactorReference
IDNumber
LastName
CharName
CharAddress
CharCity
CharState
CharZip
CharDateSent (Calender)
CharDateReceived (Calender)

 

[Guest]

A couple of theings --
tblApllicants - duplicate fields - remove one --
DriversLicenseState (drop down)
DLState (drop Down)

Tbldemographics - remove Last Name
Add applicantID (foreign key, number integer) Could be consolidated into
tblApllicants as there will not be multiple demographics for an applicant.

TblCharactorReference - remove Last Name
Add applicantID (foreign key, number integer)

Add TblApllicantChecklist
IDnum (primary key, Auto number)
applicantID (foreign key, number integer)
DateCompleted
ChecklistItem (foreign key, number integer)
Comments - memo

When you add an applicant, add a list of items from TblChecklist to be
performed.

Set one-to-many relationship between tblApllicants, applicantID and other
tables with applicantID as foreign key.

Set one-to-many relationship between TblChecklist, ChecklistItem and
TblApllicantChecklist, ChecklistItem.

 

[Guest]

Thanks, I think I'll combine the demographics into the tblApplicants. How
can I add a field that will compute the age from the date of birth?

 

[Guest]

Don't, compute in a query when needed for reporting or display so it will be
current.
If you use Age: DateDiff("yyyy",[DOB], Date()) it will give you the
age. But if the DOB is tomorrow it will reflect the age as of now and not
what it will be next week.

Or do you want years and months? See an earlier post of mine 12/08/2006
in Queries --

Bonnie A
How accurate do you need the data?
Given 12/31/2005 and 1/1/2006 the DateDiff(“yyyyâ€, Date1,Date2) will return
one year. The same is true for 1/31/2006 and 2/1/2006 with DateDiff(“mâ€,
Date1,Date2) will return one month.

This will give you whole years --
Years: Int(DateDiff("d",[DateSold],[TermDate])/365)

Here is SQL for years and months --
SELECT BonnieA.DateSold, BonnieA.TermDate,
Int(DateDiff("d",[DateSold],[TermDate])/365) AS Years,
DateDiff("m",DateAdd("yyyy",Int(DateDiff("d",[DateSold],[TermDate])/365),[DateSold]),[TermDate]) AS Months
FROM BonnieA;

You can continue in the same theme for days.

 

[David W. Fenton]

I am a recruter for a medium size company. I have
been asked by my supervisor to design a database to track
applicants.

You might want to look here:

http://www.dfenton.com/DFA/examples/

All the GIFs in that folder are from a complex executive recruiting
app that was at one time used in NYC and London offices, with two
users working from home. The company it was written for eventually
went out of business.

 

[Steve]

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

 

[StopThisAdvertising]

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

This is NOT a way to answer questions Steve...

To the original poster:
Beware of his guy !!
Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

ArnoR

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

 

[Jamie Collins]

Hey all,
I am using access 2007. I am a recruter for a medium size company. I have
been asked by my supervisor to design a database to track applicants. There
is several thing we would like to track. Here are the tables I thing I will
need. My questions are, 1) will I be able to create a relationship with all
of the tables using the applicant id? 2)I have not been able to figure out
the best way to set up the checklist, any ideas? I relize this is
complicated, but I am am open to suggestions.

Recruting? Recruter? The prevailing advice is to check your spelling
meticulously on job applications. A recruiter who cannot spell their
own job title and with no existing software to manage job
applications? Do you ever see "Got kicked out of school for cheating
on my homework" on a person's resumé?

Jamie.

--

 

[Kirstie Adam]

be gentle! it's only a typo!

Hey all,
I am using access 2007. I am a recruter for a medium size company. I have
been asked by my supervisor to design a database to track applicants.
There
is several thing we would like to track. Here are the tables I thing I
will
need. My questions are, 1) will I be able to create a relationship with
all
of the tables using the applicant id? 2)I have not been able to figure out
the best way to set up the checklist, any ideas? I relize this is
complicated, but I am am open to suggestions.

Recruting? Recruter? The prevailing advice is to check your spelling
meticulously on job applications. A recruiter who cannot spell their
own job title and with no existing software to manage job
applications? Do you ever see "Got kicked out of school for cheating
on my homework" on a person's resumé?

Jamie.

--

 

[Jamie Collins]

be gentle! it's only a typo!

Both times? Yes, it could be bad luck, a faulty (e.g. sabotaged)
autocorrect setup, etc. Genuine recruiters (rightly) give me a hard
time when *I* make a typo ;-)

Jamie.

--

 

[Kirstie Adam]

will do!
i felt i had to stand up for those of us whos typing is not the best.....i
myself find myself typing words with letters round the wrong way all the
time......