I am new to Access and have taken a number of courses, but based on my research I am having a hard time envisioning how to set up a new database for my group. Specifically, I can't figure out how to organize the tables correctly. I'm hoping someone can help me. Thanks in advance.
I need to track employee participation in projects on an annual basis. Specifically, I need to verify that they did participate in a project and then record how many hours they spent.
I would then like to track each employees total projects, total hours as well as each projects total participants and total hours.
If that's not clear, maybe this will help.
I need to track employee participation in projects on an annual basis. Specifically, I need to verify that they did participate in a project and then record how many hours they spent.
I would then like to track each employees total projects, total hours as well as each projects total participants and total hours.
If that's not clear, maybe this will help.
- I have employees, let's call them employee A, employee B, employee C, employee D.... Each employee has four or five employee data fields.
- I have about 50-60 projects and I need to record the employees who participate and their hours.
- End reporting will need to show each employees total number of projects participated in and the total hours they spent.
- Reporting will also need to show the total number of employees participating in each project and the total hours spent on each project.
- Ideally the reporting will be all mathematical and not a spreadsheet which needs to be counted.
