Claim Missing Document
Check
Articles

Found 3 Documents
Search
Journal : Records Management System Journal

MAKING APPLICATIONS FOR ARCHIVING INCOMING AND OUTGOING LETTERS AT PT FELIXINDO JAYA PERKASA BASE ON VBA EXCEL Rizki Mario Armando Saragih; Mohammad Rizal Gaffar
Records Management System Journal Vol. 2 No. 1 (2023): Vol. 2 No.1 Tahun 2023
Publisher : Ebiz Prima Nusa

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

Information regarding incoming and outgoing mail is very important for companies to make decisions on the work being carried out, mistakes often occur when searching for archival data because the filing system is not detailed and irregular, therefore changes need to be made to the filing system so that it can manage data and information according to company needs. PT Felixindo Jaya Perkasa has an electronic filing system in the form of a sheet in Microsoft Excel, but the electronic archive does not include complete information so that the process of searching for archival data is not effective and efficient. Changes to the filing system are made with consideration of the effectiveness and efficiency of using the system, Visual Basic Application/VBA in Microsoft Excel can be used as a basis for making new filing system applications. VBA works with the Microsoft Excel program language which is then compiled into a company filing system application, the application is used to input incoming and outgoing mail data, and search for and delete data on company system applications so that the use of the filing system can be more effective and efficient.
The making of storage application for electronic official document based on microsoft access at document unit pt kai (persero) daop 2 bandung Rena Puspitasari; Mohammad Rizal Gaffar
Records Management System Journal Vol. 2 No. 02 (2024): RMSJ Vol.2 No.2 2024
Publisher : Ebiz Prima Nusa

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

The document unit of PT KAI (Persero) Daop 2 Bandung has tasks and functions in managing company documents. One of the document management activities is storage. The file storage is inefficient because it is not stored centrally, and searching in the file explorer can only be done based on the document file name, resulting in a lengthy search process. To help overcome this issue, a Microsoft Access-based official document storage application has been developed. In addition to serving as a centralized storage location, this application also facilitates quick searches, generates reports based on document types, and includes applicant data forms. The application was developed using the waterfall method, which involved requirement analysis, design, development, testing, and implementation stages. The Microsoft Access-based official document storage application has an attractive interface, is user-friendly, has fast response times, includes a security system, and most importantly, can store document data centrally within a single application. Further development may involve adding additional features.
Design of incoming and outgoing letter applications based on microsoft access at pt pos indonesia (persero) Tarissa Aulia Dwi Putri; Mohammad Rizal Gaffar
Records Management System Journal Vol. 2 No. 02 (2024): RMSJ Vol.2 No.2 2024
Publisher : Ebiz Prima Nusa

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

Pos Indonesia is a State-Owned Enterprise (BUMN) that takes part in courier services, logistics, and financial transactions that make PT Pos Indonesia (Persero). The output of the Electronic Service Note (NDE) digital application used today has not met the needs of weekly and monthly reporting, the digital application used has not been grouped based on the needs of weekly and monthly reports at PT Pos Indonesia (Persero). There are still ambiguous names of senders and recipients of letters because the old position account and the new position account are not directly grouped according to the position but still use the name of the old and new account owner due to the transfer of the account owner to the new position. This makes this project a follow-up application of that output to manage Reports. The design and creation of this Microsoft Access-based information system is intended to assist the Administrative Governance Section in managing Incoming Outgoing Mail Reports. The result of this project is the creation of an incoming and outgoing mail database tool that is more effective and efficient in making weekly or monthly reporting that has been tested to users. From the results of the trial, it shows that this tool is considered very good and as needed in making weekly or monthly reporting because it is enough to import existing mail data in the NDE without the need to classify letters one by one because this tool created a database whose job is to classify letters automatically and the use of incoming and outgoing mail queries, Union queries, and crosstab queries whose job is to generate weekly or monthly reports. The results of the trial also showed that there were no obstacles in using these tools. Keywords: Microsoft Access, Database, NDE, Weekly and Monthly Reporting