Access for Production Management

Copper Contributor


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.




1 Reply


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 for that as well.


Hope that helps!