Inventory Management In MS Access

Hi, I run a textile manufacturing business. I have a textile ERP setup that uses SQL. I want to build an inventory management system that can track my raw material, my work in progress, and my finish inventory level. If I can setup it in a way where the module can import data from SQL like material bill and sales bills, that'd make it even better.