Hi, im working on a project to help me with work.

Im not sure if i would be better to create this using excel or microsoft access so wondered if you guys could maybe suggest something.



I regularly have to create parts lists for plant machinery that I work on and want to create a file which will help me to do this. The idea i have in my head is to have a front page, where I can select the date, customer and machine type that I am working on.

From here I will then be able to select various sections of a machine, each which will have its own list of parts to select from and add to my order.

Once done I want the document to be able to produce an itemised order for parts required.

I understand that this is a mammoth task but I often have a lot of spare time on my hands so I just need pointing in the right direction.

Can anyone make any suggestions for me, should I use excel or access first of all, at least then I will know where to start looking :-)

Thanks!