How to use Microsoft Access - Beginners Course (Deep Dive)

you did wonderful explanation clear voice.

hey i have ben trying to get the excel file ,, how can i get it please

Great vid - short and to the point. Love it!!

Hi Jamie - loved loved loved your videos on Access. Any chance there are any others beyond the Lesson 1 & Deep Dive? My head is spinning, but both videos were great. Also - maybe it would be helpful for viewers if you indexed each one. Like which one should be first, second, and so on. Especially if you're planning to add more to your portfolio.

Thank you for a job well done I have struggled with table relationships and you made if much clearer. Thanks Well done.

Excellent! Thank you!

The best Tutorial on Access you can ever come across, very fluent and basic examples. Amazing amazing 😍😍😍

Super and helpful

You are a great teacher Jamie; thank you.

Good teacher.

After delivering L3 BTEC IT to a number of students over the past few years, I have to say the tutorials you have produced is helping in my delivery of content to my students. I have struggled to make the Pearson content less "dry", Thanks for the big assist!

Well Appreciated... Thanks

Many thanks!

This program is ridiculously and stupidly complex. I've always very much hated Access. Thought I'd give it a go again, and nope. Still extreme dislike for it. Soooooooooo much easier to just use Notion and be done with it.

Thank you for doing this tutorial vlog, It's easy to follow. Looking forward for another video regarding ms access part 3. More power.

Thank you! I appreciate the knowledge provided!

What's do you recommend after basic for beginners

Both your videos on Access have been really helpful, thank you very much for them. There is one function that seems to me to be basic but which you do not mention: how can I get some fields to automatically populate based on an earlier field? Example: I have a master list of all people. I want to add some of them to some new table e.g. they have booked to come to one of my concerts. I can select their first name as a drop down field. How can I make the surname (and any other fields I may need from their original data) populate automatically, rather than having to select them again manually from more drop down tables, with the risk of error? Thanks for any guidance.

And nothing has changed. Something in your validation rules that you setup causes my MS Access to freeze with the validation error message. Clicking Okay does not allow me to proceed wit correcting the entry.

Again I am having issues with Access not allowing me to proceed with an improper entry, I have to kill the program via task manager

AT 32.33 You say to enter the wrong status so that it shows you the error. My access locks up and clicking ok doesn't allow me to proceed with correcting the error. I literally have to open task manager and kill access.

wow this is the most amazing tutorials have come across it has open me up to alot

What if you have a long list of schools, for example 100+. Do you have to reference the School table/try to remember the School primary key to then use it in the Student table? Or is there an easy way to look up the correct School primary key to use in the Student table so the relationship is correct?

Great thank you. Had a problem following along and linking the tables as shown but saw both need to be same former of long integer. Thanks

What if Harry Potter attends three schools at the same time?

This tutorial and the beginners, I found amazing. The subject areas covered and the clarity of the presenter made it easy to follow. I needed to go back and learn the basics, because I have a task to migrate an Access procurement system to Microsoft Dataverse. This tutorial provided helped me refresh my knowledge. Thank!!

WONDEFUL TUT. IS THERE ANY MORE TURORIALS THAT GO INTO MORE COMMON FUNCTIONS?

The Waffle House has found it's new host

banging vid lad

Thank you so much for this amazing course :)

Me gustó demasiado el video! ahora por las clases de excel 😎😎

Thank you Jamie that was great. It all came flooding back to when I did my ECDL Microsoft Access course in 2005.

thanks a ton for this video

how to make access forms opens new record automaticly when I opn the form inorder to enter new data ?

Well organized and super pratical, thank you Jamie for the great videos. Looking forward to learning more advanced skills of Access from you.

Your the leader of a cult at my school lol

Thanks for all the work put into this video!

Thanks

hello! i wish to thank you for your great effort to educate us. bless you

Literally am going from using Ableton to soft and tNice tutorials helped trendously as a beginner. Thank you so so much for tNice tutorials!!

i recently Nice tutorialt softex on soft soft

It's a shame that Access is limited for complex calculation for summary comparing to pivot. In some previous access there was somehow a query pivot, but then it disappeared. Is there a way to have pivot in access, or we have manually move the data from access and work in excel to get the pivot?

rat thich giong cua ad, hay lam, clip hay

Thank you. you are a useful man

Thanks Jamie, though mine keeps on copying un necessary fields hence giving me error while importing. Guys any help over this?

Excellent. Thank you!

Thanks for this upload. I was looking for something but unable to find a way to do it. I have a database of professions types which has unique codes, job type, education level field in a database. I am looking for a way to make it a read only file or app on a customers tablet so they can search a specific record by those fields and see what kind of degree is required. Any help will be highly appreciated. I'm using office 2019.

Who needs Udemy when we have Access (Pun certainly intended) to Teachers Tech? Thank you Jamie!

Can i request a tutorial video, but its hard for me to explain. Can i send an image here to show you what i would like for the video tutorial. Ty. Or where i can send the image.?