Access Project Direction

[halo242]

Hi,


Have only been using access a few months and I was just handed a task and Im not sure what direction to move in to get this done.

I have been asked to develop a project management database for our engineering department with Access. A few months ago I made something similar and much simpler for our accounting dept to manage Credit Requests for customers wanting to establish terms. The Design project is more complex but not so much.

The whole idea behind this is a sales person fills out a form answering a series of questions for a design project request. The engineer in turn get this project added to a list of rolling projects for review. The engineer can make changes to status etc and the list would become public on the web somewhere so Sales can see the status of their requests. However, they want it a bit more intricate so once you submit to this database the sales person can login and see their submissions only and have the ability to edit some data such as “priority”. So they could delegate priority amongst their submission.

What would be the best way to proceed to complete a project like this? I know I can make the tables and form in Access but about making the other stuff view able they way they way it is more of a challenge to me.

Any suggestion or direction would be appreciated.
-Paul

[friendlyfriend]

How similar was this previous project? Access is not a tool for web projects. There are thousands of web tools though so that decision can be daunting. I came across this for using Access and Sharepoint but I haven't tried it. Or maybe you could try Wavemaker.