Case Study: Air Force One achieves automated Microsoft Access reporting and major time savings with ChristianSteven Software (MARS)

MARS Breathes Fresh Air into Air Force One

Air Force One, a U.S., Canada and Puerto Rico HVAC design, installation and service provider, was struggling with internal communication breaks between offices, management and departments that led to missed tasks and slipping customer service. Their reporting needs outgrew Microsoft Access’s native tools—compiling a few reports took about 20 hours a month—and the company sought a reporting automation solution from ChristianSteven Software, ultimately trialing MARS to address the problem.

ChristianSteven Software’s MARS automated the company’s Microsoft Access reports—sending weekly sales updates to reps, monthly client activity reports (previously four hours a month) and a daily open-ticket summary emailed company‑wide seven days a week—also producing a revenue-forecasting report for executives. The automation freed staff time (about 50 hours saved per year on monthly reports alone), improved communication and accountability, and delivered new business intelligence that measurably boosted productivity and customer service for Air Force One.

Air Force One

Christa Anderson

Accounting Manager