What an awesome, simple, yet informative video that I got sent along with my assignment!! Your voice is so soothing unlike the other tutorialists and you are a champ in explaining and demonstrating all of this and as such I will defo subscribe to you.
Sir, God bless the day I discovered you on your RUclips Platform. I have been struggling for a while with Structured Query Language (MySQL) without knowing that MS Access is the foundation. I never crossed path with MS Access even though I have a master degree in Construction Management! You have streamlined my on going self development learning process in data management. Thank you.Thank you. Thank you.
ExcelIsFun Mike Im one of the best in Excel in our country and this is because of you. I wish to see you onetime. Thanks alot for all of your trainings.
Very informative, Mike. I wonder - at 36:30 or so when it asks for a supplier code, is there a way to have a drop-down box which lists the allowable entries?
FYI, when in the query grid you can quickly bring up the Zoom window by hitting F2. Easy to remember as it's so similar to what you do in Excel when you want to edit cells.
Thanks Mike, besides the awsome explanations of you, I also saw something I never saw or was aware of: If you are in "edit mode" and enter a value without TAB or ENTER, and just go to another view, it is accepted. For curiosity I just tried this in Excel and the behaviour is the same, by switching to another sheet :)
thank you, this has helped me a lot. However, I have a fairly complicated query I'm trying to work out. I just can't figure it out. I have all but one aspect worked out. What I'm trying to do is a time clock system. Our system uses 87 to indicate clocking in, and 88 for clocking out. So I have a query to display the employee with a date range for the week and only displaying 87's and 88's for that employee. Now what I just can't figure out is the formula is to do the subtraction of 88 time from 87 time for each day and total the week. The table this is working from is a daily log for the employee so that is what the codes are for there are hundreds of codes given so I have to use the query for 87 and 88 or there would be hundreds of entries per day. I am completely lost on this, any help would be appreciated.
Thank you so much. And I have a question about Excel - hiding sheets. when i hide a sheet and protect workbook then nobody can unhide the sheet. but anybody can upload it to google drive and easily unhide the hiden sheet on google sheets. what solution could you recommend me? thanks in advance.
When you created the "OR" query I would just do it all on one line. Using separate rows is too consuming when you have many items you want to bring back.
Me too, but I try to teach the concepts of Advanced Filter, D Functions and Access Query all at same time. Plus, for beginners, it indirectly teaches that AND is on same line...
They are different, Access is a small SQL database with a user interface - it can do very specific tasks well. Excel can do anything, and on-the-fly analysis and make-it-up-as-you-go-along creates are what make Excel so amazing, especially now with Power Query and PowerPivot.
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
Michael, I have been following you for years, first for Excel now Access.... you are an awesome educator - Thank you!!!
What an awesome, simple, yet informative video that I got sent along with my assignment!! Your voice is so soothing unlike the other tutorialists and you are a champ in explaining and demonstrating all of this and as such I will defo subscribe to you.
Glad you like it : )
This is the best video about MS Access I've ever watched !
Sir, God bless the day I discovered you on your RUclips Platform. I have been struggling for a while with Structured Query Language (MySQL) without knowing that MS Access is the foundation. I never crossed path with MS Access even though I have a master degree in Construction Management! You have streamlined my on going self development learning process in data management. Thank you.Thank you. Thank you.
Excellent Video as I prepare for my Mos Access 2016 Exam.
Thanks for the query examples Mike!
You are welcome!
Superb great 👍 explanations, I love your teaching
this video is super helpful. Can't thank you enough.
Thanks, now I can learn more about Access.
Superb work EXCELlent Mike :)
Thanks for the EXCEllent comment : )
Great examples!
Glad the examples help!
Yay!!!!! I can finally learn!!! Thank you so very much!!!
You are welcome! Thanks for the support with your comment, Thumbs Up and Sub: )
It was really useful. I love your trainings. Im from Iran and I would like to invite you to our country.
You are welcome to the teachings! If I were ever to go to Iran, I would love to come and visit : )
ExcelIsFun Mike Im one of the best in Excel in our country and this is because of you. I wish to see you onetime. Thanks alot for all of your trainings.
Now, I start to learn Access because i like wherever that you teach.
You are welcome for the training. I hope you can comment and Thumbs Up on ever video that you watch : )
I am glad that the videos and file help : )
The Midget Railroad.... I can't help but laugh hahaha. Great material as always Mike! +1 Like from me!!!!
Very informative, Mike. I wonder - at 36:30 or so when it asks for a supplier code, is there a way to have a drop-down box which lists the allowable entries?
I am pretty sure that there is, but I am not an Access expert so I do not know : (
Thank you!
OMG thank u so much for the video Mr. Mike it was more than fun so much to learn i really appreciate it
You are welcome!
Great video Mike!
Glad you like it!
Great one Mike
Glad you like it, John : )
FYI, when in the query grid you can quickly bring up the Zoom window by hitting F2. Easy to remember as it's so similar to what you do in Excel when you want to edit cells.
Love it!!! Thanks for the F2 : )
Helo thanks for your video , and You have more examples like this
Thanks Mike, besides the awsome explanations of you, I also saw something I never saw or was aware of: If you are in "edit mode" and enter a value without TAB or ENTER, and just go to another view, it is accepted. For curiosity I just tried this in Excel and the behaviour is the same, by switching to another sheet :)
Cool : ) Yes, the difference is that in Access it is actually saved to the computer without Save, but in Excel it is still not saved yet...
Thanks for your video, Mike. Please let me know if I have a table in Access and I want to update it by import data from Excel Table. Thank you.
Thanks
You are welcome, clifford!
good one
Glad you like it!
Greeting from iraq very adrobale lessen
how do you perform tasks like either this or this? for example costumers who are representative by representative 15 or credit limit 10000
Awesome! Thank You very much. What if I need to get drop down for a parameter. Is there a way.
Thanks once again.
thank you, this has helped me a lot. However, I have a fairly complicated query I'm trying to work out. I just can't figure it out. I have all but one aspect worked out.
What I'm trying to do is a time clock system. Our system uses 87 to indicate clocking in, and 88 for clocking out. So I have a query to display the employee with a date range for the week and only displaying 87's and 88's for that employee. Now what I just can't figure out is the formula is to do the subtraction of 88 time from 87 time for each day and total the week.
The table this is working from is a daily log for the employee so that is what the codes are for there are hundreds of codes given so I have to use the query for 87 and 88 or there would be hundreds of entries per day.
I am completely lost on this, any help would be appreciated.
Thank you so much. And I have a question about Excel - hiding sheets. when i hide a sheet and protect workbook then nobody can unhide the sheet. but anybody can upload it to google drive and easily unhide the hiden sheet on google sheets. what solution could you recommend me? thanks in advance.
I have zero idea how Google sheets and Excel interact. Sorry.
When you created the "OR" query I would just do it all on one line. Using separate rows is too consuming when you have many items you want to bring back.
Me too, but I try to teach the concepts of Advanced Filter, D Functions and Access Query all at same time. Plus, for beginners, it indirectly teaches that AND is on same line...
Thumbs up :-)
Thanks you!
ExcellsFun > AccesssFun! ;-)
Very much TRUE!!!!
Till now, may I conclude that Access is just a little, not much, better than excel?
They are different, Access is a small SQL database with a user interface - it can do very specific tasks well. Excel can do anything, and on-the-fly analysis and make-it-up-as-you-go-along creates are what make Excel so amazing, especially now with Power Query and PowerPivot.
uuuuuu who put my name yusra nox ahhhhhhhhhh
P