Entering Complex Data into Access

Posted by DataMakesMeCrazy on Stack Overflow See other posts from Stack Overflow or by DataMakesMeCrazy
Published on 2010-06-09T01:10:17Z Indexed on 2010/06/09 1:12 UTC
Read the original article Hit count: 201

Filed under:

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

© Stack Overflow or respective owner

Related posts about ms-access