Employees Database Management System

[salsai]

I am HR Officer, I want to make Employees Database Management system on MS Access, can any open arrange template of following fields?


Sr.#.
Emp. #
Name
Grade
Functional Title
Academic Qualification
Professional Qualification
CNIC #
Date of Birth (DD-MM-YY)
Age
Date of Joining (DD-MM-YY)
Length of Service
Date of Last Promotion (DD-MM-YY)
Present Place of Posting
Br. Code


Since posted (DD-MM-YY)
Region
Circle Office
Area
Basic Pay
IBS # (if any)
AS # (if any)
PA # (if any)
2006 Rating
2007 Rating
2008 Rating
2009 Rating
Remarks (Please specify if Emp. is on LPR or Notice Period)

[orange]

Do NOT have spaces or special characters in table or object names.

Here is a link to some info for you.
All sorts of info on Access and using it http://www.accessmvp.com/strive4peace/

Database design info you will need
http://www.rogersaccesslibrary.com/forum/topic238.html

[wjgo]

I am new to creating databases, but I am sure someone will suggest some of the following. A form or report can calculate the current age and length of service.

The pay rates, titles, qualifications, regions and other items are not unique to the employee so they should have their own table, and when the employee record is created, it looks up the data for qualifications, regions and such from their tables so the information is consistent, not mistyped or made up.

[salsai]

Thanks a lot dear for help, But i need template with following field, Its the most common template using in each organization, any one will have i think