This is the basic Stock Management software built-in JAVA for Wine Shop, which is efficient, scalable, easy to use, and designed specifically for wine shops and stores. This project manages the details of stock, sales details, quantity details, etc. If you send a warning if the amount is below 3 bottles. Users must log in to the application to change the record.

Stock Control Program

• When the app opens, the Welcome message will be shown.
• Can view product details with description, price, year of manufacturing, quantity available, etc.
• Search for product current condition
• Show inventory Quantity-Available quantity and stock out of stock
• Add or deduct the quantity of product
• Warning if the quantity is below the point of alert (i.e. below 3 bottles)
• Commenting on the program

Front end: Java Program

Back end: MS Access database

No. of forms: 10

Database table:

Product info:

• Name of product
• Origin
• Year of the wine
• Price
• Quantity

Sales info:

• Sales name
• Sales id