Access Help

[mrphilk]

I asked the below question in the excel forums and got told acces would be better for my needs, i have pasted the question through here. Thanks



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!

[RuralGuy]

You might look at what exists for Bill of Material (BOM) systems. Here's a couple of links to get you started:
http://www.mvps.org/access/queries/qry0023.htm
http://www.mvps.org/access/modules/mdl0027.htm