Hi,
I need to create a project status sheet in MS Access by the request of my manager. I am using a project management software and I need to collect status from engineers in Access. I have always used an Excel status sheet for this easily since it is straight forward and I just copy paste the data from my project management software to excel then share the Excel sheet on a server. My new client manager wants a status sheet in Access because he says multiple users can view access at once. He is stern about this.
I want to import the data from excel into access then I want to filter the tasks by the responsible engineer name using a filter form. Then only that specific engineers tasks assigned will come up and they will then be able to fill out their updated status each week in Access.
The updates I will need the engineers to fill in for each task is Updated Start date, Updated Finish date, Total Hours worked on Task, Remaining work hours on task, and any comments they have.
I have only taken a basic class in Access . Does anyone have an access database status sheet example I could use?
Or give me some direction on how to build this?
I have been staring at access for a few hours now stumped..
Thanks for the help.