Access VBA + MS SQL application for production planning and calculation of materials
Built for the needs of a production company. The goal was to streamline order handling and more accurately estimate the demand for materials, as well as generate production orders and needed to-do lists.
(PL version) Program do obsługi zamówień i zleceń produkcyjnych
Custom database solution for laser cosmetology salons
Database project made for the needs of beauty salons - cosmetic treatments with the use of laser equipment
The application was developed in the Access VBA environment and runs under Access Runtime.
- support and control of the patient registration process
- registration and monitoring of data regarding medical interviews
- email / SMS notification module
- statements / reports
- generating a customer card with a barcode / reading a barcode
(PL version) Baza danych do zarządzania gabinetem zabiegowym
Web application for handling orders of clothing wholesalers
Software made with ASP.NET/C# (webforms) plus MS SQL Server database.
- logging in and controlling permissions of user groups
- e-mail notifications about adding and changing the status of the order
- generating the required analyzes and summaries, reporting module
(PL version) Strona do rejestracji i obsługi zamówień online
Software made for transport company
Web application (ASP.NET/C# webforms) and MS SQL Server database as data storage.
Main functionality:
- control of user group permissions
- entering parcels
- generating labels with barcodes
- change and tracking of shipment status
- email notifications
- statements and reports with the option of saving to PDF / Excel
(PL version) Aplikacja online dla firmy transportowej / kurierskiej
Warehouse and production management system
Access VBA + SQL Server
A multi-user application with the option of logging in and controlling user permissions
- Handling of receipts, issues, inter-warehouse transfers, printout reports
- Issue of sales invoices
- Records and service of orders
- Production lists
- Flexible module of analyzes in the form of dynamic pivot tables and pivot charts
- Integration of analytics with Excel through the VBA language environment
- Data exchange with other programs used by the client to support the design stage (CAD) and to manage its production
- Printing labels and reading data from barcodes
If you are considering systematizing the work of the warehouse, production and analysis of this type of data through a dedicated application prepared especially for your needs, please feel free to contact me.
(PL version) Program do prowadzenia magazynu oraz planowania zakupów