Enhanced Access Database – A Logistics Provider
Industry: Transportation & Logistics
Solution: Enhanced Access Database
Technologies: Microsoft Access
Solution Type: Custom Database Application
The company based in DeKalb, IL has been in business for over 20 years and is a full service logistics provider. The company is a full service logistics provider. The company prides itself in lowering the cost of managing inventory for their clients while providing exceptional service, dependability, and innovation in logistics.
The company was using a Microsoft Access database to coordinate the pallet logistics for a major US corporation. Excel files that contained pallet activity was manually being copied into the database which became very time consuming and decreased productivity.
In addition, the client began to use a different pallet identification system. Since the database was not capable of handling the new system of pallet IDs, the company had to manually manage the pallet activity using the new IDs. As a result, some of the client’s pallets were processed one way and other pallets were processed a different way. This resulted in inefficiencies in client management and reporting.
Pallets get moved to different locations throughout their lifetime. The database did not track the pallet movement history which would be beneficial for tracking pallet lifecycle activity.
The Microsoft Access database was enhanced to track all of their client’s pallets in one system, while providing activity history for each pallet. In addition, the import of Excel files containing pallet activity was automated to help streamline their process. The automating of manual processes saves the staff a considerable amount of time in their daily operations.
Automating the Import of Pallet Activity
Enhanced functionality was developed to import different types of pallet activity data. Users can now browse and select an Excel file and have the database automatically import the data. This saves the company a considerable amount of time.
Handling the New Pallet ID System
The database was updated to handle the new pallet ID system. All forms, reports, and code were analyzed and several updates to the database logic were made. The automation of processing the new pallet IDs saves the company hours of manual processing and guarantees the accuracy of the pallet information.
Tracking Pallet History
The database was updated to track pallet history. Whenever a pallet is moved, its previous location is now recorded. This enables the company to run a report on a specific pallet and review its lifecycle of location activity. The solution provided by alligatortek will allow the company to easily analyze its operations and identify areas for improvement.