Hello

I am trying to create a data base of instruction sets. Where I work when a job comes in it comes in on a "traveller". This is basically a set of instructions on how to carry out the job.



Ie

Clean glass.
Put down plastic layer.
Put down metal layer.


Cleaning the glass has several steps involved, as will putting down the other layers. There are also different ways to put down plastic layers and to put down the metal layers. There are also set ways for setting up the same layers each time.

Ie:

Standard Process 1

Clean Glass
Put down plastic A
Put down Gold layer

Standard process 2

Clean Glass
Put down plastic B
Put down Gold layer

Standard process 3

Clean Glass
Put down plastic layer B
Put down titanium layer

I would like to build a database so that I can output and excel spread sheet with a front sheet, a set of instructions and a back page for adding notes through the manufacturing process.

I would like it so that I only need to have the cleaning layer stored once and then added into any traveller

I want to be able to:

Create separate instruction set for each individual layer.
(Something like a spread sheet with a sheet for each thing so "put down plastic layer A" would exist once and if one of its sub instructions changes it changes here and then that's it done.)

By able to put them together into travellers.
(a set of macros so one for clean glass I could press this and it would add clean glass to a new traveller, press a different one and it would add "put down plastic b" after clean glass. I could then save this so that I could do the below)


Create a standard traveller.
(So this could be an access report or an excel macro that copies and pastes into a new excel worksheet that it creates. So press "standard process one" macro and it would create a new excel work sheet with a front page, a page of all the instructions in it needs and then a back page ready to be sent out and printed. Any new macros created would then be made up to pull the instructions from the lists created from above)

Is this possible and which office package would this be best completed in?

Thanks

Adam