Forums
Microsoft Access
Technology Forum
Microsoft Access
Discuss how to choose system that will yield the best results, as well as how to maintain it, and how to calculate its return on investment.
We are a small company with 50 staff. Usually we use Excel for payroll, attendance & other records of employees. Since, the staff strength is small, our company does not want to invest on any HR s
0
Cat:Topic ForumsForum:ForumId57
Cat:Topic ForumsForum:ForumId57Discussion:DiscussionId26120
Forums » Topic Forums » Technology Forum » Microsoft Access
|
Microsoft Access
posted at 1/20/2004 6:09 PM EST
|
Posts: 52
First: 6/18/2002 Last: 6/7/2008 |
We are a small company with 50 staff. Usually we use Excel for payroll, attendance & other records of employees. Since, the staff strength is small, our company does not want to invest on any HR software.
I was wondering if we could use Microsoft Access instead of Excel. Does anybody here have experience using MS Access ? Any comments/suggestions would be most welcome. Thanks |
|
|
Microsoft Access
posted at 1/22/2004 5:32 AM EST
|
|
Posts: 50
First: 12/1/2003 Last: 2/13/2008 |
You can use Access, but it may be more of a headache and resource drain than you think. Do you plan for employee number growth? Also, what kinds of things do you do with HR? Perhaps I could recommend some HR software you might look at. |
|
|
Microsoft Access
posted at 3/3/2004 9:37 AM EST
|
|
Posts: 1
First: 3/3/2004 Last: 3/3/2004 |
We use access and find it very useful because you have the flexibility to build a system around your processes. Often purchasing off the shelve systems mean that you have to change your business processes to fit with the system.
Access is scalable (will grow with the business needs...ours currently holds in excess of 7000 employemnt application records and 40000 associated recruitment activity records. Because of its flexibility you can build as you go along. If you start by identifying your outputs eg the type of information you need in reports etc you can build tables and forms to input the information. We have used some simple vb code to automate information flow and populate fields automatically thus reducing key strokes. |
|
|
Microsoft Access
posted at 4/5/2004 12:34 PM EDT
|
|
Posts: 1
First: 4/5/2004 Last: 4/5/2004 |
I am not sure of your experience with Access, so I hope that I am not speaking down to you. Access is an affordable relationalship database. Although it is not as powerful as say Microsoft SQLServer, Oracle, or MySQL (which is free when used in a non-profitable setting), it will never the less do what you should need it to. Access can easily be used to develope a database to allow you to track payrole, attendance, and most anything. In addition, you can easily move data into or from Excel and utilize the functions, such as the mathmatical functions in excel, that are a little more complicated in Access. |
|
|
Microsoft Access
posted at 9/9/2004 12:24 AM EDT
|
|
Posts: 1
First: 9/9/2004 Last: 9/9/2004 |
Hi All
I'm a software developer for a software house that provides HR and Payroll Software product. Access is fine for databases upto lets say 200,000 records. It provides a good way for non-developers to create forms and reports. There are many books and tutorials available on the net/bookstores. You can easily export your existing records to SQL, Oracle, XML or in fact anything. I would suggest that you use the MSDE (Microsoft Desktop Database Engine) which is available free of charge from Microsoft and bundled with some version of MSOffice. You can still use Access for the frontend but you get the huge benefit of a stable and time tested database of upto 2Gb in size. |
Forums » Topic Forums » Technology Forum » Microsoft Access
