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!

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

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

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

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

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

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

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

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!

Thank you! I appreciate the knowledge provided!

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

Thank you so much for this amazing course :)

Phenomenal training. Thank you!

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

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

Excellent. Thank you!

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

@TeachersTech

7 ай бұрын

Glad it was helpful!

rat thich giong cua ad, hay lam, clip hay

Thank you, Jamie.

thank you so much! just earned a sub :)

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

@TeachersTech

2 жыл бұрын

Thanks for watching!

you did wonderful explanation clear voice.

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!

Well Appreciated... Thanks

thanks a ton for this video

Thank you!

Best channel so far in KZread. Thanks a lot!

Many thanks!

You are a great teacher Jamie; thank you.

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

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

Super and helpful

Thaks again , Jamie

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

@TeachersTech

2 жыл бұрын

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?

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 vid - short and to the point. Love it!!

Good teacher.

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 so much, Jamie. This was very beginner-friendly.

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

2 жыл бұрын

You're very welcome!

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

@TeachersTech

2 жыл бұрын

Awesome, thank you!

@dawnasharples

2 жыл бұрын

Me too 👍

Absolutely love this series on Access.

@TeachersTech

2 жыл бұрын

Glad you enjoy it!

So useful thank you

@TeachersTech

2 жыл бұрын

Glad it was helpful!

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

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

thanks for the share.

@TeachersTech

2 жыл бұрын

You're welcome!

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

Thanks

Thanks for all the work put into this video!

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

7 ай бұрын

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

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

What's do you recommend after basic for beginners

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.

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

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

How can I download the practice files?

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

banging vid lad

@gamingjames6720

Жыл бұрын

True dat

@ynbjamie8100

Жыл бұрын

@@gamingjames6720 HEHE

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.

Thanks!

@TeachersTech

8 ай бұрын

Thank you!

@rolltron2160

8 ай бұрын

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

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

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

Effective presentation. Thank you.

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

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) 😅❤😮

Thank You for Sharing Access lesson from a to z

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

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.

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

Thank you. you are a useful man

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.

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

whos here watching before taking their ecdl exam on access?

@harpaireneandreea295

2 ай бұрын

🙋‍♀️

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.

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

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

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?

The Waffle House has found it's new host

@ynbjamie8100

Жыл бұрын

WILLEH

@endiogoen

Жыл бұрын

@@ynbjamie8100 small pp energy

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

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.

i recently Nice tutorialt softex on soft soft

Excellent! Thank you!