Fairly new to Access and trying to do something that seems simple, but may be very complex. I want to create a database of projects, each project has several phases (ie proposal, marketing, etc) and that will allow for multiple employees to work on a single project. Ie Bob and John are working on project number 102. From here, i would like to enter the forecasted start and end dates for each phase of the project, and enter the forecasted number our hours each employee will be allowed to work on that phase of that project ie.
Project - Employee - Phase - Start - End - (list weeks)
102 - Bob - Marketing - 12-May-10 - 21-May-10 - 3 - 5 (3 hours first week, 5 hours the second)
and so on
Basically would all this data be on one table, or several? And can access dynamically show the weeks between the start and end date so that i can input the hours?
I feel this database will become severely complicated :S
Thanks, J