Motivation
A team I worked with had a warranty claims process that had grown beyond what informal tracking could handle. The volume was too high, status was hard to follow across claims, and there was no reliable way to know where any given claim stood in the process. They needed structure without disrupting how the team actually worked.
Implementation
The solution was an Access database holding all claim records, paired with an Excel workbook that served as the team's interface. The workbook handled everything they needed — entering new claims, pulling existing ones, updating status — through VBA macros that talked to the database directly. The team never had to interact with Access itself, which kept the barrier to adoption low.
Tools & Technologies