mkirkendall
Over time, I have seen a number of entries posing the question of how to use Microsoft Excel as an HRIS.

The short answer is that you shouldn't. While Excel is great for manipulating and rearranging data, it is not good at handling complex relational data.

What's That? Complex Relational Data. As an example, One employee may have had a history of many positions within an organization. One employee may have many entries related to leave and attendance. One employee may have many entries related to benefits. The list goes on and on. Tracking this in Excel without duplicating data and increasing your chances for error is a nightmare.

If you are a small or medium business and large solutions such as PeopleSoft and SAP are not in your budget, you can look to more appropriate tools than Microsoft Excel.

Microsoft Access is a relational database system capable of managing complex data and sharing within small workgroups. To see an HRIS created with Microsoft Access, see <link outdated-removed> ( Search On Cite | Search On Google ) . Full Source Code is available allowing you to expand upon what is there and create what you want.

Good Luck with your HRIS searches and just remember to use the right tool for the right job.

Thanks,

Mark

From United States, Sonora
khan_25@hotmail.com
Dear Mark Thanks for the advise and information. I have visited and downloaded the file, it is trial version, can’t find source code. Please advise. Regards Adnan
From Pakistan, Karachi
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.