Project tracking/planning

[Monish]

Hi -
I have a A2k3 db which is used to record project details...but it is static
in design. It is able to track project details and milestone dates as they
are planned (or occur), and then records results for each project.
I wanted to look into building capabilities for the project owners to also
be able to record and manage their project plans with notes. I was thinking
of having a calendar with notes fields on dates (as they are selected) to
appear as a linked form (and to record as a linked table).
I am looking at making this both for the User as well as for Management to
gain insight into project status and condition.
I am an intermediate Access user and am not sure if this is something that I
can do in Access or not...appreciate any and all help!
Thanks,

 

[Duane Hookom]

You should be able to set up a table with fields like ProjectID, NoteDate,
NoteAuthor, and Notes.

I'm not sure if I am missing anything from your question.

 

[TC]

You're getting close to making a common error, IMO. The error is to
start designing your forms & reports, before you've designed the table
structures in which you plan to store the data. You should design the
table structure /first/.

If you have a structure already in mind, list the table, showing the
names of the main fields in each table, and we can comment on that. Be
sure to show the primary key field(s) of each table.

If you don't have a stucture in mind, tell us more about the
information that you need to store, and we can suggest a structure.

Remember: table structure FIRST. Form & report design LATER.

HTH,
TC