How to use Microsoft Access - Beginners Course (Deep Dive)
HTML-код
- Опубликовано: 1 авг 2024
- Dive deeper into how to use Microsoft Access in this beginner's course. This video builds on concepts from Microsoft Access Tutorial - Beginners Level. In this tutorial, you will learn how to set up and customize fields for your table in Microsoft Access, import data from an excel spreadsheet, create a 1 to many relationships with two tables, create a form with controllers and drop-drowns, get more specific with your queries in Microsoft Access, create a report based on a query and learn to export your data. Use the timestamps below to navigate the video.
Microsoft Access Tutorial - Beginners Level 1: • Microsoft Access Tutor...
Practice excel file: leveragingdigitalinc-my.share...
Microsoft query examples: support.microsoft.com/en-us/o...
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
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.
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 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
Thank you! I appreciate the knowledge provided!
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!
Thank you so much for this amazing course :)
Me gustó demasiado el video! ahora por las clases de excel 😎😎
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!!
Phenomenal training. Thank you!
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
This is such a great refresher course for me - thanks so much!
Thank you so much for this deeper dive. Really appreciate it.
Glad it was helpful!
The best Tutorial on Access you can ever come across, very fluent and basic examples. Amazing amazing 😍😍😍
Excellent. Thank you!
Thank you, Jamie.
thank you so much! just earned a sub :)
you are the best , I hope I will pass my exam.
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!
you did wonderful explanation clear voice.
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?
Thank you!
thanks a ton for this video
Best channel so far in RUclips. Thanks a lot!
Many thanks!
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?
Well Appreciated... Thanks
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!
rat thich giong cua ad, hay lam, clip hay
WONDEFUL TUT. IS THERE ANY MORE TURORIALS THAT GO INTO MORE COMMON FUNCTIONS?
Thank you so much, Jamie. This was very beginner-friendly.
You are a great teacher Jamie; thank you.
Thaks again , Jamie
Absolutely love this series on Access.
Glad you enjoy it!
I haven't used Access since my Information systems classes in college. Interesting video!
Thanks for watching!
Great vid - short and to the point. Love it!!
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 👍
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.
Super and helpful
Good teacher.
Thanks for all the work put into this video!
how to make access forms opens new record automaticly when I opn the form inorder to enter new data ?
thank you
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
What's do you recommend after basic for beginners
So useful thank you
Glad it was helpful!
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?
Literally am going from using Ableton to soft and tNice tutorials helped trendously as a beginner. Thank you so so much for tNice tutorials!!
can you please make a video about reports and quires as i have up coming exams
How can I make customized serial number that contains number and letters?
Thanks
thanks for the share.
You're welcome!
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.
hey i have ben trying to get the excel file ,, how can i get it please
How can I download the practice files?
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.?
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.
banging vid lad
True dat
@@gamingjames6720 HEHE
Thanks!
Thank you!
You are welcome great lesson. Did you ever do any more on Access ?@@TeachersTech
Thank You for Sharing Access lesson from a to z
hello! i wish to thank you for your great effort to educate us. bless you
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
Sir been waiting for your next video on access when will you be posting it?
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
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.
Thank you. you are a useful man
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) 😅❤😮
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.
whos here watching before taking their ecdl exam on access?
🙋♀️
Thanks Jamie, though mine keeps on copying un necessary fields hence giving me error while importing. Guys any help over this?
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.
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
WILLEH
@@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!