This is the simple Stock Control program developed in JAVA for Wine shop which is powerful, flexible,easy to use and is designed specially for wine shops and stores. This project manages stock details, Sales details, quantity details, etc. If it gives alert message if quantity is below 3 bottle. User must login to the application to update the record.
Stock Control Program
- When the software opens it displays the Welcome page
- Can display product information with description, price, manufactured year, available quantity, etc
- Search for product current condition
- Display product Quantity- Available quantity and out stock
- Add or deduct the quantity of product
- Alert if the quantity is below the alert point (i.e. below 3 bottle)
- 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