I need a Microsoft Access database built from the ground up to manage multilayer Bills of Materials exported from SolidWorks. The single most critical feature is a master parts table that enforces truly unique part IDs—no duplicates can slip through. Around that core, I also want: • A BOM table that captures all parent-child relationships between assemblies and parts. • An operation table covering every manufacturing step (laser, punch, fold, weld, etc.). • A routing table that ties each part to its sequence of operations. • A revision table so every change is tracked and auditable. The relationships among these tables must be fully defined and referential integrity enforced. On the user side I’m looking for: • A clean part-entry form. • A BOM-entry form that supports simplified CSV imports from SolidWorks exports. • A query (or set of queries) that can instantly explode any selected sub-assembly into its complete, multi-level BOM. • An automatic serial-number generator for new parts. The finished database should let me allocate any part to its relevant operations and give me confidence that IDs, revisions, and routings are always accurate. Delivery deadline is within a month, and I’ll need the unlocked .accdb file plus a brief walk-through document so my team can maintain it. Please include examples of past work on Access databases—especially anything dealing with manufacturing, BOMs, or complex relational setups—so I can gauge fit quickly.