Staff resourcing in Access

[thunderlizard]

If you tell me this is public sector, I am actually going to cry.

[MarillionFan]

Cheers I got that far - but thanks for pitching in. I can link the resources to the projects and show them and show the utilisation for each resource on a given month (they only want monthly - so I'm not offering more)

It's more about the presentation and the form design. How do I present a timeline with the facility to enter items into it. I can't think of a nice way of doing it - or even a horrible one!

There's a PM template in Access. Just create new one. Jobs a good 'un and you can go to the pub for the rest of the week.

[lilelvis2000]

This will probably be pretty basic to most, but I'm struggling with this.

I have been asked to put together a database (access) to track the projects here. One of the things they want to do is to be able to specify resources and then assign them to the various projects.

I'm struggling the think of a way to struture and present this. There will be a %age utilisation by person per month.

Any ideas? Has anybody done anything like this in the past? I did ask why they wouldn't use Project but they were not interested.

Done something very similar. think many-to-many...you'll need a table for projects, people, and people_projects. Well at the basic level anyway.

If you get stuck, I'm not doing anything at the moment.

[cojak]

And write down their requirements in a structured format, prioritise that into Must have, Should have, Won't have (due to them being unfeasible/too expensive/impossible in this universe). And get them to sign them off!

Else it will be your fault when it all goes wrong...

[vetran]

off the shelf

Scheduling Software for Employees, Customers, Rooms and Equipment

Small company who are very responsive.

dirt cheap with a decentish web interface.

No financial benefit in it for me just a satisfied customer.