Excel, Access, Resumes Manage Database Schema

[567]

I try to print the "Relation", but it's in a big mass.

Object/Sheet/

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

Any suggest

Someone said,

use Excel

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?

[Martin L]

make it in Access. You need some time for it but once done it will save you hours and hours of work. Make 10 tables where you specify a key, for example the id number of that person, and you can add all the other relevant info from those sheets as colums in the table (make sure that the id of persons can only be there once, and that all the tables have that unique id, otherwise you might get problems with running queries). By making a form you can easily edit them, and by making a good report you can easily print it out and show it to the boss.