#1
|
|||
|
|||
Excel or Acces
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! |
#2
|
||||
|
||||
Sounds like an Access project, please post it on www.AccessForums.net, I'm sure you can get some expert advice quickly.
|
#3
|
||||
|
||||
I agree with Matrix on this - DEF an Access project!
|
#4
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Opening multiple Excel files within the same Excel window. | lost9471 | Excel | 2 | 05-01-2010 01:57 PM |
How do I use an Excel form to populate and Excel spreadsheet | apostht | Excel | 0 | 05-21-2006 11:17 AM |