Access 2019 Beginner Tutorial

[@karieroper3130]

I used to be pretty good with Excel and Access but that was quite a few years ago. Thank you for the wonderful explanations. It brought a lot of it back.

[@LearnitTraining]

Glad it was helpful!

[@umara941]

Very well put together video. The instructor explained everything nicely and I was able to follow along without any issues.

[@LearnitTraining]

Glad you enjoyed it!

[@milissacardinallo9838]

Thank you. I have never used or seen anything in Access before. I left with a clear understanding of how it works. You got to the point and made a nice flow.

[@LearnitTraining]

Glad it helped!

[@gerhardschmid7537]

a very good and understandable video, a very clear voice although i am german i could really understand everything! A very goot video! Many compliments from Germany, Trish!

[@LearnitTraining]

Thank you very much!

[@gabrieldantas5636]

nice content. well explained. I am curious if we can run queries with codes like sql where you can choose things that are greater, different, etc

[@LearnitTraining]

This article may help: support.microsoft.com/en-us/office/access-sql-basic-concepts-vocabulary-and-syntax-444d0303-cde1-424e-9a74-e8dc3e460671

[@britneyology1]

A solution to Subscript error: Open Excel file in Excel, export Customers page as CSV, append table in access. The first line of data is lost during import, manually enter. May just be the empty email field in first-line causing the issue, but this workaround worked.

[@nickfvas]

My work around was to change the yes/no data type for Active to short text

[@prankapp7808]

Hi Dear! Thank you for teaching me Access 2019 i really learn something new, I have a question when i import external data i chose like you tblCustomers and click to finish i get an error display (Subscript out of range) may you help me please solve it?

[@LearnitTraining]

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

[@mathews-q3k]

@@LearnitTraining could you just answer here if possible. I had same problem and didnt get a reply in offsite. Tnx

[@Spankyflyer]

Hi, What I did. tblCustomers change the ACTIVE field to number. Now do the import, once the import is done change it to YES/NO. That seems to work. The email might be a problem as well change to text, then revert back to Hyperlink.

[@marcushammer1387]

It is probably because the table in Excel has EMail datatype set to ShortText and Active set to Number. What worked for me was to delete the table and then import it with the data using the method used for the other tables. Then, change Email and Active to the datatypes that were described when creating the table manually - that is Hyperlink and Yes/No respectively.

[@pon00050]

Hello, all. I am leaving a note for anyone who may see this in the future. What Koos Delport in this thread suggested did not work for me. So I had to try the solution provided by Marcus Hammer and I finally had it working and happily proceeded to the next step. I know how something not working early on in the learning process can be discouraging. Kudos to you for making it this far and do not give up just yet! You have already done the first half of this video tutorial!

[@tonykutch4877]

Using MS365. Did have the subscript out of range issue others encountered, but splitting the customer worksheet out into its own workbook seemed to resolve that issue. I haven’t however resolve a query wizard issue tied to modification of the ProductManual data type to ‘attachment’. After that change, Access stops responding immediately upon selecting the products table, regardless of how focus arrived there. Query builds correctly without the attachment data type.

[@LearnitTraining]

Hi Tony! You can get help directly from our instructors at Offsite - our free online community - www.offsitebylearnit.com

[@michapodlaszuk9025]

When trying to import from excel to customers table I got 'subscript out of range error :/

[@LearnitTraining]

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

[@britneyology1]

@@LearnitTraining That's not a helpful answer. Spending time finding it and can't move forward. Thanks. Maybe a link to the specific solution would inspire more people to join the community.

[@shuaibification1]

@@britneyology1 I had the same issue, and I struggled hard without success. Finally I deleted the table "tblCustomers' and created a new one. And it worked. Bye bye "subscript out of range'

[@pmsteamrailroading]

Just once I would love to see someone use the caption property for a field in a table. It makes almost half the work of setting up a form or report go away. Suddenly the titles for the fields all make sense, and are consistent throughout the application.

[@shakeel447]

Very use and informative videos.

[@LearnitTraining]

Thank you for watching!

[@ayeoh47]

This is by far the best access course on KZbin. Or in general for that matter

[@LearnitTraining]

Wow! Thank you so much!

[@berlynhale3780]

Thanks for your regular information videos, just keep up the great work going and all crypto lovers informed.

[@toddbarber7950]

I trade feature on a better exchange with lesser fees, I am glad to say I was able to do that with the help of Mr Richard, he is so kind and good in tradings.

[@mattmanson1077]

I never doubted trading with Richard Morgan after seeing his POT (Proof of Trade) I have made good profit this year, I hope to make much more in future.

[@aakeshmayan5694]

÷➊➐➐➌➏➍➍➒⓪➊➎)

[@millitarypowerbase2875]

Trading Crypto now would be wise but trading without a professional is really bad I'ma living testimony of Expert Richard strategies

[@jennyfranciscan5033]

With the consistent weekly profits I'm Investing with Sir Richard, there's no doubt he is the most reliablein the market, such a genius....

[@mukangalah]

56:06 my attempt to import customers table from excel to access give a prompt "script out of range" where I'm I going wrong?

[@LearnitTraining]

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

[@t-love8351]

@@LearnitTraining just answer the question here.

[@tonykutch4877]

I had success importing customer data by using Excel to copy the relative worksheet out into its own workbook (I just called it ‘import customers’), then executed the external data import as directed.

[@bargeld09]

I'm stuck on 43:36 importing Data. Can any advice?

[@LearnitTraining]

Hi Marilea! You can ask your question at Offsite, our online community - www.offsitebylearnit.com

[@t-love8351]

@@LearnitTraining just answer the question here.

[@sportsfan120577]

I have the same problem. I'll just try another channel

[@Conversation_Guy]

Hey, would there happen to b a list of common reports that are created via Access?

[@washington_dc]

Is it possible to put eletronic signature on a access report. What I need is s signature from an employee to prove that he received something. I produce automatically a document on access and need his signature. Is that possible. Thank you. ❤️❤️

[@LearnitTraining]

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

[@rolandmansaray]

Am unable to continue the class where its says tblCostomers because of (Subscribed time out) this is what popup the import spreadsheet wizard..

[@tuamaleos4519]

Please share MS Access File Monitoring Stock In Out Material at Warehouse. Thanks

[@dalskiBo]

Thank you; excellent content & beautifully concise.

[@LearnitTraining]

You're very welcome!

[@stoni2079]

Thank you for the video. It is very helpful for beginners.

[@LearnitTraining]

You are welcome!

[@AusFastLife]

Hi, Can I ask, what is the difference between your Access 2019 tutorials and your Access tutorials? I would like to learn access but I know nothing about it and so I don't get what the distiction would be. I see the Access tutorials have upwards of 18 hours of material. I would hate to do that only to find that it is out dated and I needed the Access 2019 instead, though I am not sure that is even how it works?! I am a bit confused I am sorry.

[@LearnitTraining]

Hi Haydn! The core of Access remains relatively unchanged from version to version. We try to have training available in all versions so that it is more relevant to you.

[@adrianseconds3669]

i love her voice, reminds me of the fantasy audio books i used listen to, keeps me from zoning out.

[@LearnitTraining]

Thank you for watching!

[@crisolivares7847]

Hey guys thank you for such an amazing content I love your channel

[@LearnitTraining]

You are very welcome Cris!

[@printwrl6609]

A very excellent class

[@LearnitTraining]

Many thanks!

[@Dida2080]

Amazing rich content..

[@LearnitTraining]

Appreciate it!

[@alexikamran7039]

cant open files. could you share google drive link

[@LearnitTraining]

Hi Alexi! We just tested the link and it is working currently. We do not have any plans currently to use google drive.

[@nikitavodonaev4303]

Hello! Are the exercise files intentionally not available? Otherwise, amazing tutorial!

[@LearnitTraining]

www.learnitanytime.com/p/exercise-files-access-2019-beginner-tutorial

[@nikitavodonaev4303]

@@LearnitTraining Thank you very much, its hard to believe that nowadays someone would give such high quality courses for free

[@neilmcnicol6506]

There is a lot of inconsistencies on the part of the tutor, in this tutorial.

[@washington_dc]

Muito bom. Recomendo, está me ajundando

[@LearnitTraining]

Obrigado!

[@Diyarwanda]

Even i don't have information about it but you are very intelligent more than how they think

[@RixtronixLAB]

Nice video, thanks :)

[@LearnitTraining]

Thank you Rixtronix!

[@jeetendrasinghbhadauriya3395]

thank you very much

[@LearnitTraining]

You are welcome

[@waleedtawfeek9626]

any idea about the tutor?

[@dalskiBo]

Trish Conner-Cato; very good.

[@PampostReturning]

Thank you 💖.

[@LearnitTraining]

You are so welcome

[@ahmedomar9804]

Thanks❤❤❤❤

[@LearnitTraining]

You're welcome 😊

[@HarveyWatson-ho5ey]

I had to create a mask for the phone number

[@LearnitTraining]

👍

[@usmanaziz1679]

I want to watch

[@HousseinDroubi-o9i]

Hi there.

[@LearnitTraining]

Hello!

[@kousikdey62]

So much confusion excel, power bi, access, google sheets & what more

[@LearnitTraining]

Hi Kousik! We do have videos on many of the most popular software for the workplace!

[@nabiilusongolo3329]

yiou owe me alot

[@mangpanji4193]

Kami akanmeberikan setelah pidio tehubung agar dapat memastikan komentar

[@LearnitTraining]

Apa yang ingin Anda konfirmasi?

[@ashvinisingh7769]

I'm watching