No video

Build a Microsoft Access App for tracking sales orders

  Рет қаралды 47,605

Programming w/ Professor Sluiter

Programming w/ Professor Sluiter

Күн бұрын

Пікірлер: 49
@drewcover2864
@drewcover2864 3 ай бұрын
Clearly a professional instructor with great delivery and structure. Thank you Sir
@pinkchichan
@pinkchichan 3 ай бұрын
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.
@sydrabin3685
@sydrabin3685 2 жыл бұрын
This was a great MS-Access Overview in under an hour. Well done! Concise and to the point!
@tomaszzdziarski471
@tomaszzdziarski471 2 жыл бұрын
The best tutorial for begginers. Thank you
@colinraynor833
@colinraynor833 2 жыл бұрын
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!
@geoffphil
@geoffphil 3 жыл бұрын
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
@nadinefayed 2 жыл бұрын
hi can u help me to add stock on hand
@augustonicola7391
@augustonicola7391 3 жыл бұрын
This deserves a lot more views, excellent explanation!
@shadsluiter
@shadsluiter 3 жыл бұрын
Glad you think so!
@bigwigglezgamez798
@bigwigglezgamez798 2 жыл бұрын
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
@shadsluiter 2 жыл бұрын
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.
@matthewporter9328
@matthewporter9328 5 ай бұрын
You sir have a subscriber thanks this is by far the easiest tutorial to follow for this
@sazalihanem
@sazalihanem 3 жыл бұрын
Thank You so much!... the best tutorial in MS Access
@nadinefayed
@nadinefayed 2 жыл бұрын
hi can u tell me how i know the quanty on hand
@imedtrd3211
@imedtrd3211 3 жыл бұрын
Thank You very much for creating this video. It helped me a lot in creating my database.
@Lucianozw
@Lucianozw 3 жыл бұрын
God bless you for all your hard work! Thank you so much!
@KING-rl4hf
@KING-rl4hf 3 жыл бұрын
Really help me. Thanks you very much
@mohamedatallah7845
@mohamedatallah7845 3 жыл бұрын
Excellent, Simple and clean well done my friend :)
@lasandyman1
@lasandyman1 3 жыл бұрын
Very clear and useful, thank you.
@abdulhamidalhaddadi2255
@abdulhamidalhaddadi2255 2 жыл бұрын
it was a Great lesson MR. Thank you very much.
@user-lm7mz8pi1x
@user-lm7mz8pi1x 6 ай бұрын
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.
@AnteloBienesRaicesBolivi-cx4zs
@AnteloBienesRaicesBolivi-cx4zs Жыл бұрын
Great job professor Sluiter
@shadsluiter
@shadsluiter Жыл бұрын
Thank you. Hope you are using it somewhere.
@roberth.9558
@roberth.9558 2 жыл бұрын
Outstanding presentation and information. Thank you.
@miguelmunoz5984
@miguelmunoz5984 3 жыл бұрын
Absolutely wonderful tutorial and narration!
@user-qr9pe5hw7d
@user-qr9pe5hw7d 4 жыл бұрын
thank u very much nee d video explain steps Build Real World Food Delivery App with Xamarin Forms
@moodkn
@moodkn 2 жыл бұрын
Thanks...! Apreciate you...Helpful - Easy Way
@ehabhamouda7140
@ehabhamouda7140 Ай бұрын
more than great
@waikinlo3991
@waikinlo3991 2 жыл бұрын
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.
@nadinefayed
@nadinefayed 2 жыл бұрын
i need to do stock in and out
@mohamedwagieh9280
@mohamedwagieh9280 7 ай бұрын
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.
@user-lm7mz8pi1x
@user-lm7mz8pi1x 6 ай бұрын
I have the same issues
@nadinefayed
@nadinefayed 2 жыл бұрын
hi how can i add quantity in vendor table and can see the stock remainnig in report
@hkiran3742
@hkiran3742 3 жыл бұрын
How to calculate subform base on sell types if credit price is more then cash bill.
@gokceediz
@gokceediz 2 жыл бұрын
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 :)
@SajjadAhmed-lc2dr
@SajjadAhmed-lc2dr 4 жыл бұрын
mr shad as a expert you should teach us data structure and algorithms
@tonanmaroc
@tonanmaroc 2 жыл бұрын
Thank you very much
@huzaifaniazi9145
@huzaifaniazi9145 3 жыл бұрын
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
@nadinefayed 2 жыл бұрын
hi i also need this
@iisdw5033
@iisdw5033 3 жыл бұрын
Thanks for share tutorial
@stephenchua2576
@stephenchua2576 2 жыл бұрын
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
@shadsluiter 2 жыл бұрын
No, sorry. Let's leave that for your challenge to complete.
@kris-eb8gv
@kris-eb8gv 2 жыл бұрын
so useful!!! thanks
@sulemanbutt152
@sulemanbutt152 3 жыл бұрын
i need help in retail application database which is to be made on MS Access
@patrick_527
@patrick_527 2 жыл бұрын
This is great!!!
@hkiran3742
@hkiran3742 3 жыл бұрын
Sir can u please help me with Customer type pricing
@khanleader
@khanleader 3 жыл бұрын
💖❤💖💖💖
@imssd664
@imssd664 2 жыл бұрын
kzfaq.info/get/bejne/aJd5g6uTzN6sp2Q.html رابط لنظام كامل روعه
@bumpersmith
@bumpersmith 3 жыл бұрын
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.
How to use Microsoft Access - Beginner Tutorial
31:07
Kevin Stratvert
Рет қаралды 3,1 МЛН
Access  Form With a Subform and Calculated Fields
31:58
Officeinstructor
Рет қаралды 69 М.
Look at two different videos 😁 @karina-kola
00:11
Andrey Grechka
Рет қаралды 15 МЛН
Running With Bigger And Bigger Feastables
00:17
MrBeast
Рет қаралды 155 МЛН
ROLLING DOWN
00:20
Natan por Aí
Рет қаралды 11 МЛН
Please Help Barry Choose His Real Son
00:23
Garri Creative
Рет қаралды 23 МЛН
Become a PRO at inZOI Original "M" Character Creation - (Soundless Create A Zoi Creator Tutorial)
3:45
MADAME FRAULEIN TALON CHARACTER CREATION TUTORIALS
Рет қаралды 1
Microsoft Access Tutorial - Beginners Level 1 (Quick Start)
26:21
Teacher's Tech
Рет қаралды 407 М.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 165 М.
Look at two different videos 😁 @karina-kola
00:11
Andrey Grechka
Рет қаралды 15 МЛН