RACI using Access Form and Report

[batwings]

Hi there

I searched the forum but drew a blank,

Have any of you ever created an Access Database with a Form and report that can be used to produce RACI reports or Deployment flowcharts?

I would like to store business processes and the individual steps that they are made up of and record who is (R)esponsible (A)ccountable (C)onsulted (I)nformed.

I think what would be required is a
1) a Table for the Processes
2) another for the Process Items (step to complete the process)
3) a table of the different parties that can be either R,A,C or I
4) a Table that holds the RACI Tags, Just R,A,C,I and their Descriptions

I'm not sure how to create the form that would be used to :-
1) add the Process Title
2) define the activity steps
3) add the different Parties
4) create the cross reference between the Step Items, the party or parties involved and the flag to say whether they are R, A, C or I

And then output the data to an access report or possibly Excel

I'd be gratefull of any help at all