@@LearnitTraining You are welcome. I appreciate those people who appreciate the holding of my keyboarding skills. Thank you for tapping or typing to me. Happy Keyboarding!
This was, by far, the best advanced Access tutorial I've seen. I've learned a lot. Thankfully, I only came across a few minor glitches (mostly errors on my part) that slowed me down a little. In Form/Report design view (Access 2024) I can only see major gridlines, not minor gridlines as displayed in your view. I can’t seem to find any way to change the gridlines size. I tried changing from 10 to 1 in Properties, but it had no effect. I’m wondering if the input mask in the phone number in the Customers table was affected by us importing data from the Excel file. I had to recreate the input mask. More. Because I’m using the UK version, I had to edit the input mask because it kept giving me a UK phone number type, giving me a US and UK phone number in the same table. Got there after a bit of messing about. For the remaining excercises, I left the formatting as is (£ instead of $) when formatting to currency. It's not as though you were testing me. 😉 2:05 onwards Am I the only one who noticed when you displayed the Order Summary Record for the final time in Record view and Print Preview, the Order Date (fields) disappeared? Fortunately, this never happened to me. Thank you for your time and effort.
Thank you! Excellent tutorial. Just have question: in a qryCustomers, if I type (ca OR or) and tab out I have the Alert "The expression you entered contains invalid syntax." If I use the right syntax ("ca" Or "or") I can run query. Where are these settings? Where I can fix it?
Thank you for your work! Can we get the updated files for this tutorial (2 of 3), like the database file? The files for download are the files for part 1.
How bad is it that a lot of this can be done in Notion, and much, much, much, MUCH easier...? I think that so far, I've only seen one thing that makes Access better. Forms. But Notion has so much ease of entry that I'm not entirely sure which one I want to use.
Thanks for the videos. Shame the exercise files do not have a folder with the completed files; as don't have time to waste going through each individual step. Please consider not all users will be absolute novices with countless hours to spend. EDIT - Have had to go back to 2019 files because the exercise files are inadequate.
@@LearnitTraining Thanks, also the exercise files are completely wrong, they are not an accurate reflection of what is being shown at the start of the tutorial. They need to be the primary keys in almost every table are of the wrong data-types. They've been left over from a previous lesson I imagine. Also problems with tblProducts > ProductManual field.Thanks again for the videos, the instructor does not draw it out too much; she's quite concise with just the right amount of detail.
I have never seen a material so detailed, high-quality, and step by step! AMAZING WORK!
Thank you for watching!
It is the most professional training I have ever seen in my life! thank you
Wow, thank you!
This show is really right up my niche. I use Microsoft Access 2021. This lesson is a godsend!
Thank you for continued support Captain Keyboard!
@@LearnitTraining You are welcome. I appreciate those people who appreciate the holding of my keyboarding skills. Thank you for tapping or typing to me. Happy Keyboarding!
Excellent tutorial, especially a tutorial that walks you thru step by step a complete database. Great! Thanks!
Glad it was helpful!
I have to admit, these videos are perfect. Thumbs up!
Wow, thanks!
Another great course that I can follow along and learn by doing. Well done
Thank you for watching!
Awesome! Reminds me of my college days in the US. This Access course is highly recommended!
Great to hear!
This was, by far, the best advanced Access tutorial I've seen. I've learned a lot. Thankfully, I only came across a few minor glitches (mostly errors on my part) that slowed me down a little.
In Form/Report design view (Access 2024) I can only see major gridlines, not minor gridlines as displayed in your view. I can’t seem to find any way to change the gridlines size. I tried changing from 10 to 1 in Properties, but it had no effect.
I’m wondering if the input mask in the phone number in the Customers table was affected by us importing data from the Excel file. I had to recreate the input mask. More. Because I’m using the UK version, I had to edit the input mask because it kept giving me a UK phone number type, giving me a US and UK phone number in the same table. Got there after a bit of messing about. For the remaining excercises, I left the formatting as is (£ instead of $) when formatting to currency. It's not as though you were testing me. 😉
2:05 onwards
Am I the only one who noticed when you displayed the Order Summary Record for the final time in Record view and Print Preview, the Order Date (fields) disappeared? Fortunately, this never happened to me.
Thank you for your time and effort.
Thank you for the amazing feedback!
1:27:33 Jazzy didn't show up since there were no orders associated with that customer.
Thanks a lot for this great work, access become an easy tool because of your videos🤗
You are very welcome!
Thank you! Excellent tutorial. Just have question: in a qryCustomers, if I type (ca OR or) and tab out I have the Alert "The expression you entered contains invalid syntax." If I use the right syntax ("ca" Or "or") I can run query. Where are these settings? Where I can fix it?
Hello Serguei! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
Thank you for your work! Can we get the updated files for this tutorial (2 of 3), like the database file? The files for download are the files for part 1.
Excellent tutorials.
54.13 I don't think that this is Many to Many.
Thanks for shared. Learn acces 21 and english vocabulary or grammar
You are welcome
Excellent video. Very clear explanation and pleasant voice👍👍🌹🌹.
Thank you! 😃
Thank you so much.
You are very welcome!
where is the link you mentioned sir.
thank you :)
You're welcome! 😀
Thankyou
You are welcome!
How bad is it that a lot of this can be done in Notion, and much, much, much, MUCH easier...? I think that so far, I've only seen one thing that makes Access better. Forms. But Notion has so much ease of entry that I'm not entirely sure which one I want to use.
We do have Notion in our production queue! It will be a little bit but it will be on the channel in the near future.
👍👍
👍👍
Thanks for the videos. Shame the exercise files do not have a folder with the completed files; as don't have time to waste going through each individual step. Please consider not all users will be absolute novices with countless hours to spend.
EDIT - Have had to go back to 2019 files because the exercise files are inadequate.
Thanks for the tip!
@@LearnitTraining Thanks, also the exercise files are completely wrong, they are not an accurate reflection of what is being shown at the start of the tutorial. They need to be the primary keys in almost every table are of the wrong data-types. They've been left over from a previous lesson I imagine. Also problems with tblProducts > ProductManual field.Thanks again for the videos, the instructor does not draw it out too much; she's quite concise with just the right amount of detail.