Tracking timelines in Access

[jk42]

Hello!

I'm trying to figure out a way to use Access instead of Excel to do some tracking.

What is being tracked: The number of days between a project due date and the actual date is being turned in, the day there is feedback given, and the day that it's sent on to our client, the day that our client gives us feedback.

From there management will want monthly averages. I'm assuming that these monthly averages can be done via reports in excel? I don't know as I've never successfully used a report.

Anyway, I'm struggling coming up with a good design for this. I currently have a list of all projects, employees, and project managers as separate tables in my current database, so I really want to make this work in Access as it seems like it would be so much easier to manage than using excel (I currently do it this way and actually do all the calculations manually)

Surely there is a way to link:
Project Manager to Project to Employee Assigned to the dates... but I really am not Access smart to figure it out. I would love any tips!

Thanks!

 

[jk42]

Oh ,and this may help:

1 project can have:
-1 Project Manager
-Any number of employees
-Any number of locations
-Any number of visits

 

[jk42]

One more note, I'm not asking anyone to design it for me, I really would just love ideas to get the juices flowing, I don't even know if this would be feasible in Access!

Thanks!

 

[CJ_London]

I think you need to explain your problem in a bit more with detail of the tables you have and what you actually require

The number of days between a project due date and the actual date is being turned in, the day there is feedback given, and the day that it's sent on to our client, the day that our client gives us feedback

does not make sense - if you need to know the number of days between project due date and actual date - that is simply datediff("d",[project due date],[actual date])

From there management will want monthly averages

Of what exactly? date differences?

 

[jk42]

I did not know that you could do that calculation in Excel. I ended up making a sheet that would work for my purposes. Thanks so much!