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!

Sounds like an Access project, please post it on www.AccessForums.net, I'm sure you can get some expert advice quickly.

I agree with Matrix on this - DEF an Access project!

If you already have a lot of this done in Excel, I would import it into an Access db as a table, then build queries to drill into my data I wanted, and then easily get to this, I would open on a form to extract my data

In a sense, queries are sub-tables you will want or soon want once you see the awesome power of data mining with Access