Access for Production Management

[RovdeMobel123]

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

[#2]

@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!