Posted 27 November 2007 - 01:45 AM
I try to print the "Relation", but it's in a big mass.
Many sheets there
Sheet/Awards: Awards Numbers; Applicant ID; Awards; Year; Reference Numbers
Sheet/Certificate: Certificate Numbers; Applicant ID; Certificate; Institute; Keyword; City; Country; Reference Numbers
Sheet/Education: Education Numbers; Applicant ID; Education Degree Type; Education Course Name; Education Institution Name; KeyWord; City; Country; Start Year; End Year; Education Graduated On; Education Comments; Reference Numbers
Sheet/Education & Experience: Number; Applicant ID; Employee Last Name; Employee First Name; Education Degree Type; Education Course Name; Education Institution Name; Education Graduated On; Education Comments; Language; Licenses Issue Date; Licenses Renewal Date; Licenses ID; Licenses Description; Licenses Comments; Training or Skills Completion Date; Training or Skills Group Name; Training or Skills Training Name; Training or Skills Proficiency; Training or Skills Renewal Date; Training or Skills Renewal Date Comments; Awards; Certificate; Work Experience; Reference; Reference Phone; Reference Business Phone; Reference Mobile or Cellular; Reference Email Address; Reference Company; Reference Position
Sheet/Employee Name: Applicant ID; First Name; Last Name; Marital Status Single or Married; Date of Birth yyyy m d; Age; Dependents; Gender Male or Female; disabled; disabilityPerCent; DetailsOfDisability; Address 1; Address 2; City or Township; State or Province; Country; Postal Code; Home Phone; Home Phone 2; Home Phone 3; Business Phone; Fax Number; Mobile or Cellular; Pager Number; Email Address 1; Email Address 2; Email Address 3; Web Site; Prefer Position; Ethnic Origin; Citizenship; Visa Type; Visa Expires; Employee Type Full Time Regular or Part Time Regular; ExpectedReturnUSD; Apply Job; 3YearProfessionalHighSchool; 3YearProfessionalCollege; 3YearProfessionalMaster
Sheet/Language: Numbers; Applicant ID; Language
Sheet/Licenses: Licenses Numbers; Applicant ID; Licenses Issue Date; Licenses Renewal Date; Licenses ID; Licenses Description; Licenses Comments; Reference Numbers
Sheet/Reference: Reference Numbers; Awards Numbers; Certificate Numbers; Education Numbers; Licenses Numbers; Training or Skills Numbers; Work Experience Numbers; Reference; Reference Phone; Reference Business Phone; Reference Mobile or Cellular; Reference Email Address; Reference Company; Reference Position
Sheet/Training or Skills: Training or Skills Numbers; Applicant ID; Completion Date; Institute Name; TrainingName; TrainingSubjects; TrainingProficiency; City; Country; Start; End; Years; Training Renewal Date; Training Renewal Date Comments; Reference Numbers
Sheet/Work Experience: Work Experience Numbers; Applicant ID; Company; Work Experience; Position; SalaryUSD; Start Year; End Year; Years; Location city; Location Country; Reference Numbers
Too many data to record
In trouble relation
I must sort which data is necessary.
And redesign the sheets
Department: Position: Location: Sequence number: Shift: Pay scale: code:
400 DCA02 410 3019 1 G4S8 400-DCA02-410-3019-1-G4S8
names count of position numbers
(positions filled) (positions authorized)
Use Word to create relevant forms, such as personnel action forms, position authorization/elimination, etc.
Eventually, upscale to Access to also track position history and employee history, and linked directly to our payroll database. Adding various features.
This meet the requirement of the company?