Design and improvement of database for inventory and preventive maintenance system of industrial parts and components using Microsoft Excel and Graphical User Interface (GUI) / Raimi Hazwani Azman

The number of industrial companies especially small and medium type, that still stored crucial information regarding industrial parts and components using files and documentations is huge. This particular project will solve this issue by designing a DBMS for inventory and preventive maintenance syst...

Full description

Saved in:
Bibliographic Details
Main Author: Azman, Raimi Hazwani
Format: Thesis
Language:en
Published: 2009
Subjects:
Online Access:https://ir.uitm.edu.my/id/eprint/36613/1/36613.pdf
https://ir.uitm.edu.my/id/eprint/36613/
Tags: Add Tag
No Tags, Be the first to tag this record!
_version_ 1833065404365275136
author Azman, Raimi Hazwani
author_facet Azman, Raimi Hazwani
author_sort Azman, Raimi Hazwani
building Tun Abdul Razak Library
collection Institutional Repository
content_provider Universiti Teknologi Mara
content_source UiTM Institutional Repository
continent Asia
country Malaysia
description The number of industrial companies especially small and medium type, that still stored crucial information regarding industrial parts and components using files and documentations is huge. This particular project will solve this issue by designing a DBMS for inventory and preventive maintenance system of industrial parts and components by integration of Microsoft Excel and Visual Basic for Applications software. VBA is a program that built into most of Microsoft Office applications and it utilized the system applied in Visual Basic programming language. All data and information involve will be arranged and managed using Microsoft Excel and VBA act as tool to create Graphical User Interface application for the database. Resulting from that, an interesting GUI window is produced and from that window, user can search any part or component using specific id, and program will display all required information together with photo and preventive maintenance schedule of the particular part or component. It is believe that within this new form of DBMS, common problems of using files and documentations to store information will be totally removed.
format Thesis
id my.uitm.ir-36613
institution Universiti Teknologi Mara
language en
publishDate 2009
record_format eprints
spelling my.uitm.ir-366132020-11-12T08:05:55Z https://ir.uitm.edu.my/id/eprint/36613/ Design and improvement of database for inventory and preventive maintenance system of industrial parts and components using Microsoft Excel and Graphical User Interface (GUI) / Raimi Hazwani Azman Azman, Raimi Hazwani Machine design and drawing Machine construction (General) The number of industrial companies especially small and medium type, that still stored crucial information regarding industrial parts and components using files and documentations is huge. This particular project will solve this issue by designing a DBMS for inventory and preventive maintenance system of industrial parts and components by integration of Microsoft Excel and Visual Basic for Applications software. VBA is a program that built into most of Microsoft Office applications and it utilized the system applied in Visual Basic programming language. All data and information involve will be arranged and managed using Microsoft Excel and VBA act as tool to create Graphical User Interface application for the database. Resulting from that, an interesting GUI window is produced and from that window, user can search any part or component using specific id, and program will display all required information together with photo and preventive maintenance schedule of the particular part or component. It is believe that within this new form of DBMS, common problems of using files and documentations to store information will be totally removed. 2009 Thesis NonPeerReviewed text en https://ir.uitm.edu.my/id/eprint/36613/1/36613.pdf Design and improvement of database for inventory and preventive maintenance system of industrial parts and components using Microsoft Excel and Graphical User Interface (GUI) / Raimi Hazwani Azman. (2009) Degree thesis, thesis, Universiti Teknologi MARA.
spellingShingle Machine design and drawing
Machine construction (General)
Azman, Raimi Hazwani
Design and improvement of database for inventory and preventive maintenance system of industrial parts and components using Microsoft Excel and Graphical User Interface (GUI) / Raimi Hazwani Azman
title Design and improvement of database for inventory and preventive maintenance system of industrial parts and components using Microsoft Excel and Graphical User Interface (GUI) / Raimi Hazwani Azman
title_full Design and improvement of database for inventory and preventive maintenance system of industrial parts and components using Microsoft Excel and Graphical User Interface (GUI) / Raimi Hazwani Azman
title_fullStr Design and improvement of database for inventory and preventive maintenance system of industrial parts and components using Microsoft Excel and Graphical User Interface (GUI) / Raimi Hazwani Azman
title_full_unstemmed Design and improvement of database for inventory and preventive maintenance system of industrial parts and components using Microsoft Excel and Graphical User Interface (GUI) / Raimi Hazwani Azman
title_short Design and improvement of database for inventory and preventive maintenance system of industrial parts and components using Microsoft Excel and Graphical User Interface (GUI) / Raimi Hazwani Azman
title_sort design and improvement of database for inventory and preventive maintenance system of industrial parts and components using microsoft excel and graphical user interface (gui) / raimi hazwani azman
topic Machine design and drawing
Machine construction (General)
url https://ir.uitm.edu.my/id/eprint/36613/1/36613.pdf
https://ir.uitm.edu.my/id/eprint/36613/
url_provider http://ir.uitm.edu.my/