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

[@nigelhopkinson3354]

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!

[@promise2143]

Wow. This tutorial was lit. It has highly improved my impression on this application. Thank you for the program.

[@dagspk]

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

[@rluxon]

I have been wanting to learn MS Access for years, but no one explained it well. Thank you for taking the time to teach all of us these amazing programs. I finally get it!!!

[@JulieAnnCastellano]

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

[@DemetriPanici]

I haven't used Access since my Information systems classes in college. Interesting video!

[@TeachersTech]

Thanks for watching!

[@johnrhule3489]

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

[@BumpyWorld90]

Best channel so far in KZbin. Thanks a lot!

[@shangyili2557]

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

[@TeachersTech]

You are so welcome!

[@rolltron2160]

Thanks!

[@TeachersTech]

Thank you!

[@rolltron2160]

You are welcome great lesson. Did you ever do any more on Access ?@@TeachersTech

[@finnleyfe_leaves]

whos here watching before taking their ecdl exam on access?

[@harpaireneandreea295]

🙋‍♀️

[@samm6626]

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

[@TeachersTech]

You're welcome!

[@vmt2379]

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

[@justandy_81]

Great support, really enjoyed the training. What is the next video please?

[@stardommansion6773]

0:00 Introduction 0:48 Why use Microsoft Access 2:44 Create a blank database 3:43 Create a table and add fields for students 8:06 Add a record to the student table 10:32 Import data from excel spreadsheet into a created table 13:19 Import data from excel spreadsheet into a new table 14:58 Create a relationship between tables (one to many) 22:56 Customize table fields in Microsoft Access 34:56 Create a form 37:05 Create a form with the form wizard 38:06 Customize the look of your form 45:47 Add a combo box to your form 49:55 Add an image to your form 51:05 Add command buttons to your form in Microsoft Access 56:16 Add a record with your form 57:30 Using Sort in your tables 58:59 Creating queries in Microsoft Access 1:03:33 Adding criteria to your query 1:07:06 How to use parameters and wildcards in your queries 1:10:50 Using the greater, less than or equal in the criteria 1:13:29 Create a report form a query 1:18:16 Export tables, forms queries, and reports

[@Danny-bbsrSingh]

Great Job, whenever I get the chance always try to follow Your videos, they are very well explained!!!

[@TeachersTech]

Awesome, thank you!

[@dawnasharples]

Me too 👍

[@Milosmon863]

@@TeachersTech I'm dyslexic and sometimes the way info is laid out is such an issue, but never had this with any of your videos. Have directed dyslexic friends to your videos on all kinds of learning and they all find them workable(which in a non-dyslexic learning world) is a huge compliment.

[@PlantBasedPietro]

Jamie..... Thank you for all your wonderful and informative training videos!!! Really love the Access training and looking forward to more advanced lessons. :)

[@TeachersTech]

Thank you Peter. I’m glad you find the tutorials helpful.

[@OriginalJoseyWales]

@@TeachersTech Hi I also appreciate it. When is the intermediate/advanced content coming out?

[@nicolerobinson4868]

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?

[@Etruth907]

Awesome training! Thanks for providing this information

[@TeachersTech]

You bet!

[@rudrapratapbasu5299]

Thank you so much for this deeper dive. Really appreciate it.

[@TeachersTech]

Glad it was helpful!

[@stephenbordenkircher3575]

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

[@Mily-ql1eo]

Phenomenal training. Thank you!

[@grahambrown5874]

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

[@annelias4378]

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.

[@ninanovikov3201]

you are the best , I hope I will pass my exam.

[@melaniebrown8444]

You are a great teacher Jamie; thank you.

[@lonylony4139]

Thank you so much for this amazing course :)

[@gladenacole1524]

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

[@arthealthhealing6249]

What's do you recommend after basic for beginners

[@AndieGuess]

At 50:05 you show to insert magic wand. MS Access doesn't show that option, it has browse and for me to insert one of my images. I've searched google and come up with nothing. How did you get magic wand in your copy of MS Access?

[@AndieGuess]

Sorry I understand it's just to show an image. Geez brain went left lol

[@mikeglloyd]

Where is the table Jamie? OK found it but did not follow how to copy and paste. Good work.

[@sgit1]

This is such a great refresher course for me - thanks so much!

[@michaelkiakirino-hd3do]

Best tutorial and Very informative😃💯

[@marcioalvarez5010]

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

[@philprice1959]

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.

[@meindertatedejong5578]

I have the same question. Did you solve this problem?

[@VictorFinley-v8z]

Excellent video! Thank you.

[@tommypams]

Thank you, it was helpful.

[@AnitahKobusinge]

Wow This is super good Thank you sir

[@belleame1064]

Thank you! I appreciate the knowledge provided!

[@brashamathu]

you did wonderful explanation clear voice.

[@simoiyahector-morales3781]

Absolutely love this series on Access.

[@TeachersTech]

Glad you enjoy it!

[@jontnoneya3404]

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

[@AimpactAimpact]

Really amazing

[@adrikojoel14]

I love the tutorial...ever best

[@AkinAkinsanya]

Thank you so much for these videos. I haven't used access in a long time so I'm wanting to get back into it and your videos have been very helpful.

[@TeachersTech]

You're very welcome!

[@ynbjamie8100]

banging vid lad

[@gamingjames6720]

True dat

[@ynbjamie8100]

@@gamingjames6720 HEHE

[@samuelfranciscogarcia1440]

Me gustó mucho, Gracias.

[@AI_ACCELERATION]

Thank you very much.

[@rashaalkhamran9988]

can you please make a video about reports and quires as i have up coming exams

[@mehmedkukavica8076]

Excellent. Thank you!

[@orville-gj6be]

Well Appreciated... Thanks

[@likithsreedhar3996]

Super and helpful

[@LOYTHEANY]

Good teacher.

[@ubestgallery7635]

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

[@Worr69420]

thank you so much! just earned a sub :)

[@osamaalbalad4456]

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

[@hannahjoy4857]

Thanks for all the work put into this video!

[@AndieGuess]

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.

[@jesuis2508]

How can I make customized serial number that contains number and letters?

[@odongoambrose5433]

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

[@TheWildheartmicaela]

Can you help me create a student database with guardian info and class info or where can i find a template its for a church

[@AndieGuess]

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.

[@dawnasharples]

So useful thank you

[@TeachersTech]

Glad it was helpful!

[@fajenkpchiwi4071]

rat thich giong cua ad, hay lam, clip hay

[@omoshalewamuhammed1794]

Thank you so much, Jamie. This was very beginner-friendly.

[@equalrights9091]

Thank you, Jamie.

[@georgekennedy1886]

Thaks again , Jamie

[@SyedMuzammilMahasanShahi]

thanks for the share.

[@TeachersTech]

You're welcome!

[@haroune711]

thanks a ton for this video

[@AndieGuess]

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

[@anwar6971]

How can I download the practice files?

[@rulypanda5318]

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

[@thomasfrimpong2257]

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

[@uniquesimplify3356]

Thank You for Sharing Access lesson from a to z

[@LiamBriggs18]

Hey Jamie, I'm trying to create manual invoices for my workplace. I'm wondering if I can create a database of contacts in Access, import a selected contact into an Excel file for an invoice and then create a record of each invoice generated. Is there a way to streamline this process or will it all have to be done manually?

[@joukenienhuis6888]

Hi Liam, I don’t know if you already found a solution, but if you don’t need too complicated calculations, you can make your information system all in MS Access. Just make a table for your orders with the clients ID per order. Make a query of your orders per client and use that query for a report. And if you have made the order table, you can also make a report from your order table and consider each order as an invoice.

[@jianacope8002]

Thank you!

[@roberth.9558]

Effective presentation. Thank you.

[@nileshsharma9668]

Sir been waiting for your next video on access when will you be posting it?

[@michaellukes2580]

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

[@joukenienhuis6888]

The way the example is used in this tutorial,you will get an error message. This example database is designed as a many to one table relational database. This means that many students can only attend 1 school and you must read it as every student. These relationships can be read the other way around too as in that on 1 school many students can attend, but every student must be unique. There are double double names allowed. So if you want to make it possible that students (many) may attend more than 1 (many) schools, you must change the relations of the example to a many to many relationship. To do that, you must create an extra table containing the studentID and the schoolID and relate both IDs as a 1 to many relation with the corresponding table.

[@halkawtmohammed3445]

Thank you. you are a useful man

[@kakoozawilliam00]

Thanks

[@phanorkner]

Harry Potter is NOT a half blood, he is a full-blooded wizard! 😆

[@abubakr5063]

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.

[@greenlife-gardens]

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

[@stanleyk2292]

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

[@tutsecret499]

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?

[@SennaCrow]

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.

[@Dulce2393]

Here's an idea.... database of employees, with the ability to store scanned pdfs of certifications that have a preview pane to view these certificates... also showing when they were certified, when that certification expires, and be able to query or print a cover sheet with their profile and a copy of all uploaded certificates (per category) 😅❤😮

[@endiogoen]

The Waffle House has found it's new host

[@ynbjamie8100]

WILLEH

[@endiogoen]

@@ynbjamie8100 small pp energy

[@kathleen9185]

Why do you seem to think we want to see you speaking on the screen!!!!!!!!!!!!!!!!!!!!!!

[@XiaoHC]

i recently Nice tutorialt softex on soft soft

[@arrison259]

Excellent! Thank you!

[@alexserghill]

Many thanks!