Microsoft Access Workforce Management System
Budget: $250 – $750 USD
I'm seeking an experienced Microsoft Access developer to create a comprehensive Workforce Management System. This system should streamline our HR, payroll, and attendance processes.
Key Modules:
Core Modules & Requirements:
Recruitment and Onboarding
• Store job vacancies, applicant details, CVs, and interview notes.
• Track offer letters, joining dates, required documents (CNIC, photos, medical, police verification, etc.).
• Onboarding checklist (uniform issued, induction completed, etc.).
________________________________________
Employee Information Management
• Employee Master Database:
o Personal details (Name, Father Name, CNIC, Photo, Contact, Emergency Contact, Address).
o Employment details (Joining date, Department, Designation, Shift Type, Supervisor).
o Employment Type: Full-time / Contract / Reliever / Temporary.
• Document Uploads: CNIC, Contract, Police Verification, Training Certificates (stored as image/PDF).
• Status Tracking: Active / Terminated / On Leave / Resigned.
________________________________________
Attendance and Time Tracking
• Daily Attendance Tracking (Manual Entry or CSV Import).
• Shift wise attendance: Day / Night / 12-Hour / Reliever.
• Leave Management (Casual, Sick, Annual, Special), with approval workflow.
• Late arrival, half-day, overtime entries.
• Attendance Reports (Guard-wise, Client-site-wise, Monthly Summary).
________________________________________
Payroll Management
• Define salary slabs and guard-specific wages.
• Include overtime, EOBI, deductions (uniform, weapon deposit, etc.), and allowances (hardship, night).
• Monthly payroll generation and Net Pay calculation.
• Auto-payslip generation (exportable to PDF or printable).
• Manual adjustments where necessary.
• Export salary sheets to Excel for further processing.
_______________________________________
Performance Management
• Maintain supervisor ratings per guard.
• Track incidents, warnings, complaints, or achievements.
• Monthly or quarterly grading (A/B/C) for promotion, reward, or replacement planning.
• Record supervisor comments, improvement plans.
________________________________________
Training and Development
• Training module to store:
o Types of training (Fire Fighting, First Aid, SOP, Weapon Handling, Site Orientation).
o Attendance & completion tracking.
o Validity of certification.
• Automatic reminders for expired or due trainings.
________________________________________
Employee Self-Service Portal (Admin-Only in Access)
• HR can view and update:
o Employee profile
o Payslip archive
o Leave balances
o Deployment history
• Form interface for Leave Application or Contact Update (used by HR on behalf of employee).
________________________________________
Guard & Duty Management
• Roster creation module:
o Assign guards to specific client posts (with date ranges and shift).
o Shift Plan: Day / Night / Weekly Rotation.
o Site-specific rates and post codes.
• Deployment History Log: every site a guard has served.
• Equipment issuance (uniform, radio, firearm) log per guard.
• Generate guard rosters weekly/monthly and print/share.
________________________________________
Client & Contract Management
• Maintain client master:
o Company Name, Address, Contact Person, Sites/Posts.
• Upload or link scanned service contracts.
• Store rate cards (armed/unarmed, day/night, number of guards).
• Contract Start/End Date, Auto-renewal alerts.
• Site Post Codes for assignment mapping.
________________________________________
Compliance and Legal Features
• Track EOBI & Social Security status per employee.
• CNIC expiry tracker.
• License Validity (Security Company License, Guard License, Weapon Permits).
• Archive signed policies (Code of Conduct, Non-Disclosure, etc.).
________________________________________
Reporting and Analytics
• Standard Reports:
o Monthly Attendance Summary
o Payroll Report
o Roster Sheets
o Client-wise Deployment
o Training Completion Matrix
• Dynamic Filtering (by date, location, status, etc.).
• All reports should be exportable to Excel or printable.
________________________________________
Employee Separation (Offboarding)
• Resignation / Termination module with reasons, notice period.
• Exit Interview Form (optional).
• Final Settlement Calculation:
o Unpaid Salary
o Leave Encashment
o Deductions
• Asset Return Checklist (uniform, weapons, ID card).
Ideal Skills and Experience:
- Proficiency in Microsoft Access development.
- Strong experience in building HR and payroll systems.
- Knowledge of access control and user authentication methods.
Please provide examples of similar projects you have completed.
Key Modules:
Core Modules & Requirements:
Recruitment and Onboarding
• Store job vacancies, applicant details, CVs, and interview notes.
• Track offer letters, joining dates, required documents (CNIC, photos, medical, police verification, etc.).
• Onboarding checklist (uniform issued, induction completed, etc.).
________________________________________
Employee Information Management
• Employee Master Database:
o Personal details (Name, Father Name, CNIC, Photo, Contact, Emergency Contact, Address).
o Employment details (Joining date, Department, Designation, Shift Type, Supervisor).
o Employment Type: Full-time / Contract / Reliever / Temporary.
• Document Uploads: CNIC, Contract, Police Verification, Training Certificates (stored as image/PDF).
• Status Tracking: Active / Terminated / On Leave / Resigned.
________________________________________
Attendance and Time Tracking
• Daily Attendance Tracking (Manual Entry or CSV Import).
• Shift wise attendance: Day / Night / 12-Hour / Reliever.
• Leave Management (Casual, Sick, Annual, Special), with approval workflow.
• Late arrival, half-day, overtime entries.
• Attendance Reports (Guard-wise, Client-site-wise, Monthly Summary).
________________________________________
Payroll Management
• Define salary slabs and guard-specific wages.
• Include overtime, EOBI, deductions (uniform, weapon deposit, etc.), and allowances (hardship, night).
• Monthly payroll generation and Net Pay calculation.
• Auto-payslip generation (exportable to PDF or printable).
• Manual adjustments where necessary.
• Export salary sheets to Excel for further processing.
_______________________________________
Performance Management
• Maintain supervisor ratings per guard.
• Track incidents, warnings, complaints, or achievements.
• Monthly or quarterly grading (A/B/C) for promotion, reward, or replacement planning.
• Record supervisor comments, improvement plans.
________________________________________
Training and Development
• Training module to store:
o Types of training (Fire Fighting, First Aid, SOP, Weapon Handling, Site Orientation).
o Attendance & completion tracking.
o Validity of certification.
• Automatic reminders for expired or due trainings.
________________________________________
Employee Self-Service Portal (Admin-Only in Access)
• HR can view and update:
o Employee profile
o Payslip archive
o Leave balances
o Deployment history
• Form interface for Leave Application or Contact Update (used by HR on behalf of employee).
________________________________________
Guard & Duty Management
• Roster creation module:
o Assign guards to specific client posts (with date ranges and shift).
o Shift Plan: Day / Night / Weekly Rotation.
o Site-specific rates and post codes.
• Deployment History Log: every site a guard has served.
• Equipment issuance (uniform, radio, firearm) log per guard.
• Generate guard rosters weekly/monthly and print/share.
________________________________________
Client & Contract Management
• Maintain client master:
o Company Name, Address, Contact Person, Sites/Posts.
• Upload or link scanned service contracts.
• Store rate cards (armed/unarmed, day/night, number of guards).
• Contract Start/End Date, Auto-renewal alerts.
• Site Post Codes for assignment mapping.
________________________________________
Compliance and Legal Features
• Track EOBI & Social Security status per employee.
• CNIC expiry tracker.
• License Validity (Security Company License, Guard License, Weapon Permits).
• Archive signed policies (Code of Conduct, Non-Disclosure, etc.).
________________________________________
Reporting and Analytics
• Standard Reports:
o Monthly Attendance Summary
o Payroll Report
o Roster Sheets
o Client-wise Deployment
o Training Completion Matrix
• Dynamic Filtering (by date, location, status, etc.).
• All reports should be exportable to Excel or printable.
________________________________________
Employee Separation (Offboarding)
• Resignation / Termination module with reasons, notice period.
• Exit Interview Form (optional).
• Final Settlement Calculation:
o Unpaid Salary
o Leave Encashment
o Deductions
• Asset Return Checklist (uniform, weapons, ID card).
Ideal Skills and Experience:
- Proficiency in Microsoft Access development.
- Strong experience in building HR and payroll systems.
- Knowledge of access control and user authentication methods.
Please provide examples of similar projects you have completed.