<
Back to projects 
📦
Inventory Management
Database application for bar inventory management built as a bachelor thesis in MS Access, with stocktaking and automatic reporting.
Tech Stack
MS Access VBA SQL
About the Project
As my bachelor’s thesis at VŠB-TUO, I designed and developed an information system for managing bar inventory. The application replaced manual Excel spreadsheets and streamlined day-to-day inventory work.
Features
- Inventory Tracking: Receipt, issuance, and transfer of goods with movement history.
- Stocktaking: Support for physical inventory checks and reconciliation with records.
- Reports: Automated overviews of stock levels and goods movements.
- Suppliers: Contact management and order tracking.
Technologies
- MS Access: Database platform with a relational data model
- VBA: Process automation and report generation
- SQL: Query language for data operations