MS Access Auction Management System

The Client Request

This heavy equipment auction broker was buying and selling millions of dollars of heavy construction equipment all over the United States.  The equipment was bought and sold with online as well as in-person auctions.  Tracking and documenting each and every step in the purchase, sale, and delivery process was key to their business thriving.  Finally, the detailed Auction Management System developed using Microsoft Access that was required needed integration into their existing systems as well as have a minimal curve of learning on their staff.

 

Project Requirements
  • Record / Track / Calculate Sales, Interest accrual, profit margins, and auction details
  • Provide Geo-Location for Equipment
  • Integrate Accounting Reports
  • Schedule Equipment Movements & Deliveries

The Challenge

PCG’s job was to create a viable software program that could not only track the auctioned equipment but also provide geographic tracking of the equipment, costs, and finally, integration into the existing legacy systems.  Streamlining the solution, ensuring easy training and a smooth transition for the company and its employees was essential for the final package and deployment of their Auction Management System.

 
Languages / Database

The Phoenix Solution

Phoenix Consultants Group

Phoenix Consultants Group was able to quickly develop and implement the Auction Management System in just a few weeks that handled and documented all aspects of their auction process.  The solution tracked every piece of equipment, increased the billable requirements, and eventually helped the company streamline moving equipment after an auction which included a geo-location tracking system.

With its extensive experience in MS Access and Visual Basic for Applications (VBA), Phoenix Consultants Group was able to distribute their application to a central location in California, its client’s satellite offices throughout the Western United States and Canada, successfully integrating communications and tracking capabilities at all locations.

Company Size

Small Business