Microsoft Access Database Migration

Effect of rapid technological developments have contributed so as to provide an opportunity to study and analyze a problem. In the company of PT. Cipta Mandiri Agung Jaya, employee contract renewal process is done in less efficient. In general, the process of employee contract extension is carried out by way of division form a contract extension, has not made an assessment atupun evaluation of each employee. Through employee contract renewal process conducted so far gives a great influence to the advancement of the company. On this occasion, in view of the managerial aspects of the formulation of the problem is how to implement the SAW method in the determination of employee contract extension. How to implement a decision support system in the determination of contract extensions employees at PT. Court Of Human Self Jaya, how to design decision support systems in the SAW method using the employee contract extension programming language VB 2010 and the Microsoft Access database. The purpose was to analyze the issue formulation SAW method in the determination of employee contract extension, implementing a decision support system in the determination of contract extensions employees at PT. Court Of Human Self Jaya, pendukunng system design decisions in the SAW method using the employee contract extension programming language VB 2010 and the Microsoft Access database.

Download Full-text

QUERY BY EXAMPLE: ALTERNATIF AUDIT TOOLS UNTUK MENUNJANG PENUGASAN AUDITOR DALAM PENGUJIAN SUBSTANTIF

Media Riset Akuntansi Auditing & Informasi ◽

10.25105/mraai.v8i2.976 ◽

2008 ◽

Vol 8 (2) ◽

pp. 117

Author(s):

Oviliani Yenty Yuliana ◽

Josua Tarigan

Keyword(s):

Information Technology ◽

Key Words ◽

Preliminary Survey ◽

Query By Example ◽

Microsoft Access ◽

Access Database ◽

Public Accountants ◽

It Audit ◽

Business Sectors

Along with the growth of the information technology (IT), several audit tools are developed to help the auditorto do theirduties efficiently and effectively. ACL and IDEA are the popularexamples of the audit tools nowadays. However; for small and medium public accountants (KAP) and aUsaha Kecil Menengahn (UKM) business sectors, ACL and IDEA audit tools pricing are very expensive. Moreover, based on preliminary survey, many companies have already recorded theirtransactions into a database. It motivates a study to optimize the database features that has been owned by KAP and UKM as audit tools. Therefore the companies can reduce theirinvestment. In this paper, researchers propose the use of 'Query By Example" (QBE) in Microsoft Access database as the audit tools. QBE is expected as one of alternative of audit tools that can assist auditor task, especially in substantive test.Key words : Information Technology (IT), audit tools, Query By Example (QBE)

Download Full-text

Patterns of Racing and Career Duration of Racing Greyhounds in New Zealand

Animals ◽

10.3390/ani10050796 ◽

2020 ◽

Vol 10 (5) ◽

pp. 796

Author(s):

Anna L. Palmer ◽

Charlotte F. Bolwell ◽

Kevin J. Stafford ◽

Arnon Gal ◽

Chris W. Rogers

Keyword(s):

New Zealand ◽

Median Number ◽

Electronic Records ◽

Public Concern ◽

Inter Quartile Range ◽

Microsoft Access ◽

Career Length ◽

Quartile Range ◽

Access Database

The welfare and wastage of racing greyhounds is a topic of public concern. Little is published about the racing patterns of these dogs in New Zealand. The aim of this study is to describe the pattern of greyhound racing in New Zealand. Data on all race starts between 1 August 2011 and 25 March 2018 were supplied by Greyhound Racing New Zealand. A cohort was created containing dogs that had a racing career between 1 August 2013 and 31 July 2017. Data were collated within a customized Microsoft Access database from electronic records of all racing starts for every dog within the 2013–2016 racing seasons. For this cohort of racing dogs, there were 97,973 race starts across 22,277 races involving 2393 individual greyhounds. The median number of days between racing starts was 7 days (inter-quartile range (IQR): 4–10 days). The median career length was 424 days (IQR: 206–647 days) and the median number of racing starts throughout a racing career was 35 (IQR: 16–59 starts). Dogs of similar ability finished their career at a similar age.

Download Full-text

Using SQL to Develop Database Query Proficiency: A Follow-Up Note to Borthick, Jones, and Kim (2001)

Journal of Information Systems ◽

10.2308/jis.2006.20.1.117 ◽

2006 ◽

Vol 20 (1) ◽

pp. 117-137

Author(s):

Alan I. Blankley

Keyword(s):

Information Systems ◽

Customer Service ◽

Database Query ◽

Microsoft Access ◽

Automobile Manufacturer ◽

Access Database

In the Spring 2001 issue of Journal of Information Systems (JIS), Borthick et al. (2001) presented a case in which students were to query a Microsoft Access database in order to determine the mutual assurance concerning customer service for an automobile manufacturer and its local dealer network. I follow-up this case by presenting an additional teaching note to the case that develops query strategies and solutions for the case using Oracle and its SQL application, SQL-Plus.

Download Full-text

Merchandise Hardware: A Case Designed to Teach Students Generalized Audit Software Using Microsoft Access

AIS Educator Journal ◽

10.3194/1935-8156-10.1.1 ◽

2015 ◽

Vol 10 (1) ◽

pp. 1-4

Author(s):

S. Lane Lambert

Keyword(s):

Information System ◽

Accounting Information ◽

Accounting Information System ◽

Microsoft Access ◽

Accounts Payable ◽

Software Skills ◽

External Auditor ◽

Access Database

ABSTRACT This paper provides an educational case wherein students learn how Microsoft Access (“Access”) can be used as Generalized Audit Software (“GAS”). Students export data from an Access database provided in the case that simulates a portion of the Expenditure Cycle in the Accounting Information System (“AIS”) used by the case company. Students then import the downloaded data into another Access database where Queries and a Module are used as GAS to analyze and audit the data. In the case, students assume the roles of accounts payable manager, general ledger accountant, procurement manager and internal/external auditor, thereby learning that not only auditors but also accountants and managers can use GAS. Once the students have created and executed the Access GAS procedures illustrated in the case, they are given an assignment that includes modifying a case GAS procedure, documenting GAS procedures, and recommending and implementing improvements in the case AIS based on GAS results. The case is designed to teach students general concepts for planning and performing GAS procedures and software skills in using Access as GAS. This paper is the first educational case that illustrates how Access Modules can be used as GAS.

Download Full-text

Sistem Pendukung Keputusan Untuk Menentukan Pelanggan Terbaik Pada Pizza Oei-Oei Medan Menggunakan Metode SAW

Jurnal Nasional Komputasi dan Teknologi Informasi (JNKTI) ◽

10.32672/jnkti.v4i3.2977 ◽

2021 ◽

Vol 4 (3) ◽

pp. 203-208

Author(s):

Muhammad Yusuf ◽

Hasanul Fahmi

Keyword(s):

Decision Support ◽

Decision Support System ◽

Programming Language ◽

Support System ◽

Visual Basic ◽

Standard System ◽

Microsoft Access ◽

Weight Value ◽

Access Database ◽

Simple Additive Weighting

The management of Pizza Oei-Oei Medan does not yet have a standard system in determining the best customer.m So far, this has been done randomly and without a structure in determining the best customer. Not fair to other customers. It takes a decision support system to determine the best customers who can make decisions from various alternatives and existing criteria in determining the best customers fairly. The method used is SAW (Simple Additive Weighting). SAW is a method that can determine the weight value for each attribute, then proceed with a ranking process that will select the best alternative from a number of alternatives. SAW method can be implemented to find out the best customers based on the criteria and weights that are determined correctly. This research is to determine the best customers at Pizza Oei-Oei Medan. The system is built with Visual Basic Studio programming language with Microsoft Access database.

Download Full-text