Microsoft Office Access Research Articles

APLIKASI PENJUALAN OXYGEN PADA PT. SINAR PURNAMA SAKTI SEMARANG


 Sinar Purnama Sakti Semarang is an agent with a trading business that is engaged in the sale of Gas Oxygen (O2), Acyteline (C2H2), Carbondioxide (CO2) and Argon (Ar) experiencing problems, namely in the process of data processing sales of goods are still completely manual. This results in a good accumulation of transaction data, so that the efficiency and completeness of the data is not guaranteed. The purpose of this paper is to create an application that can help process data quickly and efficiently at PT. Sinar Purnama Sakti Semarang. This sales application is very helpful for users. With the new system in the sales application, it will make it easier to process data and make sales reports. In addition, PT. Sinar Purnama Sakti Semarang can also provide proof of payment in the form of a note. Performance of PT. Sinar Purnama Sakti Semarang becomes faster and more efficient after the sales application. So to simplify the sales information system is done with a computerized system. There are several programs that can be used in processing sales applications, one of which is the Visual Basic 6.0 program. Microsoft Visual Basic 6.0 is one of the most popular programs used in programming. Many people have used it and many people already know it. As for storage, the author uses Microsoft Office Access. Based on the description above, the authors take the title in accordance with the need for data processing information in PT. Sinar Purnama Sakti Semarang.

Designed and Implemented a Computer Based Payroll System for Local Government Area

Guyuk local Government operates manually, and as a result, it leads to a waste of resources as well as time consumption. Therefore, there is a need to computerize the payroll system. Payroll is an accounting term that focuses on the activities and computation of staff salaries within the local Government; however, this has been a long-time problem that the local Government faces. Looking at the complexity of activities involved in salary preparation, computers will go a long way to solve and reduce some of the stress and problems that are characterised by manual exercise. Technology has made the world a village where boundaries do not affect social and business dealings. This revolution has not left Guyuk’s local Government behind. Against this background, this study tries to reveal the potentiality of a computer-based payroll system. This system is built to manage the database of the local government staff and pay their monthly salaries on time. The payroll system is designed using the Microsoft Office Access database. Primary and secondary data is driven through observation and personal interaction with the officers using the then manual system. The local Government is under Adamawa state, northeast of Nigeria. It is recommended that the entered system be implemented to reduce the time wasted and corruption in the system.

The Innovation of Information and Communication Technology in Contextual Teaching and Learning Models Based PAI Learning

The integration of technology in the era of the Fourth Industrial Revolution has become essential in various aspects of human life, including education. This study aims to explore the implementation of technology-based Islamic Religious Education learning at MAN 1 Lamongan in response to the challenges and demands of the digital era. The method used in this study involves analyzing teaching materials, interviewing Quran and Hadith teachers, and students from Madrasah Aliyah Negeri 1 Lamongan, as well as observing classroom learning. The implementation of ICT-based learning in the Contextual Learning and Teaching model consists of two stages: the design stage and the implementation stage conducted by the teachers. The implementation stage is further divided into three phases: (a) opening, which involves delivering and teaching Islamic Education knowledge materials; (b) implementation, where students engage in group projects to connect the material with real-world events and their own experiences; and (c) closing, which includes reflection and evaluation of the learning process related to the studied material. Throughout the learning process, students are given the freedom and support to utilize technology, including laptops/smartphones and software applications such as Google Chrome, Microsoft Office, YouTube, WhatsApp, and free Wi-Fi access, to facilitate their learning. The study results indicate that using ICT-based learning media for Al-qur’an Hadith in this model has successfully increased students' interest in learning, enhanced their critical thinking skills, and fostered their creative competence in understanding and processing information and knowledge collaboratively.

Perancangan Sistem Microsoft Office Access pada Toko Batam Sumber Indah

Financial reports are a source of information that stakeholders use to make decisions regarding controlling company operational costs, understanding company profits and losses, understanding debts and liabilities, and calculating taxes. As financial reports also play an important role in Micro Small and Medium Enterprises sector, there are still many Micro Small and Medium Enterprises sector that have not prepared financial reports or have prepared them in the middle of difficulties and complications. This community service activity is carried out using survey and interview methods. After finding the obstacles faced by Batam Sumber Indah Store, the solution was to design an accounting system information in the form of Microsoft Office Access. The results of this activity are expected to increase the efficiency and effectiveness of the Batam Sumber Indah Store in producing reliable financial reports.

Digitization of Archives at Café Ganesha Mocktail Bandung

This research aims to develop a digital filing system at the Ganesha Mocktail café in Bandung, West Java. This is intended to improve the existing archive storage system at the Ganesha Mocktail café so that the documents that are owned are stored properly. This type of research and development uses a Research and Development (RnD) design developed using the SDLC (System Development Life Cycle) model. The research stages start from system planning, system analysis, system design/development, to system implementation. This research produces a digital archive information system application for Café Ganesha Mocktail based on Microsoft Office Access. Through this application, Café Ganesha Mocktail can store files safely and easily find the documents needed.

Contribution to the Ethnobotanical Knowledge of Serre Calabre (Southern Italy)

This work presents the results of an ethnobotanical research carried out in the territory of Serre Calabre, province of Vibo Valentia (Calabria, southern Italy). In this territory, the bond between the residents and the rural environment is still strong, the small urban centers are placed in a predominantly agricultural and forestry environment still managed in a traditional way. The survey took place between January 2019 and July 2021. The data were collected through semi-structured interviews with locals. The samples of plants were collected under the indication of the interviewees and then deposited at the herbarium of the Mediterranean University of Reggio Calabria (REGGIO). The data were stored on a database, using the software "Microsoft Office Ac-cess" ®. The information was then analyzed statistically with the software "Microsoft Office Ex-cel”®. Some synthetic indexes have also been calculated, such as Relative Frequency of Citation (RFC) and the Cultural Importance Index (CI). 17 informants were interviewed and a total of 185 interviews were recorded. This led to the identification of 84 taxa belonging to 39 different fami-lies, among which the most represented are Lamiaceae (23 interviews, 9 taxa), Asteraceae (22 in-terviews, 12 taxa). Among the identified taxa, the prevalent uses are the alimentary one (46 in-terviews, 32 taxa) and the medicinal one (55, 27). The results obtained show how the traditional knowledge about plants in the Serre Calabre area is still alive, however it is exclusive heritage of elderly people and often only in one or just a few informants. Many practices are no longer in use and transmitted to the new generations.

The design of expert system to determine the university majoring based on multiple intelligence using forward chaining method

An expert system is one of artificial intelligence that uses a computer to work like and as well as humans do. An expert system is a computer system that is designed so that it has the ability and reasoning like an expert. But, the expert system is not used for replacing an expert who in this problem im a psychologist as a consultant for students want to recognize the potential and their abilities. The expert system is only used as equipment and limited tools. There is a problem is how to design tools to help students recognize their potential and abilities, so that they can choose the right department in the University based on their potential and abilities. Expert system design for assign department in the University based Multiple Intelligence use visual basic programming language and Microsoft Office Access as database.

Prototype Application for Data Processing Teacher Performance Assessment at Christian Elementary School Imanuel Nunu

The Performance every employee appraisal is a method used to assess the work performance of an employee whether he or she has achieved the work target assigned.Teacher performance appraisal at Imanuel Nunu Christian Elementary School is currently still being carried out manually in the sense that the preparation of employee performance appraisal reports still uses word processing applications (Microsoft word and excel) resulting in inefficient and ineffective time and a greater risk of data loss. The purpose that the authors take from this research is to build a Data Processing Application for Teacher Performance Assessment at Imanuel Nunu Christian Elementary School using computerized visual basic 6.0. The Teacher Performance Assessment that was made was a Data Processing Application for Teacher Performance Assessment at Imanuel Nunu Christian Elementary School by using the Visual Basic 6.0 programming language and Microsoft Office Access as databases. The results obtained are a prototype of the teacher performance assessment report at the Imanuel Nunu Christian Elementary School

RANCANG BANGUN SISTEM INFORMASI RETENSI REKAM MEDIS DI RSIA X

This study aimed to design and create an outpatient medical record retention information system at The X Hospital. The results of research conducted, found several problems faced by the health center. It’s hard to find active and inactive medical record data, so the medical record data that are retained or inactive is unknown. The research method used is a qualitative approach that is supported by data collection techniques, using observation, interviews, and library research. The development method used is the waterfall method assisted by the design of Data Flow Diagrams. This system is based on a desktop that uses Microsoft Visual Studio 2010 as a programming language and uses the Microsoft Office Access 2013 database. Based on the problems above, the writer tries to give some suggestions, including (1) the Need development of information systems technology that the author will design. (2) Integration of health information systems to obtain efficient and effective performance.

Asset Management Information System at The Health Service of Aceh Province

As an effort to manage assets at the Aceh Provincial Health Office, an information system is needed that can handle problems in asset data collection. This research stage consists of; literature study, data collection, system analysis, system development, and report generation. Furthermore, in the development of the system used is the waterfall method or better known as the waterfall method. The design of the asset management information system software at the Aceh Provincial Office which the author designed consists of several stages, namely input design, output design, process design, control design, labor design, and cost design. The results of this study are an asset management information system built with Visual BASIC and Microsoft Office Access as databases. The conclusion that can be obtained from the analysis and design of the Asset Management Information System is that the information system will later be used to process asset data at the Aceh Health Office, namely adding, editing, searching for asset data. This system will also be equipped with displaying reports such as asset data reports and others. This application can be used as an alternative tool for processing asset data at the Aceh Health Office.

PERANCANGAN SISTEM INFORMASI PENDAFTARAN PASIEN RAWAT JALAN MENGGUNAKAN MICROSOFT VISUAL STUDIO 2010 DI PUSKESMAS CIJAGRA LAMA KOTA BANDUNG

This study aims to determine the design of an outpatient registration information system using Microsoft Visual Studio 2010 at the Cijagra Lama Public Health Center, Bandung City. The research method used is a qualitative approach supported by data collection techniques by means of observation, interviews, literature studies and internet studies. The development method used is the waterfall method which is assisted by the design of Data Flow Diagrams. This system is made on a desktop basis that uses Microsoft Visual Studio 2010 as a programming language and uses the Microsoft Office Access 2013 database. The problem that often occurs is the length of registration is closely related to the service process because the registration system is often problematic so that it hampers the registration process. design. ( 2 ) Integration of health information systems in order to obtain efficient and effective performance. (3) consider and redevelop the information system for each medical record data processing activity.
 Keywords: System Design, Information Systems, Registration, Outpatient

Prospects for the use of IT for the selection and assessment of suppliers of materials and components

The purpose of this work is to use information technology to help management decisions. The crux of the problem is the choice of suppliers of materials and components for mechanical engineering companies. Periodically, in the procurement process, suppliers should be assessed on a number of criteria. The importance of rating is due to the fact that in today's market there are a large number of suppliers of the same material resources. Purchase is made from the most competitive suppliers, constantly confirming their status as a reliable business partner. The company developed a method of evaluating suppliers based on the system of management of the bases of the bath Microsoft Office Access. MS Access works in the Windows operating environment and allows users to organize a local database (DB). The local Access database has its own tables, forms, reports and other DB facilities of the organization with a relatively small amount of data. With the help of the scoring method, suppliers are ranked by their level of reliability. The relationship is terminated with a supplier that does not meet the required level of reliability. In this way, management solutions for logistics of supply receive a tool to hang the efficiency and get good results of the enterprise, to achieve its market stability.

Development of a Database of Coagulazonrgative Staphylococcus Strains, Circulating in Hospitals of Different Profiles

Object of development: database «Strains of coagulase-negative staphylococcus, persisting in hospitals of different profile».The purpose of the study: inclusion of modern information technologies in the system of epidemiological surveillance and monitoring of infections caused by ecovars of coagulasenegative staphylococcus circulating in Nizhny Novgorod. Methodology: source data was converted into a set of related tables and organized into a hierarchical two-tier database. The database contains information about 1045 strains, circulated in hospitals of different profile of Nizhny Novgorod. To form a sample describing of clinical, epidemiological and phenotypic characteristics of strains requests are made. As a result of the query, a table is formed, where each line corresponds to one strain and contains information about the date, source and location of the recovery, the phenotype of antibiotic and phage resistance, the presence of the mecA gene, as well as sensitivity to different classes of disinfectants and the ability to form biofilm. The database is refillable. It was created using Microsoft Office Access with a standard application package. The database includes 17 queries and 14 tables. Type of implementing computer: IBM PC-compatible PC. View and version of the database management system: Access 2002 and later. Operating system version: Windows 7 and later. The developed database allows searching and processing of epidemiologically significant information about strains of coagulaze-negative staphylococcus.The application of the database is to improve the microbiological monitoring system in epidemiological surveillance of healthcare-associated infections.

Sistem Informasi Pencatatan Data Pelanggan pada Telkomsel Grapari Banda Aceh

The purpose of the research is to; 1) Generating a customer information system on Telkomsel GraPARI Banda Aceh, 2) To find out the application of the information system that has been built, and 3) Apply the system that was built using Visual Basic. This research was conducted at Telkomsel GraPARI Banda Aceh and conducted for 9 (nine) months of 2015-2016. The method used for system development, researchers use the methodology Rapid application development (RAD) and Data Flow Diagrams (DAD). This research has succeeded and completed the design of information systems for recording customer data at Telkomsel Grapari Banda Aceh, the application was built using the stages of the Rapid application development (RAD) model. The application was built using Visual BASIC and as a database using Microsoft Office Access. The application of the information system that has been built is still in the prototype and there is still a need for study and development of current technologies such as the use of mobile and cloud databases involving interconnection to make it easier for GraPARI units to connect.Keywords:Information Systems, Customer Data, Telkomsel

Sistem Informasi Pengarsipan Sertifikat Tanah pada Badan Pertanahan Nasional Aceh Besar

The design of the land certificate filing system was built to facilitate the work process in managing land certificate records, especially in the field of archives at the Aceh Besar National Land Agency, which is intended to streamline computerized data processing to support technical implementation in carrying out more accurate land certificate data processing, effective and efficient. A land certificate is a tool or means to convey statements or information in writing from one party to another party. Such information can be in the form of notifications, statements, requests, reports, objections, thoughts, questions, and so on. The design of the system used by the Rapid Application Development (RAD) method, a software development process model classified as incremental (multilevel) techniques. Applications used for making applications are Microsoft Visual Basic .NET as interface design and Microsoft Office Access as a DBMS. The test results of this application are the systems that are built already meet the needs, the input data process has met the needs and the resulting report has met the needs.Keywords:Land Certificate Filing System, Information System, Visual Basic .NET

Sistem Informasi Aplikasi Penyusunan Sasaran Kerja Pegawai (SKP) pada Kanwil Kementerian Hukum dan Ham Aceh

The design of the Information Systems Application System for Employee Work Target Compilation (SKP) is based on the method of evaluating civil servant work performance systematically combining the Civil Service Employee Work Target assessment with work behavior assessment. Performance appraisal consists of two elements, namely SKP and Work Behavior, with an assessment weighting of SKP elements at 60% and work behavior at 40%. From the depiction of the service mechanism at the KEMKUMHAM Aceh, an integrated information system is needed to assemble the existing subsystems into a mutually supportive unit given the still not optimal role of the computerized system in the existing service mechanism. The purpose of this study was to design an Information System for Employee Job Target Compilation (SKP) Application at the Regional Office of the Ministry of Law and Ham Aceh using Visual BASIC.NET. The design of the system used by the Rapid Application Development (RAD) method, a software development process model classified as incremental (multilevel) techniques. RAD emphasizes short, short, and fast development cycles, and data collection techniques using research methods by observation, interview, and literature study. The tools used are Microsoft Visual Basic .NET as an application in interface design and Microsoft Office Access as a DBMS. The test results of this application are the systems that are built already meet the needs, the input data process has met the needs and the resulting report has met the needs.Keywords:Information Systems, SKP, Visual Basic .NET.

Perancangan Sistem Informasi Pengarsipan Dokumen pada Mahkamah Syar’iyah Kota Banda Aceh

At the Syar'iyah Court of Banda Aceh City, the archiving information system within the agency could be said to be inefficient because there were still many conventional filing information systems applied, namely storing in filing cabinets, and recording to books so that accuracy could still be said to be unfavorable. When viewed in terms of space, it requires an inventory of places for equipment such as filing cabinets, maps, shelves, and others. While in terms of time, the search for the arrangement of documents that are not neat. In terms of cost, the need for care and maintenance of archive storage. The formulation of the problems in this study can be formulated; Designing the Document Filing Information System at the Banda Aceh Syar'iyah Court, Is the Banda Aceh City Syar'iyah Court Filing Information System the information used will be faster and more accurate, and How to present the Syar'iyah Court Document Filing Information System. The method used in designing the NET Document Filing Information System at the Banda Aceh Syar'iyah Court is to use the waterfall method or the waterfall method. Data collection techniques using research methods by observation, interview, and literature study. The tools used are Microsoft Visual Basic .NET as an application in interface design and Microsoft Office Access as a DBMS. The test results of this application are the systems that are built already meet the needs, the input data process has met the needs and the resulting report has met the needs.Keywords:Information Systems, Filing, Documents, Visual Basic.NET

SISTEM PENDUKUNG KEPUTUSAN KENAIKAN PANGKAT DI SMA NEGERI 1 LEMBANG JAYA KABUPATEN SOLOK MENGGUNAKAN METODE PROFILE MATCHING

SMA Negeri 1 Lembang Jaya is one of the schools located in Solok Regency and at the moment the promotion process for honorary teachers is still using the manual system , so it requires a long time to fill in the promotion data. Therefore, SMA Negeri 1 Lembang Jaya needs a new system to make it easier to fill data to make it more effective and efficient. Decision support systems using the Profile Matching method are designed to assist decision making in problems solving that are semi-structured or unstructured . This decision support system was built using the Visual Basic 6.0 programming language, Microsoft Office Access as a support for data storage media, and Crystal Report. With this decision support system, it is easier for schools to make promotions for honorary teachers.The Profile Matching method will provide more accurate information for promotions by rating according to established criteria.

P-Cash App Based on Microsoft Office Access to Improve Learning Outcomes of Vocational High School Students

The development of the world of work in the current era of computerization is developing so fast, that in office activities begin to apply technology to its work activities. So that vocational students who are prepared to enter the workforce must also follow this development. This study aims to produce a App based on Microsoft Office Access on learning material for managing petty cash funds. App is an alternative learning by utilizing technology development to achieve learning objectives. In the development of this App, research and development (R&D) is carried out using the Borg & Gall model. These steps include Potential and Problems, Data Collection, Product Design, Design Validation, Design Revision, Product Trial, Product Revision, Usage Trial, Product Revision, and Final Product. Based on the results of the validation of the material experts, media experts, as well as small group trials shows that the learning media application manager for cash fund based on microsoft office access is very feasible to use in the learning process. This product is effectively used in learning based on the results of the posttest in the experimental class which shows a higher score when compared to the control class. Therefore, teachers of subjects in Automation and Financial Governance are advised to use this media as an alternative support for learning. How to Cite this Article Pubmed Style Madziatul Churiyah, Dewi Ayu Sakdiyyah. App Based on Microsoft Office Access to Improve Learning Outcomes of Vocational High School SRP. 2020; 11(7): 499-506. doi:10.31838/srp.2020.7.73 Web Style Madziatul Churiyah, Dewi Ayu Sakdiyyah. App Based on Microsoft Office Access to Improve Learning Outcomes of Vocational High School http://www.sysrevpharm.org/?mno=138657 [Access: March 28, 2021]. doi:10.31838/srp.2020.7.73 AMA (American Medical Association) Style Madziatul Churiyah, Dewi Ayu Sakdiyyah. App Based on Microsoft Office Access to Improve Learning Outcomes of Vocational High School SRP. 2020; 11(7): 499-506. doi:10.31838/srp.2020.7.73 Vancouver/ICMJE Style Madziatul Churiyah, Dewi Ayu Sakdiyyah. App Based on Microsoft Office Access to Improve Learning Outcomes of Vocational High School SRP. (2020), [cited March 28, 2021]; 11(7): 499-506. doi:10.31838/srp.2020.7.73 Harvard Style Madziatul Churiyah, Dewi Ayu Sakdiyyah (2020) App Based on Microsoft Office Access to Improve Learning Outcomes of Vocational High School SRP, 11 (7), 499-506. doi:10.31838/srp.2020.7.73 Turabian Style Madziatul Churiyah, Dewi Ayu Sakdiyyah. 2020. App Based on Microsoft Office Access to Improve Learning Outcomes of Vocational High School Systematic Reviews in Pharmacy, 11 (7), 499-506. doi:10.31838/srp.2020.7.73 Chicago Style Madziatul Churiyah, Dewi Ayu Sakdiyyah. P-Cash App Based on Microsoft Office Access to Improve Learning Outcomes of Vocational High School Students. Systematic Reviews in Pharmacy 11 (2020), 499-506. doi:10.31838/srp.2020.7.73 MLA (The Modern Language Association) Style Madziatul Churiyah, Dewi Ayu Sakdiyyah. P-Cash App Based on Microsoft Office Access to Improve Learning Outcomes of Vocational High School Students. Systematic Reviews in Pharmacy 11.7 (2020), 499-506. Print. doi:10.31838/srp.2020.7.73 APA (American Psychological Association) Style Madziatul Churiyah, Dewi Ayu Sakdiyyah (2020) App Based on Microsoft Office Access to Improve Learning Outcomes of Vocational High School Systematic Reviews in Pharmacy, 11 (7), 499-506. doi:10.31838/srp.2020.7.73

Features of Perceptoin of the City of Kharkiv by Young Students (by Survey Materaials)

The article considers the results of the survey among students of V.N. Karazin Kharkiv National University within the framework of the project «Practices of self-presentation of the city in the industrial and post-industrial era». 202 students from School of History, School of Philology, School of Mathematics and Computer Sciences were interviewed. Respondents answered a special questionnaire with 12 «closed» and «open» questions. The «closed» questions allowed to determine the quantitative indicators of the Kharkiv young people preferences regarding objects, structures, enterprises, institutions, monuments, products, songs which, according to the students, present the «face» of city. In the same time the «open» questions gave respondents the opportunity to offer a particular option, to express their views on any issue. Relational database management system (RDBMS) program Microsoft Office Access 2013 was built to analyze the survey results. Unified responses of survey participants were entered into the RDBMS. Interpretation of the results was based on the lifestyle concept of a French sociologist P. Bourdieu and the theories of lifestyles of the German historian M. Dinges. In particular, objects, structures, enterprises, institutions, monuments, products, songs representing the “face” of Kharkiv were identified through a questionnaire. The article reveals the peculiarities of Kharkiv symbolic image among young people. The results also allowed to establish architectural dominants, landmarks and lacunae of urban space. Finally, the youth identified historical figures who, in their opinion, form a pantheon of prominent natives and residents of the city. The materials of the survey show the features of self-presentation of the city and the interaction/ interinfluence of residents and urban space.