Help!

[Guest]

I am building a database using access for the HR dep at my company, i need to
add in a table for attendance which will need to be used on a daily basis by
the reception team to enter if the employee is present/holiday/sick etc. I
have built a database where each employee has a page with several tabs for
different information about them/job history etc. I need one for the
attendance but have no idea how to do this? I have tried using a excel sheet,
but having problems because they all need to be individual per employee????!!!
Can anyone help?
Chloe

 

[Guest]

Unless you want to learn Access on your company's dime, I suggest that you
check into HR trade publications or do a google search. Someone is bound to
have written a program, maybe even based in Access, that will do what you
need. It may cost some money, but chances are that it will be cheaper than
building a database from scratch.

That's my standard advice when a client wants me to create a new database
for them.

 

[Guest]

sorry,
im not quite sure i explained it very well!
basically at the moment we have a manual attendance cards for each
employee.showing the months april to march down the side and the days 1-31
across the top, so each individual day it can be filled out either p
(present) h (holiday) s (sick).......(done by the head of
department/reception, )
i need to be able to have an electronic version of this which can be linked
to the individual's personal details page.
is this any clearer?

 

[Guest]

If I follow what you are saying, you need an attendance table something like
this
tblAttendance
EmpID ReportingDate Status

You can then link the employee table to the tblAttendance on EmpID. On the
attendance tab you can have a 3 column listbox to display the history for the
employee.

I am assuming that you are just wanting to view the information, not input
it.

 

[Guest]

Jerry is correct in that there are plenty of time keeping apps out there.

However, it sounds like you already have a start to the database. If you
are looking to set up the form for data entry by dept head then you still
need set up a table as mentioned above. From there a good access book will
show you how to set up a form to save and display the data.

You are not looking at a lot of code / macros to make it work so it would be
a good starting point to get into Access development if that is what you are
looking to do.

Also, I realize people like to see the same thing on the screen that was on
thier paper in the manual process but I would recommend changing the display
to date on left and attendance type on right in a listbox.

John Q's Attendance Record
Date Attendance
1/1/07 H
1/2/07 P

you are talking about HR/Payroll information so you will need some controls
built in to keep things from being changed incorrectly.

ES