MS Access Retail Business Management System

This project is a complete system designed to help small shop or store owners keep track of everything — from customer sales and product inventory to supplier bills and cash flow — all in one easy-to-use database. It’s built using Microsoft Access and is perfect for retail businesses that want to stay organized without using multiple complicated tools.

You can add and manage customer details — like name, phone number, and email. When a customer makes a purchase, their phone number helps pull up their past sales, so it’s easy to look up returns or see what they usually buy.

This is where you check out customers. Every sale gets a receipt number. You just enter the customer’s phone number and scan or enter the product. The system keeps track of what was bought, how much was paid, and who bought it.

You can add and manage all the items you sell. Each product has a unique code (like a barcode) so it’s easy to scan and track what’s in stock and what’s selling well.

This section helps you manage where your products are coming from. You can store the name and contact details of the supplier and keep track of what you bought from them.

Every time you receive new stock, you can enter the details here. This helps keep your inventory updated automatically.

Keep track of the bills you need to pay to suppliers. You can see how much you owe, when it's due, and which products it was for.

It gives you a full view of what products you have in stock, how many you’ve sold, and if you’re running low on anything.

All forms include easy Add New, Edit and Delete buttons, so you can update your records quickly.