Clearly a professional instructor with great delivery and structure. Thank you Sir
@pinkchichan4 ай бұрын
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.
@augustonicola73914 жыл бұрын
This deserves a lot more views, excellent explanation!
@shadsluiter4 жыл бұрын
Glad you think so!
@colinraynor8333 жыл бұрын
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!
@geoffphil3 жыл бұрын
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.
@nadinefayed2 жыл бұрын
hi can u help me to add stock on hand
@AnteloBienesRaicesBolivi-cx4zs Жыл бұрын
Great job professor Sluiter
@shadsluiter Жыл бұрын
Thank you. Hope you are using it somewhere.
@abdulhamidalhaddadi22552 жыл бұрын
it was a Great lesson MR. Thank you very much.
@lasandyman13 жыл бұрын
Very clear and useful, thank you.
@miguelmunoz59843 жыл бұрын
Absolutely wonderful tutorial and narration!
@roberth.95582 жыл бұрын
Outstanding presentation and information. Thank you.
@moodkn2 жыл бұрын
Thanks...! Apreciate you...Helpful - Easy Way
@AyorindeAdeniran7 ай бұрын
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.
@الادهم-ص2ظ4 жыл бұрын
thank u very much nee d video explain steps Build Real World Food Delivery App with Xamarin Forms
@ehabhamouda71402 ай бұрын
more than great
@tonanmaroc2 жыл бұрын
Thank you very much
@iisdw50333 жыл бұрын
Thanks for share tutorial
@patrick_5272 жыл бұрын
This is great!!!
@waikinlo39912 жыл бұрын
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.
@hkiran37423 жыл бұрын
How to calculate subform base on sell types if credit price is more then cash bill.
@sydrabin36852 жыл бұрын
This was a great MS-Access Overview in under an hour. Well done! Concise and to the point!
@nadinefayed2 жыл бұрын
hi how can i add quantity in vendor table and can see the stock remainnig in report
@mohamedwagieh92808 ай бұрын
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.
@AyorindeAdeniran7 ай бұрын
I have the same issues
@gokceediz2 жыл бұрын
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 :)
@stephenchua25762 жыл бұрын
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..
@shadsluiter2 жыл бұрын
No, sorry. Let's leave that for your challenge to complete.
@huzaifaniazi91454 жыл бұрын
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
@nadinefayed2 жыл бұрын
hi i also need this
@hkiran37423 жыл бұрын
Sir can u please help me with Customer type pricing
@khanleader3 жыл бұрын
💖❤💖💖💖
@imssd6642 жыл бұрын
kzbin.info/www/bejne/aGKsgXuYnN17rZI رابط لنظام كامل روعه
@bumpersmith3 жыл бұрын
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.
@sulemanbutt1523 жыл бұрын
i need help in retail application database which is to be made on MS Access
@KING-rl4hf3 жыл бұрын
Really help me. Thanks you very much
@tomaszzdziarski4712 жыл бұрын
The best tutorial for begginers. Thank you
@sazalihanem3 жыл бұрын
Thank You so much!... the best tutorial in MS Access
@nadinefayed2 жыл бұрын
hi can u tell me how i know the quanty on hand
@imedtrd32113 жыл бұрын
Thank You very much for creating this video. It helped me a lot in creating my database.
@mohamedatallah78453 жыл бұрын
Excellent, Simple and clean well done my friend :)
@Lucianozw3 жыл бұрын
God bless you for all your hard work! Thank you so much!
@nadinefayed2 жыл бұрын
i need to do stock in and out
@matthewporter93286 ай бұрын
You sir have a subscriber thanks this is by far the easiest tutorial to follow for this
@SajjadAhmed-lc2dr4 жыл бұрын
mr shad as a expert you should teach us data structure and algorithms
@kris-eb8gv2 жыл бұрын
so useful!!! thanks
@bigwigglezgamez7982 жыл бұрын
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
@shadsluiter2 жыл бұрын
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.