CHEMICAL LABORATORY INVENTORY SYSTEM USING MICROSOFT ACCESS

Inventory system is an activity in the data processing of goods contained in a warehouse. The inventory system has a major influence on an agency, because the inventory system can help solve goods data processing problems and facilitate reporting of available goods data.An agency that does not have an inventory system will experience a few problems in processing data on goods, for example, in a Chemistry Laboratory that does a manual inventory data recording system. The staff collects goods. The data collection activities include collecting data on new goods arriving, old goods that are still suitable for use, even goods that are damaged and must be replaced in each room, then the data is processed into an inventory data report to the Head of the Laboratory using Recording in Ledgers and Microsoft Excel.
The data collection process like this is less effective because it requires accuracy, in collecting data with a large number of items it often results in redundancy of data (double data) and in the process of making inventory data reports requires a long process because staff have to make new data. These problems make staff have to work repeatedly to obtain the right data, for example in the case of making an inventory data report for data collection on new items that will be placed in the available space, the staff must re-check the condition of the items available in the room and revise the report. inventory of these items.
The Chemical Laboratory inventory system was created with the aim of helping the smooth process of collecting inventory data at the school. Therefore, this inventory system functions to carry out the data collection process and also to make reports. For the data collection process, the Chemical Laboratory inventory system can collect data on the receipt and release of goods at the chemical laboratory. In the data collection, the system can not only store data but can also modify and delete existing data.
The flow of the goods inventory system in the chemical laboratory is seen in the illustration which is illustrated as follows:

Information :

The school inventory provides goods/data to the lab section. chemistry regarding school inventory owned by the school
Laboratory assistant records/does laboratory inventory. chemistry (which has been grouped into separate sections), then submits an inventory report to the school inventory.
Laboratory assistants provide lab inventory reports to the head of the lab.
The head of the lab.chemistry provides a lab inventory report. chemistry to the principal.
Design of Input Goods Incoming and Outgoing Items

The input form for receiving and releasing goods functions as a facility for inputting data on goods in the form of chemical laboratory tools and materials. Specifications, conditions and date of entry, date of exit, amount are also listed so that the resulting data or information is more valid.
In this form there is also a data saving facility and a data delete button to save and delete inventory data that has been input.