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...
Saved in:
Main Author: | |
---|---|
Format: | Thesis |
Language: | English |
Published: |
2009
|
Subjects: | |
Online Access: | https://ir.uitm.edu.my/id/eprint/36613/1/36613.pdf |
Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
id |
my-uitm-ir.36613 |
---|---|
record_format |
uketd_dc |
spelling |
my-uitm-ir.366132020-11-12T08:05:55Z 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 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 https://ir.uitm.edu.my/id/eprint/36613/ https://ir.uitm.edu.my/id/eprint/36613/1/36613.pdf text en public degree Universiti Teknologi MARA Faculty of Mechanical Engineering Adull Manan, Nor Fazli |
institution |
Universiti Teknologi MARA |
collection |
UiTM Institutional Repository |
language |
English |
advisor |
Adull Manan, Nor Fazli |
topic |
Machine design and drawing Machine construction (General) |
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 |
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 |
qualification_level |
Bachelor degree |
author |
Azman, Raimi Hazwani |
author_facet |
Azman, Raimi Hazwani |
author_sort |
Azman, Raimi Hazwani |
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_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_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_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 |
granting_institution |
Universiti Teknologi MARA |
granting_department |
Faculty of Mechanical Engineering |
publishDate |
2009 |
url |
https://ir.uitm.edu.my/id/eprint/36613/1/36613.pdf |
_version_ |
1783734348466356224 |