I have a rather long Word Document that everyone in my office updates on a monthly basis. It contains around 40 different active studies that the employees are working on. The format is: study title, short description of study, names of employees working on study, and a list of dates and actions taken on those dates.
example:
AQ CONFORMITY [Porta/Brooks]
Conformity designation and 2033 Long Range Plan adopted by MPO Policy Committee.
04/26/13 - EPA has concurred with conformity report.
My question is can anyone think of a way to design an access database to keep track of this information? The Word doc is a problem b/c only one person can have it open at a time.
I'm kind of stuck, Any thoughts would help