Sample applications

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.

 

 profile

(PL version) Program do obsługi zamówień i zleceń produkcyjnych

Sample solutions

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

 

Gabinet1

Gabinet3

(PL version) Baza danych do zarządzania gabinetem zabiegowym

Sample projects

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

 orders1

 orders2

(PL version) Strona do rejestracji i obsługi zamówień online

Sample databases

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

 

 Lista przesyłek 1

(PL version) Aplikacja online dla firmy transportowej / kurierskiej

Sample projects

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.

 production planning

(PL version) Program do prowadzenia magazynu oraz planowania zakupów