Access 2021 Advanced Tutorial

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 ธ.ค. 2024

ความคิดเห็น • 42

  • @victorwestmann
    @victorwestmann ปีที่แล้ว +11

    I have never seen a material so detailed, high-quality, and step by step! AMAZING WORK!

  • @lulumbaso
    @lulumbaso ปีที่แล้ว +4

    It is the most professional training I have ever seen in my life! thank you

  • @captainkeyboard1007
    @captainkeyboard1007 2 ปีที่แล้ว +5

    This show is really right up my niche. I use Microsoft Access 2021. This lesson is a godsend!

    • @LearnitTraining
      @LearnitTraining  2 ปีที่แล้ว

      Thank you for continued support Captain Keyboard!

    • @captainkeyboard1007
      @captainkeyboard1007 2 ปีที่แล้ว

      @@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!

  • @rayt6867
    @rayt6867 2 ปีที่แล้ว +4

    ​Excellent tutorial, especially a tutorial that walks you thru step by step a complete database. Great! Thanks!

  • @shaojuanzhang1834
    @shaojuanzhang1834 7 หลายเดือนก่อน +2

    I have to admit, these videos are perfect. Thumbs up!

  • @samm6626
    @samm6626 ปีที่แล้ว +3

    Another great course that I can follow along and learn by doing. Well done

  • @PauloHenriqueFernandesFigueire
    @PauloHenriqueFernandesFigueire ปีที่แล้ว +2

    Awesome! Reminds me of my college days in the US. This Access course is highly recommended!

  • @ianl1052
    @ianl1052 8 หลายเดือนก่อน +1

    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.

    • @LearnitTraining
      @LearnitTraining  8 หลายเดือนก่อน

      Thank you for the amazing feedback!

  • @kylelarson7741
    @kylelarson7741 9 หลายเดือนก่อน

    1:27:33 Jazzy didn't show up since there were no orders associated with that customer.

  • @chkader87
    @chkader87 ปีที่แล้ว +2

    Thanks a lot for this great work, access become an easy tool because of your videos🤗

  • @sergueikhous5873
    @sergueikhous5873 ปีที่แล้ว +1

    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?

    • @LearnitTraining
      @LearnitTraining  ปีที่แล้ว +1

      Hello Serguei! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/

  • @lucys4312
    @lucys4312 2 ปีที่แล้ว +1

    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.

  • @clophillhistory9361
    @clophillhistory9361 2 ปีที่แล้ว +1

    Excellent tutorials.
    54.13 I don't think that this is Many to Many.

  • @alexandrel.pradesllobet5125
    @alexandrel.pradesllobet5125 ปีที่แล้ว +1

    Thanks for shared. Learn acces 21 and english vocabulary or grammar

  • @kebincui
    @kebincui 2 ปีที่แล้ว +1

    Excellent video. Very clear explanation and pleasant voice👍👍🌹🌹.

  • @marialaskowska2752
    @marialaskowska2752 2 ปีที่แล้ว +1

    Thank you so much.

  • @HakizPicturesPro2706
    @HakizPicturesPro2706 ปีที่แล้ว

    where is the link you mentioned sir.

  • @sabermmirza
    @sabermmirza ปีที่แล้ว +1

    thank you :)

  • @AseemHaruray
    @AseemHaruray 2 ปีที่แล้ว +1

    Thankyou

  • @SennaCrow
    @SennaCrow ปีที่แล้ว +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.

    • @LearnitTraining
      @LearnitTraining  ปีที่แล้ว +1

      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.

  • @sheltonsmith-o1v
    @sheltonsmith-o1v 8 หลายเดือนก่อน +1

    👍👍

  • @dalskiBo
    @dalskiBo 2 ปีที่แล้ว +2

    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
      @LearnitTraining  2 ปีที่แล้ว

      Thanks for the tip!

    • @dalskiBo
      @dalskiBo 2 ปีที่แล้ว +1

      @@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.