Web systematization of the "International Logistics Division Customer Performance Management System" used at multiple locations in MS-Access in a short period and at low cost.
【System Considerations】 At Ichinomiya Transport, there was an urgent need to establish a system specialized in international logistics and customs operations in response to the expanding business demands. 【Requirements for the New System】 The following requirements were necessary: - The ability to develop, maintain, and support the system continuously in a short period. - The capability to realize a stable system that can be used across multiple locations connected via VPN in a short time and at low cost. - The system must be equipped with internal control functions. 【Adoption of dbSheetClient】 In the search for tools capable of system development, we found dbSheetClient. - It allows for flexible and rapid development in response to user requests by leveraging existing Access assets. - Continuous development and maintenance by the IT Promotion Department enables quick responses to on-site requests. - It avoids Access-specific issues during LAN sharing and has a proven track record as a stable web system even at VPN locations with limited bandwidth. - It is equipped with internal control functions such as user authentication management and log management (operation history) for monitoring. - There is a dbSheetClient support center available for inquiries.
Inquire About This Product
basic information
**[Development Form]** We summarized the system overview, input screens, and output report proposals, and then created a prototype based on the ACCESS system that is currently in operation at a related company. **[Implementation Effects]** From the perspective of the IT Promotion Department that built the system, the implementation effects are as follows: - Achieved secure WAN sharing of the ACCESS program without much modification to the user program. - Developed in a short period, and able to respond quickly and cost-effectively to additional requests for modifications after full operation. - Established a foundation for an internal control system that can be expanded company-wide in the future, such as connecting to the accounting system. - Built a monitoring system using robust security features for authentication management and log management (operation history). From the perspective of the personnel using the system, since the operation began, any issues that arise have been resolved sequentially, and the efficiency of practical work through system use has steadily increased. From the perspective of the business unit managers, it is possible to analyze based on the accumulated data of performance data for estimates, invoicing, and customs clearance operations. **[Post-Implementation]** First, we would like to improve the user level (customs brokers and sales) by organizing operation manuals and other materials.
Price range
P5
Delivery Time
Applications/Examples of results
【dbSheetClient Purpose】 ○ Model System Examples → Petty Cash Management System → Support Operations Assistance System ○ Usage Examples → PL Monitoring System → Sales Prospect Management System → Attendance Management System → KPI Management System → Employee Capability Management System → Customer Management System → Sales Performance Management System → Order Product Inquiry System → Bento Reservation and Ordering System → Construction Project Management System → IT Equipment Management System For more details, please contact us.
catalog（10）
Download All Catalogs![[Case Study] Utilizing Access for a Customer Management System for Logistics Usable Across Multiple Locations - Ichinomiya Transport Co., Ltd.](https://image.www.ipros.com/public/catalog/image_generated/01/f76/265795/265795_IPROS5024781444951525122_1.jpg?w=120&h=170)
Company information
Our headquarters is located in Saitama Prefecture, but our clients are located throughout Japan. Our CORE THEMA is "Bridge," and our logo is inspired by the concept of a "bridge." We were established with the aim of becoming a "bridge" to a hopeful future for everyone through the platform of IT, and we aspire to be a globally recognized one-of-a-kind company.