Daily Work Hour Collection

S

Sydious

I have been struggling with trying to create a data base for collection of
hours used on tasks through out the day for each employee for each shift in a
warehouse.
I need some BIG help.
I need to open a discussion to work through this I think.
I have tried asking this type of question before and I think I am being to
generic in my wording.

If someone can help work through this with me OR if there is a simular
database out there that I can use as a referance that would be great. (I
learn quite well by looking at other databased and building along those
guidelines.

Here is what I am trying to acomplish:
I need a form for the Group Leaders of each shift use to fill out and
account for the day's labor for their shift. (3 shifts total)
The form needs to display ALL the employees for the shift.
They need to record the time each employee spent in diffrent tasks for the
shift.
Each employee could do more then 1 task each day.
When all 3 shift's Group Leaders fill out the times for all the employees on
thier shift The data can be compiled into reports totaling up the hours and
display what each employee did that day and how many hours they did.

I currently use an excel spread sheet to collect this data. Each day the
group leader fills out a blank excel sheet and saves the file for the day. Of
course this causes a pile up of files. I also can't referance all three files
that make up a day at once. This is why I want to create a database.

This is the type of data collected each day.

Date
Shift
Employee (20 - 30 emps per shift)
Time Emp 1 spent on Task 1
Time Emp 1 spent on Task 2
Time Emp 1 spent on Task 3
(11 tasks currently tracked. Need to leave this open to diffrent tasks may
be added)
Time Emp 2 spent on Task 1
Time Emp 2 spent on Task 2
Time Emp 2 spent on Task 3
....and so on for each employee.

I am unsure if this is enough info for anyone to help me. I have been
working on this for about 2 months and can't get my head around it. I fail
each time I try.
I have made some successful databases but can't build this one.

Is there anyone out there who can help me work through this? Or lead me to
an example database simular to what I am trying to build that I can use as a
learning tool.
Need help please before I pull out what is left of my hair.
 
D

Duane Hookom

Do you have any tables set up? I would recommend at least the following:
tblEmployees
===================
empEmpID autonumber primary key
empFirstName
empLastName
empShift
empStatus

tblTasks
=============
tskTskID autonumber primary key
tskTitle
tskStatus

tblEmployeeWork
================
emwEmWID autonumber primary key
emwEmpID link to tblEmployees.empEmpID
emwTskID link to tblTasks.tstTskID
emwTime duration of working in minutes
(don't use a date/time field)

You can then create forms for entering time by shift or date or employee
or task or whatever.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top