Introducing Microsoft Access Using Macro Programming Techniques

2021 ◽  
Author(s):  
Flavio Morgado
2018 ◽  
Vol 3 (1) ◽  
pp. 23
Author(s):  
Sutan Mohammad Arif ◽  
Hendro Purwoko

Sebagai penyedia layanan kesehatan bagi masyarakat, Rumah Sakit Umum Islam Madinah yang terletak di Kecamatan Kasembon, Kabupaten Malang, Jawa Timur perlu memanfaatkan teknologi komputer untuk mendukung kebutuhan pasien seperti obat dan alat kesehatan yang dikelola oleh pihak gudang. Lingkup kerja pada bagian gudang masih berskala kecil karenanya Microsoft Access yang merupakan aplikasi paket instalasi Microsoft Office menjadi pilihan yang tepat dan mudah, aplikasi ini juga dapat diterapkan pada komputer yang memiliki jaringan lokal. Pada penelitian ini, metode Waterfall digunakan untuk mempercepat proses pengembangan aplikasi gudang dikarenakan proses desain, implementasi hingga pengujian aplikasi berkesinambungan. Hasil penelitian menunjukkan bahwa aplikasi gudang yang di bangun dengan menggunakan Microsoft Access mempercepat kerja staf dalam membuat laporan, rekap stok dan melihat perubahan harga tanpa perlu harus melihat kartu stok yang tertera pada rak penyimpanan.


2018 ◽  
Vol 1 ◽  
pp. 198
Author(s):  
Lusy Tunik Muharlisiani ◽  
Henny Sukrisno ◽  
Emmy Wahyuningtyas ◽  
Shofiya Syidada ◽  
Dina Chamidah

Service at the “Kelurahan” is a very important part in determining the success of development, especially in public service. The problem faced is the lack of skill level of the “Kelurahan” apparatus with the more dynamic demands of the community and the archive management system is still conventional and manual that is writing the identity of the archive into the book agenda, expedition, control card, and borrowed archive card, so it takes a more practical electronic system, effective and efficient so required to develop themselves in order to improve public services. Conventional administration and archive management must be transformed into cloud-based computing (digital), for which archiving managers should always be responsive and follow these developments and wherever possible in order to utilize for archival activities, with greater access expected archives are evidence at once able to talk about historical facts and events and be able to give meaning and benefit to human life, so archives that were only visible and readable at archival centers can now be accessed online, and even their services have led to automated service systems. Using Microsoft Access which its main function is to handle the process of data manipulation and manufacture of a system, this system is built so that the bias runs on Cloud which means Cloud itself is a paradigm in which information is permanently stored on servers on the internet and stored. The purpose of this program is the implementation of administrative management that has been based cloud computing (digital) and is expected to be a solution in managing the archive so that if it has been designed and programmed, it can be stored in the computer and benefi- cial to the “Kelurahan” apparatus and add in the field of management archives in the form of improving the quality of service to the community, can facilitate and scientific publications.


2013 ◽  
Vol 8 (1) ◽  
pp. 24-29 ◽  
Author(s):  
Margaret Garnsey ◽  
Andrea Hotaling

ABSTRACT In this case, students assume the role of an accounting professional asked by a client to investigate why net income is not as strong as expected. The students must first analyze a set of financial statements to identify areas of possible concern. After determining the areas to investigate, the students use a database query tool to see if they can determine causes by examining transaction level data. Finally, the students are asked to professionally communicate their findings and recommendations to their client. The case provides students with experience in using query-based approaches to answering business questions. It is appropriate for students with basic query and financial analysis skills and knowledge of internal controls. A Microsoft Access database with transaction details for the final seven months of the current year as well as financial statements for the current and prior year are provided.


2015 ◽  
Vol 1 (1) ◽  
pp. 1-12
Author(s):  
Gunayanti Kemalasari ◽  
Miftah Widayatina

ABSTRAK Pengolahan data manual pada proses transaksi di As Sport Metro mempersulit pencarian data keluar masuk barang, perhitungan stok serta pembuatan laporan. Untuk memecahkan masalah tersebut diperlukan sebuah Sistem Informasi yang dapat membantu mengakses informasi secara lebih cepat. Tujuan penelitian ini adalah merancang sebuah sistem informasi yang dapat mempermudah transaksi penjualan, mendukung pengolahan data dan mempercepat penyajian laporan. Metode penelitian menggunakan prototype karena secara keseluruhan akan mengacu pada kepuasan pelanggan dan selama proses penelitian berjalan akan terjalin interaksi antara pengembang dan pelanggan. Dengan begitu penerapan lebih mudah karena antara pengembang dan pelanggan saling mengetahui apa yang diharapkan. Segala proses yang terjadi dalam sistem di implementasikandengan bahasa pemrograman Microsoft Visual Basic 6.0. dan menggunakan basis data Microsoft Access 2007. Kesimpulan yang dapat diambil adalah sistem informasi sanggup memenuhi kebutuhan pelanggan setelah dilakukan implementasi dan uji coba.


Author(s):  
Ram Pratap Sinha

Performance analysis of mutual funds is usually made on the basis of return-risk framework. Traditionally, excess return (over risk-free rate) to risk ratios were used for the purpose mutual fund evaluation. Subsequently, the application of non-parametric mathematical programming techniques in the context of performance evaluation facilitated multi-criteria decision making. However,the estimates of performance on the basis of conventional programming techniques like DEA and FDH are affected by the presence of outliers in the sample observations. The present, accordingly uses more robust benchmarking techniques for evaluating the performance od sectoral mutual fund schemes based on observations for the second half of 2010. The USP of the present study is that it uses two partial frontier techniques (Order-m and Order- a) which are less susceptible to the problem of extreme data.


Polymers ◽  
2021 ◽  
Vol 13 (11) ◽  
pp. 1887
Author(s):  
Viviana Quintero ◽  
Arturo Gonzalez-Quiroga ◽  
Angel Darío Gonzalez-Delgado

The conservation and proper management of natural resources constitute one of the main objectives of the 2030 Agenda for Sustainable Development designed by the Member States of the United Nations. In this work, a hybrid strategy based on process integration is proposed to minimize freshwater consumption while reusing wastewater. As a novelty, the strategy included a heuristic approach for identifying the minimum consumption of freshwater with a preliminary design of the water network, considering the concept of reuse and multiple pollutants. Then, mathematical programming techniques were applied to evaluate the possibilities of regeneration of the source streams through the inclusion of intercept units and establish the optimal design of the network. This strategy was used in the shrimp shell waste process to obtain chitosan, where a minimum freshwater consumption of 277 t/h was identified, with a reuse strategy and an optimal value of US $5.5 million for the design of the water network.


Sign in / Sign up

Export Citation Format

Share Document