PC Review


Reply
Thread Tools Rate Thread

How can I use Access track employment positions and candidates

 
 
=?Utf-8?B?RGF2aQ==?=
Guest
Posts: n/a
 
      6th Nov 2007
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?


 
Reply With Quote
 
 
 
 
Jeff Boyce
Guest
Posts: n/a
 
      6th Nov 2007
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
http://mvp.support.microsoft.com/

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


"Davi" <(E-Mail Removed)> wrote in message
news:361A5E54-411F-47C2-ADD2-(E-Mail Removed)...
> 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?
>
>


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i put a photo into candidates records in Access =?Utf-8?B?cnVtdXI=?= Microsoft Access Forms 2 2nd May 2007 04:20 PM
Access Employment Tinky Microsoft Access Getting Started 5 14th Jul 2005 12:44 PM
Keep track of previous and current mouse positions in MouseMove()? Brian Basquille Microsoft C# .NET 1 12th Mar 2005 03:45 PM
Moving items up and down in a sorted ListBox and keeping track ofthe items positions Lorenz Kahl Microsoft ADO .NET 0 10th Sep 2004 10:31 AM
Limited positions on Access 2000 Henrique Vaz Microsoft Access 1 3rd Oct 2003 09:44 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:17 AM.