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.
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.
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!
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.
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..
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
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 :)
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.
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
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.
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.
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.
Clearly a professional instructor with great delivery and structure. Thank you Sir
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.
Thanks alot
This was a great MS-Access Overview in under an hour. Well done! Concise and to the point!
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.
hi can u help me to add stock on hand
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!
The best tutorial for begginers. Thank you
This deserves a lot more views, excellent explanation!
Glad you think so!
You sir have a subscriber thanks this is by far the easiest tutorial to follow for this
Thank You so much!... the best tutorial in MS Access
hi can u tell me how i know the quanty on hand
Thank You very much for creating this video. It helped me a lot in creating my database.
God bless you for all your hard work! Thank you so much!
Great job professor Sluiter
Thank you. Hope you are using it somewhere.
Excellent, Simple and clean well done my friend :)
it was a Great lesson MR. Thank you very much.
Outstanding presentation and information. Thank you.
Absolutely wonderful tutorial and narration!
Very clear and useful, thank you.
Really help me. Thanks you very much
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.
Thanks...! Apreciate you...Helpful - Easy Way
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..
No, sorry. Let's leave that for your challenge to complete.
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
hi i also need this
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 :)
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.
I have the same issues
hi how can i add quantity in vendor table and can see the stock remainnig in report
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
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.
so useful!!! thanks
mr shad as a expert you should teach us data structure and algorithms
Thanks for share tutorial
This is great!!!
Thank you very much
How to calculate subform base on sell types if credit price is more then cash bill.
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.
thank u very much nee d video explain steps Build Real World Food Delivery App with Xamarin Forms
i need to do stock in and out
more than great
Sir can u please help me with Customer type pricing
💖❤💖💖💖
ua-cam.com/video/21IPHbgxHw0/v-deo.html رابط لنظام كامل روعه
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.