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!
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
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!!!
@@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.
Jamie..... Thank you for all your wonderful and informative training videos!!! Really love the Access training and looking forward to more advanced lessons. :)
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.
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!!
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?
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?
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.
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.?
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.
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.
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.
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?
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.
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.
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?
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) 😅❤😮
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.
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!
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
Thanks!
Thank you!
You are welcome great lesson. Did you ever do any more on Access ?@@TeachersTech
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.
Thank you Jamie that was great. It all came flooding back to when I did my ECDL Microsoft Access course in 2005.
I haven't used Access since my Information systems classes in college. Interesting video!
Thanks for watching!
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.
You are so welcome!
The best Tutorial on Access you can ever come across, very fluent and basic examples. Amazing amazing 😍😍😍
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
You're welcome!
Thank you so much for this deeper dive. Really appreciate it.
Glad it was helpful!
Best channel so far in TH-cam. Thanks a lot!
Awesome training! Thanks for providing this information
You bet!
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!!!
Great Job, whenever I get the chance always try to follow
Your videos, they are very well explained!!!
Awesome, thank you!
Me too 👍
@@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.
Jamie..... Thank you for all your wonderful and informative training videos!!! Really love the Access training and looking forward to more advanced lessons. :)
Thank you Peter. I’m glad you find the tutorials helpful.
@@TeachersTech Hi I also appreciate it. When is the intermediate/advanced content coming out?
whos here watching before taking their ecdl exam on access?
🙋♀️
Thank you for a job well done I have struggled with table relationships and you made if much clearer. Thanks Well done.
Great support, really enjoyed the training. What is the next video please?
Me gustó mucho, Gracias.
Phenomenal training. Thank you!
Thank you so much for this amazing course :)
Best tutorial and Very informative😃💯
Excellent video! Thank you.
you did wonderful explanation clear voice.
Thank you, it was helpful.
Thank you! I appreciate the knowledge provided!
I love the tutorial...ever best
Thank you very much.
Really amazing
Me gustó demasiado el video! ahora por las clases de excel 😎😎
You are a great teacher Jamie; thank you.
you are the best , I hope I will pass my exam.
This is such a great refresher course for me - thanks so much!
Super and helpful
Wow
This is super good
Thank you sir
Great vid - short and to the point. Love it!!
Good teacher.
Well Appreciated... Thanks
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.
Excellent. Thank you!
thank you so much! just earned a sub :)
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!!
Absolutely love this series on Access.
Glad you enjoy it!
rat thich giong cua ad, hay lam, clip hay
Thaks again , Jamie
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.
You're very welcome!
WONDEFUL TUT. IS THERE ANY MORE TURORIALS THAT GO INTO MORE COMMON FUNCTIONS?
So useful thank you
Glad it was helpful!
Thank you, Jamie.
thanks a ton for this video
What's do you recommend after basic for beginners
thanks for the share.
You're welcome!
Thanks for all the work put into this video!
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?
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?
Sorry I understand it's just to show an image. Geez brain went left lol
Thank you!
Thank you so much, Jamie. This was very beginner-friendly.
Where is the table Jamie? OK found it but did not follow how to copy and paste. Good work.
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.
I have the same question. Did you solve this problem?
banging vid lad
True dat
@@gamingjames6720 HEHE
hey i have ben trying to get the excel file ,, how can i get it please
Thanks
Literally am going from using Ableton to soft and tNice tutorials helped trendously as a beginner. Thank you so so much for tNice tutorials!!
hello! i wish to thank you for your great effort to educate us. bless you
can you please make a video about reports and quires as i have up coming exams
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.?
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.
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
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.
how to make access forms opens new record automaticly when I opn the form inorder to enter new data ?
Thank You for Sharing Access lesson from a to z
How can I make customized serial number that contains number and letters?
How can I download the practice files?
Effective presentation. Thank you.
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
What if Harry Potter attends three schools at the same time?
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.
Thank you. you are a useful man
Sir been waiting for your next video on access when will you be posting it?
Harry Potter is NOT a half blood, he is a full-blooded wizard! 😆
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?
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.
Who needs Udemy when we have Access (Pun certainly intended) to Teachers Tech? Thank you Jamie!
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?
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?
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) 😅❤😮
The Waffle House has found it's new host
WILLEH
@@ynbjamie8100 small pp energy
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.
Why do you seem to think we want to see you speaking on the screen!!!!!!!!!!!!!!!!!!!!!!
i recently Nice tutorialt softex on soft soft
Excellent! Thank you!
Many thanks!