Access Database Templates of Hr Software for Small Business Tutorial



Access Database Templates of Hr Software for Small Business

The Access template is for HR software for small business and compatible with microsoft access 2016. It can be used in managing the employees database, their absence and attendance, and as well analyzing their payrolls. The employee management software can be used in any kind of industry but specifically for small to medium business company.

The HR software for small business has these menus:

EMPLOYEES
Menu for recording the employee database software. The fields are:
- Employee ID: Primary Key. autogenerated field, in numeric. You can modify the field mask later.
- Names field: String.
- Email Address: String. No validation at the moment, but you can set up later.
- Phone Number: numeric, consist of 3 digits for extension (in bracket) and 7 digits for actual phone number.
- Hire Date: Date/Time
- Active Status: lookup field. There are 2 values. Active means the employee still working regularly. Pension means the person has been retire but receive their pension investment. You can add more status such as Quit.
- Monthly Salary: in currency.
- Project Details: Description of the project that taken and worked by employee. You can change it into job positions instead. The HR software for small business can be easily to modified to fit your company needs. You can add more details, such as address, job positions (with lookup value), birthdate, or marital status and children.

 

access database templates of hr software for small business

 



To upload or change employee photo/picture: 1. Double click the photo box or click the attachment icon (which will appear after you click the photo box once)

 

hr software for small business

 


2. Attachment dialog box will appear. Click Add.
3. Navigate to the photo location. Select the new photo, click OK. You can add more than one pictures.
4. Click Remove and Open button to manage the pictures.
5. If you want to switch photo, just click the navigation arrows besides the attachment icon.

 

employee hr software for small business

 



On below, there are 4 more fields:

- CV Upload: attachment fields, for CV or portfolio. To upload the cv, follow the steps in setting up employee photos.
- CV Upload Date: Date/Time
- Uniform: attachment fields, for displaying work dress code. To upload the picture, follow the steps in setting up employee photos.
- Uniform Details: string, for describing the uniform such as color, name, or size.


EMPLOYEE ATTENDANCE DATA
Menu for tracking the employee attendances and absences.

 

human resource management system software

 



- Employee: lookup field, value taken from Employee menu.
- Date: in Date, attendance Date
- Work Status: lookup field. Currently there are 3 values: At work, Sick, and On Leave.
Only Sick status would counted as absence. On Leave status meaning that the employee has permission or taking their vacation days. It can be meaning that the employee take early leave.
- Time In: in Time, arriving time. Can be blanked if work status is Sick or On Leave. Will affect Late Rate in Reports.
- Time Out: in Time, time going home.

DATABASE REPORTS

 

employee database software

 


When you open the Report menu, a Report Settings form will be displayed first. The form consists of:
- Resumption Times: In Time, started time of office hour. This field will only affect Late rate in show Attendance Report.



SHOW EMPLOYEE ATTENDANCE REPORT in MS ACCESS
Report to display the employee performance management software report, along with the late and On Time Rate.

 

employee performance management software

 



In this ms access report, there are 3 subs:
- Company Overview: display total number of employee, active employee, and pension employee.
- Company Monthly Performance (Active Employees only): display the overview of all employees performances. Active employee only. It displays the Working Days, Absence, On Time and Late statistics.
- Monthly Performance Summary by Employee (Active Employees only): overview of performance by each employees. The displayed record fields same like Company Monthly Performance, only in each employees.
Because the Time out field (in Attendance menu) is not too utilized in HR software for small business, you can set up the overtime point system using the Time Out field in report. Or, you can set out the overtime or early leave report.


EMPLOYEE UNIFORMS
Report for displaying employee uniform and dress code:

 

employee management software

 



The human resource management system software is open source. You can modify the template and enhance its features. You can set the HR software for small business into web application for multiuser usage or integrate with other application. The HR software for small business can be downloaded for free at access-templates.com and you can use microsoft access 2016 to operate this access templates.

Frequently Asked Questions

Which Microsoft Access software version work with this database?

This database template will work optimally on MS access software version 2016 and the latest 2019 version. You can use the older version but it may caused bug or error.

How to Download This Access Database Template?

Simply go to our homepage and browse the template you want to use, you can also use search form function to get templates in specific keyword. You can Register Here and become our paid member if you want to get all templates without download limitation in unlocked version.

Is It Safe To Download This Database from This Website?

We've been serving our users since 2011, you can verify here. We are always committed to build a secure and user-friendly database for our users, and thats why we still exist in this business until today. You can also verify our website security using McAfee, and you can directly scan the downloaded database using VirusTotal or any other Antivirus software you have in your computer. All access databases and templates on this website are 100% free from virus, malmware or any other harmful objects.

Can I Modify The Database Template?

Yes, you can modify all of our templates to fit your needs as long its for personal, education or non-profit use only. If you want to modify and use it for commercial or business purposes, you have to buy extended licence separately. Read more: Terms of Use.

How to Download Microsoft Access 2016 or 2019 Software?

You can purchase Microsoft Office Professional Edition 2016 or 2019 version from Microsoft website or authorized partners. Make sure to choose the Professional edition package which included MS Access.

Can I Request for Access Database Modification Service to Fit My Needs?

Yes, we are open for any kind of modification service on microsoft access templates and databases. You can send your access modification request here.

How Can I Contact Microsoft Access Programmer?

You can contact our programmer using the contact page on this website, or if you need faster response you can send us WhatsApp Message to +1-(786)-886-3099 (working hours only) and Priority support only available for paid members. If you don't get answer by phone due to heavy work-load on all of our staffs, we suggest you to send a whatsapp message or email admin@access-templates.com