Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Excel, Access, Resumes Manage Database Schema


  • Please log in to reply
No replies to this topic

#1 david575

david575

  • Members
  • 14 posts
  • OFFLINE
  •  
  • Local time:08:45 PM

Posted 27 November 2007 - 01:45 AM

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?

BC AdBot (Login to Remove)

 





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users