Access 2019 Advanced Tutorial

[@captainkeyboard1007]

This Microsoft 2019 lesson is right up my niche. I probably promoted from Access 2019 to Access 2022. Your narratives are clear and thorough, and not hard to understand.

[@LearnitTraining]

Great to see you learning so much Captain Keyboard!

[@captainkeyboard1007]

@@LearnitTraining Thank you for tapping or typing to me!👌

[@ccjl9160]

48:00 am I missing something here? We have a relationship between of CustomerID between tblCustomers and tblOrders where we have a number tblCustomers and text in tblOrders. This returns a type mismatch data error. After I align the types, the column is cleared in tblOrders and so the query returns nothing

[@LearnitTraining]

Hi ccjl! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com

[@ariefseo]

me too

[@ftn635]

I had to re-enter the data from the excel spreadsheet. Then I removed the relationship and returned the setting from number to short text. Finally, I joined company name to customer ID.

[@martinjm1]

Hi. Thank you for such good tutorials. On this video at 15:05 you say to go to form view. When I do that, i get a type mismatch error. The data from the Orders table came from the Excel file. There, in the excel file, in the orders sheet, the CustumerID field is filled with names, not numbers (Astro Advertising, Grappling grapes, etc). So in Access, when we do the relationships triying to match numbers with text doesnt work. Is that the error?

[@bsa492]

The same problem exists in the relationships between the Customer and Employee tables and the Categories and Products tables. In most of the tables, the "ID" field is an auto-generated number, while the related "ID" field in the foreign table is a text field containing words (folders, paper, electronics or company names, etc).

[@LearnitTraining]

Hi Martin - please rewatch the introduction as you maybe importing the wrong table query. We checked the exercise files and the excel data file and the columns are correctly aligning and filled with the proper data.

[@martinjm1]

@@LearnitTraining Thank you. I will try again.

[@lisaegan7022]

I had the same issue, so I deleted the form and started over from the beginning, and it worked fine. Strange, but...technology, what can ya do. lol

[@lisaegan7022]

@@bsa492 I am having the same issue. Hmm.

[@Joseph-Sumaili]

Watching from Zambia

[@LearnitTraining]

Thank you for watching Joseph!

[@aeronaftis4026]

Unfortunately I had the same problem the relationships of the boards do not work and hit. It is a pity while so much work has been done in the video and in the lessons for Access 2019. As a suggestion I think that the Office Suplies database should be included as a sample as you did correctly in the lessons for Access 2016. However, apart from the small problems of the samples , you have a very good job in explaining and learning Access 2019 and I look forward to doing something similar with Access 2021. Thanks again

[@LearnitTraining]

Hi Aero! We are actually working on fixing the exercise files for this course currently!

[@edmerzlak16]

@@LearnitTraining How long does it take to make the changes? The last copy was loaded to One Drive Oct 5 of last year!!!!

[@yeahnick4260]

"this expression was entered incorrectly or is too complex" that error appears exactly there : 2:48 after i "finished" What does that mean? what can i do to correct that?

[@LearnitTraining]

Hi Yeahnick! You can get your questions answered at Offsite, our online community - www.offsitebylearnit.com

[@t-love8351]

@@LearnitTraining just answer the qustion here.

[@kutlukul3841]

Thanks for this tutorial.

[@LearnitTraining]

You are very welcome!

[@sportsfan120577]

I keep getting "type mismatch in expression" when doing FrmOrders at the 15:00 mark. What am I doing wrong?

[@LearnitTraining]

Hi Enrique! You can get help at Offsite, our online community - www.offsitebylearnit.com

[@gpetty91]

I'm learning a lot BUT there were several issues early on in the course that prevented me from working along with your demonstrations. I think it all started with some import issue(s).

[@dalskiBo]

It's bad exercise files. The primary keys data-types are not synchronized. I agree that they should not be handing out bad data. They probably think they're doing right by forcing people to watch every minute of the video.

[@gpetty91]

@@dalskiBo That's what I was thinking.

[@دراساتاجتماعية-ز9ل]

Soft and rich your explanation

[@LearnitTraining]

Thank you for the kind words!

[@MicrosoftAccessHowTos]

Very nice video for beginners!

[@LearnitTraining]

Glad it was helpful!

[@shuaibification1]

There are issues with field setting 'data type'. Its sad after coming this far, things are not going smoothly and have to start from the begining. Good stuff though for beginners like us

[@ahmedbadawy4565]

Thank you for your video. It is intensive and cover a lot of greate points. If you can issue another video about Reportd explaining how we can create a report to peint it on a hard copy template. the template has a small squares to extract date from the DB and print each character in a square, R I C H A R D and a date 1 0 1 0 2 0 2 1 and so on. Thank you again for this excelent Video.

[@LearnitTraining]

Great suggestion!

[@PampostReturning]

Thank you 💖.

[@LearnitTraining]

You are so welcome!

[@youtubeform6383]

nice

[@LearnitTraining]

Thanks

[@RafaEl-uk1cw]

this is not advance

[@OmarMohamed-rq8ww]

Dark screen is making this tutorial 👎👎👎👎

[@LearnitTraining]

Hi Omar! Noted!