Employee Resume Database

[Guest]

Hello,

Our architecture/engineering company currently uses an excel spreadsheet to
keep track of employee resume information(this includes name, years
experience, certifications, projects worked on, etc). This is then used to
manually update the resumes which are word documents. I am looking into the
possibility of creating a database to manage this information and make
entering and updating new information easier. Are there any templates or
examples for an employee resume database in existence? Thank you in advance
to anyone with suggestions.

 

[Guest]

Isn't it a pain when people don't respond? You don't say how experienced you
are with Access. If you are newbie, expect a very steep learning curve!

To give a similar example, I have designed a database for job description
profiles. So each job title has many job descriptions and each job
description can belong to many job titles. I also have a report based on a
filtered query so that I choose a specific job title and the report will list
all the job descriptions.

I can't see your case being any different.

Each employee works on many projects and each project has many employees.
ALSO, I think you could have a job title table since one job title can apply
to more than one employee. In this table, you can list all the job tasks that
go with that title.

Does an employee perform the same tasks for each project?

So you want an employee table (that lists all the info for each employee
that you would expect to see on a CV), a project table (that lists all the
relevant project info) and a junction box which links the two.

I don't use an MS Word mail merge. It might be easier to create a template
report in Access.

I hope that is a start!