Build a Microsoft Access App for tracking sales orders

[@drewcover2864]

Clearly a professional instructor with great delivery and structure. Thank you Sir

[@pinkchichan]

I've watched so many tutorials in the last few days trying to get my head around how to get an order form to look up products from a products table and bring across the description and price, and pretty much every one of them skipped over the most important step and went straight into calculating totals and designing forms. Massive thank you for this video!! You saved my sanity.

[@eyobgalcha802]

Thanks alot

[@commander989]

This was a great MS-Access Overview in under an hour. Well done! Concise and to the point!

[@tomaszzdziarski471]

The best tutorial for begginers. Thank you

[@augustonicola7391]

This deserves a lot more views, excellent explanation!

[@shadsluiter]

Glad you think so!

[@colinraynor833]

Thank You Shad. I have seen tons of videos about doing things like this, and I have to just say you walk through it excellent. Step by step. While this particular feature didn`t apply to my needs, it was helpful in what I did need. Well done!

[@AnteloBienesRaicesBolivi-cx4zs]

Great job professor Sluiter

[@shadsluiter]

Thank you. Hope you are using it somewhere.

[@geoffphil]

Thankyou very much Shad. Exactly what I was looking for as a first go at a sales database (though even this well explained video has its complications!). One wrong move or rename of a table or other object can cause chaos. Your patient tone and clear narration are outstanding. You are very generous to share this video - many Access experts charge for a course. Thanks again.

[@nadinefayed]

hi can u help me to add stock on hand

[@sazalihanem]

Thank You so much!... the best tutorial in MS Access

[@nadinefayed]

hi can u tell me how i know the quanty on hand

[@matthewporter9328]

You sir have a subscriber thanks this is by far the easiest tutorial to follow for this

[@Lucianozw]

God bless you for all your hard work! Thank you so much!

[@mohamedatallah7845]

Excellent, Simple and clean well done my friend :)

[@imedtrd3211]

Thank You very much for creating this video. It helped me a lot in creating my database.

[@miguelmunoz5984]

Absolutely wonderful tutorial and narration!

[@abdulhamidalhaddadi2255]

it was a Great lesson MR. Thank you very much.

[@lasandyman1]

Very clear and useful, thank you.

[@roberth.9558]

Outstanding presentation and information. Thank you.

[@KING-rl4hf]

Really help me. Thanks you very much

[@AyorindeAdeniran]

Very good tutorial... I really appreciate it. Can you help with price updates. Each time a product changes in price, the app does not keep the old price.

[@huzaifaniazi9145]

Hello sir Can we code for Quantity which we import in form it subtract atumatically from products table , I am mean for whole invoice , When i amport data in invoice these data saved in tables and also Quantity subtracted. How we can make like this invoice? Thanks

[@nadinefayed]

hi i also need this

[@moodkn]

Thanks...! Apreciate you...Helpful - Easy Way

[@nadinefayed]

hi how can i add quantity in vendor table and can see the stock remainnig in report

[@gokceediz]

Hi, thanks for this great video. I learnt Access by myself and now I'm trying to do order follow up programme. But I have problem to manage received orders. I have order no and inside of order there are 5 items for example. But each item can be delivered in different dates/different import process and I'd like to follow in 1 page order lines with delivery details below the item lines. I tried to make form and sub form for deliveries but it is not working under item lines. Do you have any suggestion? It's like I'd like to create subform under subform :)

[@patrick_527]

This is great!!!

[@mohamedwagieh9280]

thank you for the useful video. i followed your instructions, and whenever i update product price with new orders, it affects the older prices for the older orders to the same update, i want a solution that keep old record's prices while allowing me to update prices for the new records, i.e. program an equation that affect only the record within the order without updating prices all the way back.

[@AyorindeAdeniran]

I have the same issues

[@kris-eb8gv]

so useful!!! thanks

[@hkiran3742]

How to calculate subform base on sell types if credit price is more then cash bill.

[@stephenchua2576]

Hello, thank you for such a great and most informative video I have watched ever on YT. Do you have a video on how to print the "Invoice" for that transaction, similar to the image you searched on Google Images on this video? Or how to make the printable invoice that would include the company logo and footnotes, etc..

[@shadsluiter]

No, sorry. Let's leave that for your challenge to complete.

[@waikinlo3991]

Ur InvoiceDetailID is unique or re-counting by each InvoiceID? If it is former, that means the Invoice table don't actually separate from Invoice detail table. Because only one attribute belongs to the candidate key, the composite key doesn't exist, also partial dependency won't be showed. But, if it is latter, that means the candidate key should include InvoiceID and InvoiceDetailID. Because the InvoiceDetailID will repeat the same value in other invoice, everytime create a new invoice should reset the value to 0. Only InvoiceID and InvoiceDetailID are existing in query at the same time, the unique result may generate in latter case.

[@iisdw5033]

Thanks for share tutorial

[@hkiran3742]

Sir can u please help me with Customer type pricing

[@nadinefayed]

i need to do stock in and out

[@ehabhamouda7140]

more than great

[@tonanmaroc]

Thank you very much

[@الادهم-ص2ظ]

thank u very much nee d video explain steps Build Real World Food Delivery App with Xamarin Forms

[@SajjadAhmed-lc2dr]

mr shad as a expert you should teach us data structure and algorithms

[@khanleader]

💖❤💖💖💖

[@imssd664]

kzbin.info/www/bejne/aGKsgXuYnN17rZI رابط لنظام كامل روعه

[@bumpersmith]

Good for the simplest example but it would have been much more practical to make the report for the invoice. The beginner may be just left hanging. The report example shown is pretty much useless for the intent of your lessons.

[@bigwigglezgamez798]

I got Access as part of an Office Bundle. I found a lot of tutorial videos rather complicated despite the fact that I could see this as a necessity for my business after watching them. My search began for a video for a commission tracker... This video not only made me understand what I was doing but replaced two softwares I was paying annual fees for, plus I was able to delete a lot of information stored across multiple Spreadsheets and have it all stored in one neat database. I will be trying to make my own comes tracker after this. Hope all goes well but this coaching was arguably the best I've seen online

[@shadsluiter]

Thank you so much. That is a really great compliment. I created the tutorial for my students after doing a similar search. There is a lot of complexity in building databases that can make tutorials very complex.