About: I'm a Sri Lankan and like to communicate with others in the world with my knowledge. I'm employing as an Accountant and very familiar to create and develop Ms access software. my hobby is create crafts using …

With this instructables, I will give you a idea to create a Invoice and Inventory control system.using MS access.

It is very easy and no need more computer or programming knowledge.

If you have basic knowledge of Ms Access, Tables. forms and reports this will be very easy for you.

herewith give you a link of my already created database for your review. it is very user friendly invoicing system I'm given it to the world totally free.

if you interest, can download it from my website here

Step 1: Create Main Tables and Forms

Create Main Tables and forms

1. create following tables:

with same format

Step 2: Print Invoice

To print the invoice need to create two report according to the photo

first create the sub report for invoice data drag form invoice table ...

2nd final invoice..

After create both forms invoice will appear like this...

Step 3: Final Invoice

according to this way you can add some table to get the stock details and purchases also.

I have already created a full Invoice and inventory control system to give to world with low price to cover internet charges.

Anyone can Request it form my Website my site ..