Penerapan Visual Basic for Application Untuk Pembuatan Database Motherpart Supplier
DOI:
https://doi.org/10.25170/jpk.v2i03.6773Keywords:
VBA, Motherpart database, supplier, accuracy, efficiency, automationAbstract
This study aims to implement Visual Basic for Applications (VBA) in the creation of a supplier Motherpart database, with a focus on simplifying and accelerating the process while improving the accuracy of the database. Previously, the creation and updating of a database containing 130,000 supplier items required 4 to 5 hours for each Motherpart. This process was time-consuming and prone to human error, reducing efficiency. By utilizing VBA, the process was automated, significantly reducing the time required. The results show that with the implementation of VBA, the creation and updating of the Motherpart database can now be completed in just 3 minutes per item, compared to the previous 4-5 hours. The application of VBA also successfully reduced time waste, improved efficiency, and ensured greater data accuracy. Therefore, this research demonstrates that using VBA as an automation tool can have a positive impact on supplier database management, providing a more efficient and accurate solution for maintaining ever-changing data.
References
Hossain, M. I., & Sultana, S. (2019). Automation in database management systems using VBA. International Journal of Computer Applications, 178(1), 15–21.
Dufresne, A., & Walker, M. (2015). Enhancing process efficiency through automation: A case study of Visual Basic for Applications (VBA) in database management. Journal of Software Engineering and Applications, 8(7), 371–380.
James, S., & Lam, L. (2017). Improving operational efficiency in large-scale data processing using VBA macros: A case study. Journal of Business Research, 28(2), 55–64.
Chandra, P., & Gupta, A. (2020). A study on the role of automation in reducing human errors in database management. International Journal of Data Engineering, 22(4), 105–113.
Anggraini, D., & Rachmawati, L. (2018). Penggunaan VBA untuk otomatisasi proses pengelolaan database dalam meningkatkan efisiensi kerja. Jurnal Sistem Informasi Indonesia, 15(3), 120–129.
Hidayat, R., & Mahendra, R. (2017). Pengembangan sistem informasi berbasis VBA untuk pengelolaan data inventaris. Jurnal Teknologi Informasi dan Komunikasi Indonesia, 6(2), 87–98.
Smith, R., & Brown, M. (2014). Enhancing accuracy and reducing time in database updates using automated macros in VBA. Journal of Database Management Systems, 21(3), 94–106.
Sung, H., Lee, S., & Park, J. (2019). Optimizing data management in manufacturing with automation tools. International Journal of Industrial Engineering, 35(1), 45-58.
Liu, T., Zhang, Y., & Wu, H. (2020). Utilizing VBA for data management automation in large-scale databases. Journal of Information Technology and Automation, 29(3), 120-132.
Bourgeois, P., & Jean, L. (2018). Optimizing automation tools for large data sets in business environments. Journal of Business Process Automation, 14(4), 234-248.
Jiang, H., & Lee, W. (2021). Successful integration of automation systems in existing business operations. Journal of Systems Integration, 41(2), 56-69.
Lin, C., Yang, K., & Wang, T. (2020). Training strategies for enhancing automation system usage and efficiency. Journal of Human-Computer Interaction, 22(3), 188-202.
Wang, X., & Zhang, L. (2019). Cycle time evaluation of automated data management in business operations. Automation and Data Processing Journal, 11(2), 77-90.
Nguyen, P., Hoang, S., & Tran, L. (2022). Efficiency improvements in data processing with VBA automation. International Journal of Information Systems, 18(3), 101-114.
