How can I use Access track employment positions and candidates

[Guest]

1 Identify Users

2 Identify User Requirement
Employ Manager: candidate work experience and education background, specific
position candidates compare report.

Manager Asistant: candidate work experience and education background,
specific position candidates compare report.

Candidate: Positions details, search the jobs meet requirements and skills.

Recruit officers: list new positions, detail resumes, search candidates meet
specific positions essential requirements.

3 Identify data that need save and search: data in resume before processing;
seperate repeat group and add key; resume data, exclude items and add outside
key; multi link relations.

4 Identify useful data.

5 Identify relations between sheets, for report, query and others.

6 Complete window, report and query design


File/Outside Data/Import
File Type: Outlook.
Outlook Contact

Outlook
Search Outlook
Search Folder

If company have a new Manager Asistant position, I should see all email
apply this prosition, how to create a "search folder" to search email that
apply for this position in Outlook folder?

Outlook provide a library with 13 "search folders"
I can "create user define search folder"

Outlook File/New/search folder
In "search folder", roll down to "user define", click "create user define
search file folder"
Input name of the "search folder", because the position title is "Manager
Asistant", so input "Manager Asistant" in this textbox.

Click "conditions"

In "search folder", click "mail" option, input "Job Req.56" in "search text"
textbox.

So, the position advertisement require candidates must input "Job Req. 56"
in any emails about this position.

In "location" drop down list, choose "only subject words".

Click "Enter" several times.

I am doing well?

Every position can create a "search folder"

Can I also search subject line and content of email, about the
advertisement, I put some keywords in advertisements, so when then apply and
include the advertisement, the "search box " can sort these emails. And also
search for skills, education background or skill ability related key words.

How to do that?

Use outlook organize meeting, interview and email:
1 Calendar can use for interview
2 Employment officers can use email send resume and share interview response.
3 Use email quick response to employee questions and communicate with
managers.
4 Color "calendar" can highlight important items.
5 Mark emails need operate and more continue works.








Word
Word Template
Job Application Form
Candidates track
Candidates Evaluation
Work Experience Evidence Form
Employment Confirm Letter
Employment Rejection Letter


Excel
Track and report HR data
Resumes received
Candidates sources
Interviewed candidates quantity
Interviewed - employment ratio
Reject reasons

Evaluate, analysis and report:
1 Employee statistic
2 Employee relation
3 Staff management ratio

How to do this?




Use Visio and PowerPoint
Create sheets and presentation files
Visio to create and share structure presentation.
For example, department manager and employee relation
PowerPoint can create Procedures, HR contact list.
How to do it?


Excel
Use template track and compare vacancy candidates data
Simply evaluation, "Job Candidates Data and Compare Sheet" template:
1 "candidates data", input basic data, name, address, phone, apply position
2 "candidates compare data", input detail information relate to work "job
now working", and compare with many candidates.
Download templates
Microsoft Office Online/template/staff recruit
How to do it?

 

[Jeff Boyce]

You've laid out some pretty extensive general system requirements.

These newsgroups, however, focus on helping folks answer specific questions,
focused on detailed, specific aspects of how Access works.

If you haven't been using Access long, building a system that does what
you've described is going to take a pretty steep learning curve.

Have you checked on-line to see if someone else may have already built a
system that does some/much/most of what you want?

Do you have a specific question, or are you trying to find someone who will
build your system?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/