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

Поділитися
Вставка
  • Опубліковано 30 січ 2025

КОМЕНТАРІ • 124

  • @nigelhopkinson3354
    @nigelhopkinson3354 Рік тому +3

    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!

  • @dagspk
    @dagspk Рік тому +5

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

  • @JulieAnnCastellano
    @JulieAnnCastellano Рік тому +2

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

  • @promise2143
    @promise2143 9 місяців тому +3

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

  • @rluxon
    @rluxon 2 роки тому +4

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

  • @DemetriPanici
    @DemetriPanici 3 роки тому +11

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

  • @johnrhule3489
    @johnrhule3489 2 роки тому +1

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

  • @vmt2379
    @vmt2379 Рік тому +1

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

  • @shangyili2557
    @shangyili2557 2 роки тому +3

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

  • @samm6626
    @samm6626 2 роки тому +3

    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

  • @rudrapratapbasu5299
    @rudrapratapbasu5299 Рік тому +1

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

  • @BumpyWorld90
    @BumpyWorld90 3 роки тому +2

    Best channel so far in UA-cam. Thanks a lot!

  • @Danny-bbsrSingh
    @Danny-bbsrSingh 3 роки тому +6

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

    • @TeachersTech
      @TeachersTech  3 роки тому

      Awesome, thank you!

    • @dawnasharples
      @dawnasharples 3 роки тому

      Me too 👍

    • @Milosmon863
      @Milosmon863 3 місяці тому

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

  • @rolltron2160
    @rolltron2160 Рік тому +1

    Thanks!

    • @TeachersTech
      @TeachersTech  Рік тому

      Thank you!

    • @rolltron2160
      @rolltron2160 Рік тому

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

  • @Etruth907
    @Etruth907 2 місяці тому +1

    Awesome training! Thanks for providing this information

  • @grahambrown5874
    @grahambrown5874 2 роки тому +1

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

  • @stephenbordenkircher3575
    @stephenbordenkircher3575 Рік тому

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

  • @PlantBasedPietro
    @PlantBasedPietro 3 роки тому +12

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

    • @TeachersTech
      @TeachersTech  3 роки тому +2

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

    • @OriginalJoseyWales
      @OriginalJoseyWales 2 роки тому

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

  • @rulypanda5318
    @rulypanda5318 2 роки тому

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

  • @michaelkiakirino-hd3do
    @michaelkiakirino-hd3do 4 місяці тому

    Best tutorial and Very informative😃💯

  • @sgit1
    @sgit1 2 роки тому +3

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

  • @ninanovikov3201
    @ninanovikov3201 10 місяців тому

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

  • @justandy_81
    @justandy_81 17 днів тому

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

  • @AkinAkinsanya
    @AkinAkinsanya 3 роки тому +2

    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.

  • @stardommansion6773
    @stardommansion6773 10 місяців тому +3

    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

  • @annelias4378
    @annelias4378 Рік тому +5

    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.

  • @lonylony4139
    @lonylony4139 2 роки тому +1

    Thank you so much for this amazing course :)

  • @marcioalvarez5010
    @marcioalvarez5010 2 роки тому

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

  • @Mily-ql1eo
    @Mily-ql1eo 7 місяців тому

    Phenomenal training. Thank you!

  • @brashamathu
    @brashamathu Рік тому

    you did wonderful explanation clear voice.

  • @simoiyahector-morales3781
    @simoiyahector-morales3781 3 роки тому +1

    Absolutely love this series on Access.

  • @VictorFinley-v8z
    @VictorFinley-v8z 4 місяці тому

    Excellent video! Thank you.

  • @belleame1064
    @belleame1064 Рік тому

    Thank you! I appreciate the knowledge provided!

  • @tommypams
    @tommypams Місяць тому

    Thank you, it was helpful.

  • @AnitahKobusinge
    @AnitahKobusinge 5 місяців тому

    Wow
    This is super good
    Thank you sir

  • @jontnoneya3404
    @jontnoneya3404 Рік тому +1

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

  • @melaniebrown8444
    @melaniebrown8444 Рік тому +2

    You are a great teacher Jamie; thank you.

  • @omoshalewamuhammed1794
    @omoshalewamuhammed1794 2 роки тому +1

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

  • @adrikojoel14
    @adrikojoel14 4 місяці тому

    I love the tutorial...ever best

  • @hannahjoy4857
    @hannahjoy4857 2 роки тому +1

    Thanks for all the work put into this video!

  • @AimpactAimpact
    @AimpactAimpact 2 місяці тому

    Really amazing

  • @nicolerobinson4868
    @nicolerobinson4868 Рік тому +1

    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?

  • @AI_ACCELERATION
    @AI_ACCELERATION 29 днів тому +1

    Thank you very much.

  • @gladenacole1524
    @gladenacole1524 2 роки тому

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

  • @orville-gj6be
    @orville-gj6be Рік тому

    Well Appreciated... Thanks

  • @mikeglloyd
    @mikeglloyd 6 місяців тому

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

  • @thomasfrimpong2257
    @thomasfrimpong2257 2 роки тому +1

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

  • @Worr69420
    @Worr69420 3 роки тому +2

    thank you so much! just earned a sub :)

  • @philprice1959
    @philprice1959 Рік тому +1

    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.

  • @ynbjamie8100
    @ynbjamie8100 2 роки тому +1

    banging vid lad

  • @finnleyfe_leaves
    @finnleyfe_leaves 10 місяців тому +8

    whos here watching before taking their ecdl exam on access?

  • @mehmedkukavica8076
    @mehmedkukavica8076 2 роки тому

    Excellent. Thank you!

  • @likithsreedhar3996
    @likithsreedhar3996 Рік тому

    Super and helpful

  • @samuelfranciscogarcia1440
    @samuelfranciscogarcia1440 5 місяців тому

    Me gustó mucho, Gracias.

  • @LOYTHEANY
    @LOYTHEANY Рік тому

    Good teacher.

  • @fajenkpchiwi4071
    @fajenkpchiwi4071 2 роки тому

    rat thich giong cua ad, hay lam, clip hay

  • @dawnasharples
    @dawnasharples 3 роки тому +1

    So useful thank you

  • @arthealthhealing6249
    @arthealthhealing6249 Рік тому

    What's do you recommend after basic for beginners

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 3 роки тому +1

    thanks for the share.

  • @uniquesimplify3356
    @uniquesimplify3356 3 роки тому +1

    Thank You for Sharing Access lesson from a to z

  • @haroune711
    @haroune711 2 роки тому

    thanks a ton for this video

  • @equalrights9091
    @equalrights9091 2 роки тому

    Thank you, Jamie.

  • @georgekennedy1886
    @georgekennedy1886 3 роки тому +1

    Thaks again , Jamie

  • @rashaalkhamran9988
    @rashaalkhamran9988 2 роки тому

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

  • @nileshsharma9668
    @nileshsharma9668 2 роки тому +1

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

  • @ubestgallery7635
    @ubestgallery7635 2 роки тому

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

  • @roberth.9558
    @roberth.9558 2 роки тому

    Effective presentation. Thank you.

  • @AndieGuess
    @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
      @AndieGuess Рік тому

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

  • @AndieGuess
    @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.

  • @jianacope8002
    @jianacope8002 3 роки тому

    Thank you!

  • @AndieGuess
    @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.

  • @osamaalbalad4456
    @osamaalbalad4456 2 роки тому

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

  • @TheWildheartmicaela
    @TheWildheartmicaela 3 роки тому

    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

  • @jesuis2508
    @jesuis2508 2 роки тому

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

  • @halkawtmohammed3445
    @halkawtmohammed3445 2 роки тому

    Thank you. you are a useful man

  • @odongoambrose5433
    @odongoambrose5433 Рік тому

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

  • @kakoozawilliam00
    @kakoozawilliam00 2 роки тому

    Thanks

  • @abubakr5063
    @abubakr5063 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.

  • @LiamBriggs18
    @LiamBriggs18 3 роки тому

    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
      @joukenienhuis6888 2 роки тому

      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.

  • @anwar6971
    @anwar6971 2 роки тому

    How can I download the practice files?

  • @AndieGuess
    @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

  • @greenlife-gardens
    @greenlife-gardens 2 роки тому

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

  • @phanorkner
    @phanorkner 4 місяці тому

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

  • @stanleyk2292
    @stanleyk2292 2 роки тому

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

  • @michaellukes2580
    @michaellukes2580 2 роки тому +4

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

    • @joukenienhuis6888
      @joukenienhuis6888 2 роки тому +3

      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.

  • @tutsecret499
    @tutsecret499 2 роки тому

    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?

  • @Dulce2393
    @Dulce2393 10 місяців тому

    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
    @endiogoen 2 роки тому +1

    The Waffle House has found it's new host

  • @SennaCrow
    @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.

  • @kathleen9185
    @kathleen9185 3 роки тому

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

  • @XiaoHC
    @XiaoHC 2 роки тому

    i recently Nice tutorialt softex on soft soft

  • @arrison259
    @arrison259 Рік тому

    Excellent! Thank you!

  • @alexserghill
    @alexserghill Рік тому

    Many thanks!