HELP! I am very impressed with the database written by Oxicottin (with the help of others) for tracking Employee Attendance (attached.) I posted the following message yesterday...but I think I posted it in the wrong place.
Here is the message:
I am an HR Manager for a manufacturing company in ffice Kentucky and am currently tracking employee attendance manually in three different programs. We use a program with a scanner to record employee's time worked and where I input vacation days and other time-off manually. Then I put that same information into an Excel workbook (each employee has their own worksheet) that tracks vacation time available and used and occurrences they have received for unauthorized time off. And then I key total hours from the scanner program into a payroll system to generate the employee’s paychecks.
I am very, VERY impressed with the Employee Attendance database written by Oxicottin (with the help of others from this forum) and would love to use it for my company. I am in the process of learning Access (self-taught) but am not far enough along to reconstruct some of the particulars that would need to be changed to fit the specifics of my attendance policy. (I just can’t seem to find the time…maybe it’s because I have three programs to maintain!!!) I recently found that I have the capability to download information from the scanner program to an Excel spreadsheet. I have been able to import that information into the payroll software which saves one step....now I believe that with some minor changes to this Employee Attendance Database, I would be able import the same information to track the vacation/occurrence portions. You cannot even imagine how much time this would save me!!
This is what I need help with:
Here is the message:
I am an HR Manager for a manufacturing company in ffice Kentucky and am currently tracking employee attendance manually in three different programs. We use a program with a scanner to record employee's time worked and where I input vacation days and other time-off manually. Then I put that same information into an Excel workbook (each employee has their own worksheet) that tracks vacation time available and used and occurrences they have received for unauthorized time off. And then I key total hours from the scanner program into a payroll system to generate the employee’s paychecks.
I am very, VERY impressed with the Employee Attendance database written by Oxicottin (with the help of others from this forum) and would love to use it for my company. I am in the process of learning Access (self-taught) but am not far enough along to reconstruct some of the particulars that would need to be changed to fit the specifics of my attendance policy. (I just can’t seem to find the time…maybe it’s because I have three programs to maintain!!!) I recently found that I have the capability to download information from the scanner program to an Excel spreadsheet. I have been able to import that information into the payroll software which saves one step....now I believe that with some minor changes to this Employee Attendance Database, I would be able import the same information to track the vacation/occurrence portions. You cannot even imagine how much time this would save me!!
This is what I need help with: