Sales and Inventory Management Software Microsoft Access (VBA)

Language

This is a Sales and Inventory Management System in using Microsoft Access. Here all the records are stored in the software. Record about the products and bills. Sales and Inventory Management Software In VBA (Microsoft Access) is Developed Using VBA + Access Database. This system manages records such as the suppliers, stocks, product categories, customers, employees, products, sales, reports and etc of a certain business. This system updates the product stock automatically after the system user encodes the purchases list. This feature serves as the receiving stock in feature of the system. The available stocks in inventory also update automatically every time the sales transaction is being done. This system also generates reports.

Features :

  • Company Entry
  • Customer Entry
  • Supplier Entry
  • Salesman Entry
  • Employee Entry
  • Products Entry
  • Users Registrations
  • Purchase Entry
  • Sales Entry
  • Product Stock

Reports :

  • Customer Report
  • Sales Report
  • Sales Receipt
  • Purchase Report
  • Stock Report
  • Sales Man Report
  • Employee Report
  • Product Report

How to Run

Requirements:

  • MS Access Software / MS Access Runtime

Setup

  1. Download and Extract the source code zip file. (Download button is located below)
  2. Open the extracted folder and locate the "SALES AND INVENTORY MANAGEMENT SOFTWARE.accdb" file.
  3. Open the file with Microsft Access

Admin Credentials

User: admin
Password: 12345

Inventory Management System (Microsoft Access) - DEMO

I hope this Sales and Inventory Management System in MS Access will help you with what you are looking for and for your future project using MS Access.

Developed By: Vaibhav Patidar
LIKE | COMMENT | SHARE |

Anyone who needs program or source code for thesis writing or any Professional Software Development (desktop/Web):-
Facebook: https://www.facebook.com/vaibhav.patidar.524
My WhatsApp Number: +919630014949
My Contact Number: +919630014949
Email: [email protected]

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

Submitted byVaibhav Patidar (not verified)on Wed, 03/29/2017 - 20:33

Thanks to all of you for appreciating my work .....!!!
Submitted byIvcak (not verified)on Wed, 11/29/2017 - 20:26

Excellent work dud every useful
Submitted bySheelaR (not verified)on Tue, 08/28/2018 - 17:12

Dear Sir, when i try to open downloaded file, it opens the web page which has this article. please help me to open the downloaded file and see all codings. Thank you
Submitted bykhizarkhan (not verified)on Tue, 05/19/2020 - 15:07

sir i have download your file but admin login required please provides us admin login .
Submitted byi put the user… (not verified)on Sat, 01/02/2021 - 23:39

i put the user admin and pass 12345 but it is not opening
Submitted bySohun (not verified)on Fri, 03/05/2021 - 17:00

thanks u man
Submitted byMohammed Jakir… (not verified)on Mon, 03/22/2021 - 20:45

How to edit the application
Submitted byMd Ariful Islam (not verified)on Sun, 09/05/2021 - 18:58

Please help me, not working user id and password
Submitted byKhaled Mougharbel (not verified)on Wed, 01/19/2022 - 21:25

HELLO SIR NICE WORK, BUT USER NAME AND PASSWORD NOT WORKING , WOULD YOU PLEASE PROVIDE ME THE RIGHT ID AND PASSWORD. THANKS
Submitted bysokha123 (not verified)on Wed, 02/23/2022 - 18:28

username and password not working. waste of time
Submitted byGuido1 (not verified)on Sun, 07/03/2022 - 17:10

It is a very nice piece of software. Some nice code examples. I made a few tweaks. 1. Open the software with shift such that you get into the development. I made sure the password is 12345 in the table tbUser and in tblUser. 2. in the table tblCompany, change the address in the Pic field to where you have a picture for the "Margo Sales and Service" company. There are some nice chuncks of code in this program. Dor not use this for production, without adding some extra security and onError code.
Submitted byJennifer N. (not verified)on Mon, 09/04/2023 - 05:24

Thanks for this. The username and password work fine after enabling the database. It looks like an excellent example of an inventory system written in MS Access, which I was looking for. I downloaded the file and tried to debug/compile it in VBA. It won't compile without fixing a lot of VBA code errors. I recommend you fix those errors when you have time so new users don't have to sort it all out. I also wish it had better code documentation and error trapping. It is a valuable example of inventory tracking written in Access!
Submitted bylucky87 (not verified)on Mon, 01/15/2024 - 21:12

Hello sir, you have created an excellent inventory program using MS Access. If you have its tutorial, plz upload it on YouTube.
Submitted bylucky87 (not verified)on Mon, 01/15/2024 - 21:41

Hi Sir, plz guide me on how to update recent data of any Form like invoice, purchase, etc. When I open recent data from the list button then "Add" "Remove" buttons are inactive state and listbox rows "double click" to fill data to source boxes also not working.

Add new comment