Jewellery erp

Build a professional Jewellery Manufacturing ERP using Microsoft Access as the database and Excel as the dashboard. Create modules for Customers, Salesmen, Employees, Products, Orders, Production, Inventory, and Dispatch. Include departments: cad, cam, wax pulling & tree, casting, filling, laser spot welding, wax setting, hand setting, polish, qc, packing, and dispatch. Features should include auto Order id, priority (★★★★★), employee assignment, live department queues, order tracking, job cards with qr code, reports, pivottables, charts, search, filters, dashboards, inventory, production timeline, delay alerts, role-based login, audit log, automatic backup, and vba automation (save, edit, search, print, reports, dashboard refresh). Excel should connect to Access for real-time dashboards showing pending orders, department workload, employee productivity, overdue orders, dispatch status, and management KPIs.