Ms Access ERP production management system - to manage and organize the production line's processes

Getting production to run as desired, establishing performance metrics, and complying with standard goals

Production control

Keeping track of the production process at various stations, scanning barcodes on routing cards, recording work hours, performing quality control, disqualifying defective products, collecting information on the production line and checking loads at workstations.

Inventory control

Monitor inventory levels in the various warehouses, in-process inventory, armored inventory, and alerts about shortages and anomalies in inventory.

Purchasing control

A transfer of purchasing requirements from the production line to the purchasing department, issuance of purchase orders to subcontractors, and monitoring the receipt of goods in the warehouse.

Monitoring the production line, order production, and meeting schedules

MS Access
Production processes are executed according to the system module – planning, monitoring and controlling operations and production (Top-down communication) – while adhering to quality and correctness.
This module is characterized as (Manufacturing Execution System) – MES
For the entire life cycle of production, the module provides control, monitoring, and control
Solution and function main points:
The routing of production processes in production lines based on processing centers / departments
Execution of production instructions (scheduling work hours, processes, and work involved in creating the items)
Compliance with quality standards (ISO 2000-9000 ISO)
The creation of a work order based on the product trees
Issuance certificates preparation
Reports on work processes
Work orders should be updated with inventory at work stations


Job Card

This is a framed description:
In this module, the process execution can be designed, monitored and controlled. The ERP resource management in the plant is connected / combined with the field level.

Based on an existing order, a work order is generated:

Customer order O

Order repair R

Inventory order M


View the production report

Besides selecting the required order, the type of work order is also determined:
A standard work order, a repair work order, or a stock work order.
A typical work order extracts data from the product trees of the items in the order, and then calculates the quantities required for the order to be issued.
The warehouse accepts the purchase requirements
The Work Ordinance describes the items to be taken out to subcontractors.
There is already all the data, including the departments and the locations within the departments, ready for issuance.
It is only necessary for the warehouse to confirm the issuance from a particular locator and batch.
The issuance certificate is ready, the inventory has been updated, and stickers have been printed on the issued items.
A work order report subtracts the inventory of the items in the departments and adds the finished product to the finished frequency inventory after the departments have completed their processes.

Production line management, quality assurance control, and consistency -MS-Access ERP

Here are the main solutions and functions:
Controlling compliance with quality requirements (2000-9000 ISO)
This is a framed description:
Every item that enters the warehouse from external suppliers, or is received from a subcontractor, enters the warehouse as a finished product after completing the production process, and undergoes a quality assurance audit.
Check if the item is correct and update its status to GOOGS
If an item is under inspection, its status is updated to HOLD.
When a defect is found in the item, the status is updated to REJECT, along with the number of disqualifications and the reason for disqualification.
An order is also given here to return to the supplier, or to transfer production of a product that was returned from the customer for repair with the essence of the repair.
When an item is completely disqualified, it is transported to an extermination warehouse.
In this department, valid products are also given expiration dates.

Incident Card

MRB Material Review Board

An item that has been rejected for any reason, such as a quality problem, is submitted to the MRB committee for discussion, and a decision is made on how to handle it (repair, destruction, return to supplier).
Usually, the process begins with the person who complains about the customer opening a fault card detailing the fault, the findings, and the ways to handle the problem.
The fault card is given to the staff members who investigate the causes and suggest ways of repairing and preventing the fault.
The research is approved by quality control personnel, and the product is treated according to the research decisions.

MRB - Inquiry form

:Learn more

We promote and improve your business management

Specialists in MS-Access software development

A complete solution for running a business or factory

Customize the software to suit your needs

Adding models to existing software