I am considering a data base to track production of a manufacturing line. I have the following information to handle:
Part Number (there are approximately 10)
Parts produced per day by part number
scrap parts by part number
rework parts by part number
I would like the ability to querie parts produced within a date range, parts scrapped by part number, etc.
Is access the correct choice. My initial thought is yes but I have built a total of 1 database, used to track membership attendance at events.
I have enjoyed reading on here over the past couple months and look forward to your input. Thanks!
old_chopper