Access for Production Management

%3CLINGO-SUB%20id%3D%22lingo-sub-524335%22%20slang%3D%22en-US%22%3EAccess%20for%20Production%20Management%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-524335%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%3C%2FP%3E%3CP%3EDo%20anyone%20have%20any%20experience%20by%20using%20Access%20for%20production%20management%3F%20We%20are%20working%20IronCad%2C%20and%20the%20BOM-function%20gives%20us%20data%20in%20Excel-format.%20It%20would%20be%20very%20interesting%20to%20investigate%20how%20to%20make%20a%20dashboard%20that%20shows%20us%20status%20for%20our%20different%20orders%2Fprojects.%20The%20dashboard%20needs%20to%20extract%20data%20from%20the%20BOM-Excel%2C%20like%20orderno%2C%20customername%2C%20drawingfile%2C%20status%20drawing%20and%20status%20for%20some%20checkpoints%20during%20production.%3C%2FP%3E%3CP%3EIt%20would%20be%20very%20nice%20if%20the%20status-field%20could%20be%20stated%20in%20variuos%20colors%20according%20to%20the%20line%20of%20progress.%20Tips%20and%20links%20are%20very%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3EJonny%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-524335%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%20Web%20Database%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EApp%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-699783%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20for%20Production%20Management%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-699783%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F332805%22%20target%3D%22_blank%22%3E%40RovdeMobel123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20an%20Access%20consultant%20I've%20seen%20Access%20used%20constantly%20in%20production%20environments%2C%20from%20a%20simple%20recipe%20database%20for%20a%20plastics%20producer%20to%20a%20full%20scale%20ERP%20solution%20for%20making%20cheeses.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYour%20particular%20request%2C%20creating%20a%20dashboard%20and%20using%20colors%20is%20quite%20doable%2C%20but%20you%20may%20wish%20to%20consider%20also%20PowerBI.com%20for%20that%20as%20well.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHope%20that%20helps!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi.

Do anyone have any experience by using Access for production management? We are working IronCad, and the BOM-function gives us data in Excel-format. It would be very interesting to investigate how to make a dashboard that shows us status for our different orders/projects. The dashboard needs to extract data from the BOM-Excel, like orderno, customername, drawingfile, status drawing and status for some checkpoints during production.

It would be very nice if the status-field could be stated in variuos colors according to the line of progress. Tips and links are very appreciated.

 

Regards

Jonny

1 Reply
Highlighted

@RovdeMobel123 

As an Access consultant I've seen Access used constantly in production environments, from a simple recipe database for a plastics producer to a full scale ERP solution for making cheeses. 

 

Your particular request, creating a dashboard and using colors is quite doable, but you may wish to consider also PowerBI.com for that as well.

 

Hope that helps!