Hi, everyone.

I need to make an Access database application that can track hours spent by each employee per day in one of 8 different tasks. How do I approach this?

Any help is appreciated. Thanks in advance.

Regards,


Hailey
www.msaccessrepair.com - Access Recovery

Hailey

Hi

fairly big subject to cover on a single post you might want to try the following page on this web site


http://www.mvps.org/access/datetime/

Man Friday

Basically you will want to create the necessary tables first, which will include:

tblEmployee for employee data.
EmployeeID - PK
FName
LName
...

tblTask for task data.
TaskID - PK
TaskName
...

tblEmp_Task as a junction table between employees and their tasks.

tblEmp_Task
Emp_TaskID
EmployeeID - FK on tblEmployee
TaskID - FK on tblTask
Date
Hours

This basic structure will store all the data in your current requirements. You must enter all your employees and task names before you can start using the junction table. Then you can assign the hours to each employee. For example, data in the jnction table would look like:

Emp_TaskID EmpID TaskID Date Hours
1 1 1 09/11/2007 3

where 1 in EmpID represents your first employee record, 1 in taskid represents your first taskname, etc.

This structure will also give you what you need to create workable queries.

Does that help so far?



mmcdonal