May 03 2019 03:16 AM
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
Jun 18 2019 07:12 AM
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!