How to create invoices in Microsoft Access | Everything you need to know about Invoices in MS Access

Invoice Database creation in Microsoft Access
Hello there, thanks for tuning in to this DataTechs tutorial. This is such a lengthy but highly informative video that I share with you on how to create and issue invoices to customers.
Invoice handling is an activity that any business be it retail or wholesales cannot do without. In here, I take you through step step how to set up the rightful tables, forms, queries and reports needed to make invoice management database a success.
TABLES CREATED:
1. Products
2. Customers
3. Orders/Invoice tb
QUERIES:
Sales calculation Query
LINK TO FILE:
drive.google.com/file/d/1nqgI...
CONTACT ME ON:
WHATSAPP: [phone]
EMAIL: [e-mail]

[@user-yc8hs1gw1i]

It is Fantastic that you Answer Every Comment!!!!! Thanks for the explained Content Sir Best of Good Luck....

[@HuzaifaSwati803]

The Copy of My Comment Hahahahahaha Okay No Problem, Don't Worry, I don't Mind!!!

[@HuzaifaSwati803]

It is Fantastic that you Answer Every Comment!!!!! No KZbinr works on such Policies,,,, Thanks for the explained Content Sir Best of Luck

[@datatechstutorials]

It's my pleasure. Thanks sir

[@Sillywitchlove]

This video literally saved my behind!! I can't thank you enough!

[@datatechstutorials]

You are very welcome madam.

[@tejanfamily659]

Thanks you very much but I want to know how to add new product when the product is not on your list.

[@mabreghana4557]

Thanks for this video. It is very educative.

[@datatechstutorials]

Glad it helped. Thanks

[@kinganthonyx]

thank you very much. Lesson was explained well

[@datatechstutorials]

You are welcome!

[@ilovephotosensei]

Thanks for this video. You need more followers and viewers than this. Thanks for the guidelines throughout.

[@datatechstutorials]

Thank you too

[@mengmakara9365]

This is very educative, well done.

[@datatechstutorials]

Thank you

[@vishalsutar9799]

Amazing brooooo❤❤❤

[@MD-cx8ei]

Love this

[@rowellamichaels]

Amazing!

[@datatechstutorials]

Thanks!

[@it-educator9735]

very good tutorial

[@datatechstutorials]

Many many thanks

[@youthdigital5730]

Sorry can you help me how to collect data from different tables (two or more) and place them in one table for reporting

[@RaminRamesh]

thanks for sharing the db file

[@datatechstutorials]

Thank you too sir.

[@josedimastovar266]

Hello teacher very nice.

[@datatechstutorials]

Thank you! 😃

[@thedareshow-kr]

When I go into form view it does not move like yours it's fitted the hole screen please help

[@thedareshow-kr]

Like that one 9:31

[@user-ir5ee2nn8u]

Thank you for the lesson. I have query, if the same customer purchase more products at a later date, how to add more order forms with the same customer, and preview the invoice at the date of customer purchase the products. In my case, with the same mechanism of the sample, the invoice report will preview all invoices in 2 pages. How to preview only last invoice, thank you.

[@datatechstutorials]

Hello sir, it is best you send me an email or whatsapp explaining since this is more or unless personal problem pls? Thank you.

[@HuzaifaSwati803]

Dear Sir, Would you like to Upload a coarse-wise session of videos that explain the MS Access with much in-depth details, that will be fantastic, if you already have uploaded the coarse, then link my comment to that !!! otherwise Upload Please Please Please

[@milfredalcalde7336]

Very understandable video sir! Kudos! Just have a query sir....how can you do a credit balance report on specific costumer with their payment and balance history. Thanks for answering in advance sir...Godbless!:D

[@datatechstutorials]

a lot goes in here. maybe you can contact for special consultation on this

[@verzamelaarskabinet4932]

hello thanks for the leassons i have makinig a lot of work with .. BUt nowe i stuck.. .. a several day i am look for the anwserr on this quistion .. If i making the macrocode = brings me to the raport ( ="[saleorder]=&"'"& [saleorder] ecte ct . I am getting a raport with ALL my records sale but not the specific saleorder ? Can somebody help me with it ... thanks

[@datatechstutorials]

can you send an email?

[@muhammadimranrafique4778]

Thank You so much Sir share the file of profit and loss accdb.

[@datatechstutorials]

Will upload soon

[@kelvinmutembei2865]

after doing adding the sales code on the invoice the systemis requesting for parameter value for sales code

[@datatechstutorials]

you can send me this via WhatsApp

[@omegacodedeveloper3592]

Good video, just one question. what happens when a customer comes more than once a day, there is no way to distinguish between the orders a customer bought in different times of the day

[@datatechstutorials]

In this case, we can combine customer ID and date of orders to create a unique serial which can be used to identify all orders made by a customer on a particular day.

[@aazarhanif6807]

Hi There, I was practicing side by side your video and at the portion where you were saving the Table 3, Invoice_OrderTB access displayed an error "type mismatch". I tried some help but couldn't fix this error. Can you guide me?

[@datatechstutorials]

You can email me with the issue?

[@maankobciye7787]

Hi prof what ido if i need to print only one record not totall

[@datatechstutorials]

In that case use button on profile to open directly to a record using where to statements (where "Id="&id for example

[@nazmamedicare5720]

Sir, Do you have any software for Diagnostic Center or Clinic ? I prefer Made in Access

[@datatechstutorials]

No I don't have. But you can contact to discuss this. Thx

[@Mamoiavarte]

Sir, can you share how to update the product price, without effecting existing one. when I changed the product price of "Gin Toes" all the previous selling price of "Gin Toes" recorded are also changed.

[@datatechstutorials]

Okay. This is well noted and will upload on it. Thanks for sharing to the benefit of the community.

[@Mamoiavarte]

@@datatechstutorials Sir, I still waits you help in how to update the product price, without effecting existing one.

[@datatechstutorials]

@@Mamoiavarte hey, can you send me an email or Whatsapp

[@emiledellieu]

Fantastic job...but this does not subract the QTY f the item invoicee from the inventory QTY. Therfore, if you have 20 items and sell 15, it still shows that you have 20 items. It would get 100% if this was achieved.

[@datatechstutorials]

yes this video doesn't capture that. check in other videos in the playlist on product qnty calculation and inventory. Thx

[@sss-dd6wy]

Is it possible to add percentage discount button from the total price? Thank you

[@datatechstutorials]

Yes sir. It is possible

[@sss-dd6wy]

Do you have any tutorial or link for that one sir? I cant use a calculation formula since the sum of total cost was created on datasheet layout and CART form has no table, only formulated from invoice query. Tnahk you@@datatechstutorials

[@sss-dd6wy]

I mange to creat a new discount button and succesfully applied a discount formula on on CART form but when I add on query in ooce report the label is visible but the the disclut value was not vissible and it was blank. Is it in the format setrings to show the value? Thank you

[@sss-dd6wy]

I will try to add the formula in query expresion builder. I will try to figure out the right formula as well.

[@bankolemalomo7556]

This is very educative, well done. However, you need to slow down the pace of teaching so that you don't lose some learners.

[@datatechstutorials]

Okay I will sir. Thanks for advice

[@eyongmarglinette4078]

Sir am blocked at the level of the invoice table,it is saying mismatch

[@datatechstutorials]

Hell Eyong, check the description to download the full file of this lesson. If issue persist contact me via WhatsApp or mail.

[@afamchukwu2997]

Good morning

[@datatechstutorials]

Good morning sir. For personal conversations do email me

[@ramongallardo3492]

You go way to fast. Slow down! I had to go back over and over because I kept missing things you would quickly say under your breath. Overall, this video was very informative. Ok...I'm going to go back and rewatch the parts I missed.

[@datatechstutorials]

Thank you for the kind advice

[@421sap]

God bless you in Jesus' Name Amen ✝️

[@datatechstutorials]

Amen