Project

denzil21

Board Regular
Joined
Oct 29, 2007
Messages
85
I am trying to develop a Project application, in which I have a Project Table. There are many Projects. Say Project1, Project2, Project3 Etc., Projects have Pre Contract and Post Contract. There after under Pre Contract and Post Contract there are many activities.

Could some on you please help me with the Tables and the Forms, for Data Entry and then letting the users be given access for daya to day entry.

I have the Employee table abd the rest in place.

Thanks and Regards.
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Here are a few comments based on reading your post. These are meant as constructive and to help you in determining if any of these things make sense in your situation.

I worked on a System a number of years ago, where there were such things as Projects, Commitments, Applicants, Clients, Customers, Benefits, Payments etc. Some was an Applicant , seeking to have a Project , under a government Program. However, he wasn't really a Client until his Application was officially approved. An Application could be withdrawn, approved, declined... all depending on certain Program conditions.

If the Application was Approved, the terms of the Project were identified in terms of a Contract. The Contract spelled out who would do what by what data, and what penalties would/could be imposed if conditions were not met. (All legal like)
Often the project had many milestones, especially if there were "sub projects" within a master project.

To complicate things different Government programs had slightly different terminologies for many of the "similar things", and some conditions that crossed Program lines (such as maximum Government contribution).

To resolve many of the terminology differences, and to put some consistency on Programs and Projects, the concept of "Status" was adopted. You can think of status as a stage or step in a long line of steps.
Such things as (<i> I just made up these numbers and names to give you some ideas. Perhaps it can be applied to your situation or assist you with your situation</i>)

Pre application consultation
Application
--status 100 --
Application withdrawn/declined --status 101/102
Application approved
--status 200 ----
and so on and so on
Payment made
...
final payment made
--status 700---
project implementation
--status 750 --
benefit realized (xx %)

post implementation evaluation
--status 900 ---
Project Complete
-- status 999---


So a Project may have statuses 100,101,102,200,201,202,204...... 999

Each status must meet some criteria.
You may define the Project in terms of status, and you would know exactly where it stands.

This may be overkill for you, but maybe a similar concept would apply.

Good luck.
 
Upvote 0

Forum statistics

Threads
1,224,505
Messages
6,179,153
Members
452,891
Latest member
JUSTOUTOFMYREACH

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top