Microsoft Access Tutorial - Beginners Level 1 (Quick Start)

Are you new to Microsoft Access and looking to learn how to create a database from scratch? Look no further! In this tutorial, I will take you through the basics of Microsoft Access and guide you step-by-step in creating your first database.
We will start by creating a blank database and taking a quick tour of the tabs and ribbon. From there, we will guide you through creating a table and adding fields to it. You will learn how to add records in datasheet view and import records from an Excel spreadsheet.
Next, we will show you how to create a form and enter or modify records in it. We will take you through the design view of a form and show you how to customize it to your liking.
After that, we will teach you how to create a query in Microsoft Access and modify it in design view. Finally, we will demonstrate how to create a report in Microsoft Access to display and print your data.
Whether you are a student, a professional, or just someone who wants to learn a new skill, this Microsoft Access tutorial is perfect for beginners who want to learn how to build a database from scratch. So what are you waiting for? Join us and start your journey to becoming an Access expert today!
Microsoft Excel contact List for import: leveragingdigitalinc-my.share...
Microsoft Access Level 2 Tutorial: • How to use Microsoft A...
00:00 Introduction
0:25 What is Microsoft Access
1:21 Create a blank database in Access
3:05 A quick tour of the tabs and ribbon
6:45 Create a table in Microsoft Access
8:30 Adding fields to your table
10:53 Add records in datasheet view
12:52 Import records from excel spreadsheet
15:16 Create a form in Microsoft Access
16:15 Design view in a form
18:20 Enter or modify records in a form
20:25 Create a query in Microsoft Access
22:02 Modify your query in design view
23:59 Create a report in Microsoft Access
Microsoft Excel Tutorials: • Excel for Beginners: E...

Пікірлер: 193

  • @whentheleveebreaks1927
    @whentheleveebreaks1927 Жыл бұрын

    I touched on Access a small amount in college, but it's been a few years now. At my job I'm using it now and completely forgot most of it. It's difficult to find tutorials on it so I appreciate this video it helped a lot. Thanks

  • @melissajohnson1082
    @melissajohnson1082 Жыл бұрын

    I just got a new job as a senior accountant and this company uses access 😩😩. I have not used it in years since college and wasn’t aware company’s still use this software. Anyways, I am here to learn to get better at my new role 😊

  • @yeahyeah190

    @yeahyeah190

    11 ай бұрын

    Feedback?

  • @godwinwamonene4811

    @godwinwamonene4811

    6 ай бұрын

    Good work

  • @jhonmeyveraranajimenez4751

    @jhonmeyveraranajimenez4751

    5 ай бұрын

    Hello Melissa. I am just a bit curious about the use of Access in finance. I work in finance too and I started to get to now access more, however I am kind of lost in terms of when should I use it instead of excel. We do use excel a lot but never access. So, I am not really sure a what point I can say "well now is a good time to use access". Thank you

  • @Allanwasalla

    @Allanwasalla

    2 ай бұрын

    U can make it girl ge patient 😊

  • @tamikasepiso5275
    @tamikasepiso52754 ай бұрын

    Jamie is a lifesaver. I like how he takes his time almost in all the videos really patient and the fact that I'm also a patient its comes as a bonus. I have learnt so much from him, in my books he's a hero.

  • @kevinkendall923
    @kevinkendall9235 ай бұрын

    had to use this for a college course and it was probably the simplest assignment ive done because of how you explained it. thank you!

  • @pcLumsy1
    @pcLumsy15 ай бұрын

    Loud and clear 👏💯💖. I also love that everything is so vividly displayed on the screen.

  • @georgekennedy1886
    @georgekennedy18862 жыл бұрын

    Thanks, Jamie. Great beginners' Lesson!

  • @Joseph-rq9el
    @Joseph-rq9el3 ай бұрын

    this is great...learned access when I was young... but don't really have a good view of what it does... this videos now clears everything...

  • @rayquackenbush4609
    @rayquackenbush4609 Жыл бұрын

    Greatly helpful. I am in the process of creating and Ancestry and was using Excel but this makes much more sense due to being able compare one person to another. Will be back for more learning.

  • @ChinnyBonny
    @ChinnyBonny2 жыл бұрын

    My first time trying out MS Access and it was well worth my time to start learning the basics. I'll be looking out for other videos on Access to learn more. Thanks heaps! You got a new subscriber

  • @curiosity_killed_this_cat
    @curiosity_killed_this_cat5 ай бұрын

    i have a ICT CT in 4 days, this *will* help me far better than my teacher

  • @dayspring4194
    @dayspring41943 ай бұрын

    Thank you, this was a really good tutorial. There were a couple of times I had to replay how you reverted back to 'Views' and which one you chose but it was easy. This gives me hope that I can learn Access. Will definitely be watching more of your vids. You have a new sub!

  • @wathmiubeyrathna
    @wathmiubeyrathna7 ай бұрын

    I love it... This was so simple and easy to understand. Thank u so much... You taught it better than my teacher...

  • @user-mh6gw2uw6e
    @user-mh6gw2uw6e Жыл бұрын

    This is super helpful! I had no idea at all and now it is making sense!

  • @word_of_christ_ministries7033
    @word_of_christ_ministries70339 ай бұрын

    Well done. This was very helpful. I followed along, creating the database as the teacher performed the task.

  • @matatawilson2007
    @matatawilson20072 жыл бұрын

    thanks to you , you have made me understand right from scratch.

  • @maryfuentes5110
    @maryfuentes5110 Жыл бұрын

    Love it. Thank you so very much! You are the best!

  • @tamonwancharoensripongsa4740
    @tamonwancharoensripongsa4740Ай бұрын

    Thanks for sharing this video. It's straightforward to follow and easy to understand the basics. Thanks!

  • @MYHEALTHMYDIET
    @MYHEALTHMYDIET2 жыл бұрын

    Thank you for the information, I recommend Teacher's Teach Channel To anyone who wants to learn more, This Channel has helped me a lot, Thank you Sir for your hard work 👏👏

  • @TeachersTech

    @TeachersTech

    2 жыл бұрын

    You are very welcome! I’m glad the videos help people out.

  • @MYHEALTHMYDIET

    @MYHEALTHMYDIET

    2 жыл бұрын

    @@TeachersTech Yes you are helping us a lot. I even learned video editing from you.

  • @ermiyasabebe9740

    @ermiyasabebe9740

    2 жыл бұрын

    Thanks a lot

  • @catemugo8357
    @catemugo8357 Жыл бұрын

    Thank you so much for the explanation. I really needed this looking Forward to the next course

  • @dollianahbontsibokae6377
    @dollianahbontsibokae637710 ай бұрын

    Wow. Quality teaching for a biginner. I am. Loving acess

  • @agbejoyeolufunmi3575
    @agbejoyeolufunmi35752 жыл бұрын

    A teacher walked up to me for help in teaching her how to tackle questions in an external exam with MS Access. Without any knowledge, a look at this video makes me a beginner guru. Thanks a lot. I am leaving excel for a while to explore this powerful programme

  • @RIDHISHAMAUA
    @RIDHISHAMAUA2 ай бұрын

    Thank you so much...I can't stop watching your videos..am are student in Kenya 🇰🇪

  • @greenlife-gardens
    @greenlife-gardens2 жыл бұрын

    Thank you so much, I now have Access to Access! I’ve been using Word & Excel for years and using Excel where I know I really should have been using Access. I could never find a tutorial that was easy to understand, mainly because the tutors didn’t convey in Layman’s Terms. So easy to digest and implement what you teach, and you deliver in such a simple & fresh way. You get 10/10 from me. I will use Access a lot now to manage a plant database and it will open new doors of creativity for me I’m sure. Brilliant.

  • @DemetriPanici
    @DemetriPanici2 жыл бұрын

    I used microsoft access a bit at work this year and it was great

  • @TeachersTech

    @TeachersTech

    2 жыл бұрын

    Definitely a powerful program!

  • @yaucalabi
    @yaucalabi Жыл бұрын

    Incredibly helpful for a beginner. Thank you! Your teaching style is terrific with your pace and instructional content.

  • @ilovebluesky0718
    @ilovebluesky0718 Жыл бұрын

    Thank you! Great introducing video.

  • @sheetalsharma3725
    @sheetalsharma37258 күн бұрын

    Great,easy to understand.

  • @user-br7ce2hb2g
    @user-br7ce2hb2g6 ай бұрын

    I watched the level1 access tutorial video and it was very helpful to me and it increased my knowledge. Thanks

  • @itesakota3815
    @itesakota3815 Жыл бұрын

    That was so clear... thank you

  • @georgepadmoreofori8778
    @georgepadmoreofori8778 Жыл бұрын

    wowwww!!! Am in love with this tutorial ❤️💕

  • @2011liya
    @2011liya Жыл бұрын

    Love your video, great presentation to explain how to use access, your are really a good teacher that knows how to teach!

  • @TeachersTech

    @TeachersTech

    Жыл бұрын

    I appreciate that!

  • @Sam_ChristSaves
    @Sam_ChristSaves2 жыл бұрын

    Amazing tutorial! I like how you kept it simple. You are a great teacher!

  • @TeachersTech

    @TeachersTech

    2 жыл бұрын

    Thanks so much!

  • @DABOSTONBETTY
    @DABOSTONBETTY Жыл бұрын

    Amazing!!! Your videos have been a life saver for me.....I'll be watching more this weekend. Now if you could only do a beginners SQL ❤❤❤

  • @kimw9690
    @kimw96906 ай бұрын

    Great tutorial! Thank you.!

  • @veerusadda1653
    @veerusadda1653 Жыл бұрын

    Best fast understand tutorial on access.

  • @owhondagift3963
    @owhondagift39632 жыл бұрын

    Nice one it really has been simplified...

  • @johnvolution
    @johnvolution11 ай бұрын

    Thank you! This was really helpful👍👍

  • @rox-anncormack4778
    @rox-anncormack47787 ай бұрын

    He is a wonderful teacher!

  • @gladenacole1524
    @gladenacole1524 Жыл бұрын

    THIS IS AWESOME TUTORIAL. ON TO PART 2.

  • @pingao1841
    @pingao184111 ай бұрын

    very helpful for a beginner, thank you .

  • @theteachersdesk
    @theteachersdesk3 ай бұрын

    Thank you for sharing your knowledge! This is truly helpful 🙏😊

  • @hermilapile7315
    @hermilapile73152 жыл бұрын

    Thank You! You made this simple and it no longer looks like a daunting program.

  • @user-ln6fv5id6n
    @user-ln6fv5id6n2 ай бұрын

    After a long time I'm finally learning it again

  • @mufadzimtombeni1990
    @mufadzimtombeni19906 ай бұрын

    Thank great tutorial,I love it.

  • @beryltshombe915
    @beryltshombe91510 күн бұрын

    This is very helpful, thank you

  • @omedormany1984
    @omedormany1984 Жыл бұрын

    WELL DONE techer 🥰🥰

  • @robinmuir7799
    @robinmuir77999 ай бұрын

    Very good and helpful tutorial. Thank you.

  • @sir_iaron
    @sir_iaron2 жыл бұрын

    Thank you very much!

  • @mehdi.sajadi
    @mehdi.sajadi2 жыл бұрын

    you’re amazing man

  • @prasannasamarathunga351
    @prasannasamarathunga351 Жыл бұрын

    Thank you sir for sharing your knowledge.

  • @alexserghill
    @alexserghill Жыл бұрын

    Many thanks!

  • @sarahhughes2910
    @sarahhughes29102 жыл бұрын

    So helpful!! Been meaning to get started on access and kept putting it off but feeling able to make a start now!

  • @user-jq7wz8xh1n
    @user-jq7wz8xh1n Жыл бұрын

    Thanks for the tutorial. Really helped a lot. Hope you'd create a tutorial about relationships

  • @mitchellholmes4656
    @mitchellholmes46562 ай бұрын

    Thanks sir - fantastic job

  • @mikihoptem2882
    @mikihoptem28822 жыл бұрын

    Thank so much and i want to learn more from you

  • @haroune711
    @haroune711 Жыл бұрын

    your video is helpful, thanks sir

  • @lirimbytyqi1
    @lirimbytyqi12 жыл бұрын

    I've looking for a video like this on KZread for e long time! Thank you so much for sharing with us! God bless you!

  • @TeachersTech

    @TeachersTech

    2 жыл бұрын

    You are so welcome!

  • @tintingamerboy6133
    @tintingamerboy6133 Жыл бұрын

    thx for this vid. im new to acess. and writing a test about it.

  • @konnectwithKike
    @konnectwithKike Жыл бұрын

    Thanks really helpful

  • @mutazgomaa7235
    @mutazgomaa7235 Жыл бұрын

    Great job , thanks very mush

  • @blahblahx3ful
    @blahblahx3ful Жыл бұрын

    Hi, if the linked excel has new rows, will those new rows be reflected in the imported access table?

  • @williamwallace9826
    @williamwallace98262 жыл бұрын

    This video is the first decent into to Access I have found. I need more information on creating queries and reports to extract data, so I will check out some of your other videos. Thank you.

  • @franciscaochieng-pu4jz
    @franciscaochieng-pu4jz4 ай бұрын

    It's just wow and I like it

  • @manuelmagana4057
    @manuelmagana40572 жыл бұрын

    I have a Access file that I’m making changes to but saving as a different file name so that changes only reflect on new file but when you open both files it overwrites on original document as well any suggestions?

  • @moseskinder2916
    @moseskinder29162 жыл бұрын

    you are the best

  • @serignebabou4306
    @serignebabou4306 Жыл бұрын

    Amazing 👍

  • @niinell6125
    @niinell6125 Жыл бұрын

    You're great teacher

  • @percyweerasinghe9191
    @percyweerasinghe91915 ай бұрын

    Thanks for info

  • @calvinkleins8615
    @calvinkleins86156 ай бұрын

    This is amazing ❤

  • @AsimacademyonlineQuranlearning
    @AsimacademyonlineQuranlearning2 жыл бұрын

    Thanks alot dear tutor thanks alot you helped me very well

  • @user-jm5it5re7u
    @user-jm5it5re7u2 жыл бұрын

    Thank you I was having trouble using it!

  • @TeachersTech

    @TeachersTech

    2 жыл бұрын

    You’re welcome!

  • @user-zk7gh2rp8t
    @user-zk7gh2rp8t Жыл бұрын

    TQ..very helpfull for my first time learner

  • @loveasin69
    @loveasin692 жыл бұрын

    Best of the best on KZread won’t find any better thank you sir

  • @TeachersTech

    @TeachersTech

    2 жыл бұрын

    So nice of you

  • @wilsonprophet9865
    @wilsonprophet98652 жыл бұрын

    very helpful

  • @annelias4378
    @annelias437811 ай бұрын

    Hi Jamie - I'm new to your videos, but really like your content, delivery & timing. Any chance you have other Access videos that have been posted to KZread? I poked around quite a bit, but can't seem to find anything other than this Lesson #1.

  • @kainerugabagenerous1426
    @kainerugabagenerous14262 жыл бұрын

    I can say it has been wonderful, a step by step session and at the end of it I have been able to produce the same results💗

  • @ahabwecollins

    @ahabwecollins

    Жыл бұрын

    Very helpful

  • @sanjay.v.v8337
    @sanjay.v.v8337 Жыл бұрын

    Thank You So Much

  • @kaaa3485
    @kaaa34852 жыл бұрын

    Thank you so much for the video. I have a question. I use my access database daily, but today when I close my form that has subforms, I get the message "No current record". I don't know what has happened, it was not doing till yesterday. The first form has 2 subform. I used to get two of the message "No Current Record". when I deleted the first subform, I only got one message but when I deleted the second one, I did not get none. I have been working with database for 15 years, I never got this message until yesterday. one more thing, I also get it when I hit add new record. did microsoft access change the coding? Will you please, help solve this problem? Thanks in advance

  • @sidhantgoyal4327
    @sidhantgoyal43272 жыл бұрын

    Waiting for an Access Tutorial for a long time. There are a very few tutorials on Access and this is one of them. Glad I had subscribed...

  • @TeachersTech

    @TeachersTech

    2 жыл бұрын

    Glad I could help! I'll be creating a series of videos on this topic.

  • @simoiyahector-morales3781
    @simoiyahector-morales37812 жыл бұрын

    Thus video came at the perfect time because my twins are creating an elections database using access. Absolutely 💯 love your channel and tutorials

  • @Ninjiradhaa

    @Ninjiradhaa

    Жыл бұрын

    Teacher 🅝🅘🅒🅔 I'm v liked so if you're new information level 1/4 sends wait

  • @user-jd2fn7xx1u
    @user-jd2fn7xx1u7 ай бұрын

    thank u sir for your tutorial

  • @brashamathu
    @brashamathu9 ай бұрын

    it is really helpful for beginners.😃

  • @nafiubungudu5177
    @nafiubungudu51772 жыл бұрын

    Thank you Sir for the opportunity you have been giving us to learn from you, I have learned a lot and still learning, I'm very grateful and short of words to describe how thankful I'm.

  • @jacquelineoconnor7234
    @jacquelineoconnor72342 жыл бұрын

    Thank you so much for this, you are a great teacher!

  • @tacticgamer6298
    @tacticgamer62982 жыл бұрын

    Simply amazing. Thank you for the Tutorial Sir.

  • @congnghevakythuat
    @congnghevakythuat2 жыл бұрын

    Hello friends. Great MS Access!

  • @NasiruSaidu-es5yb
    @NasiruSaidu-es5yb Жыл бұрын

    Thanks Boss

  • @kms9025
    @kms9025 Жыл бұрын

    I'm trying to create a New Blank Record in a Form but when I do the info does not automatically show as a new line in my Table. The only way I have found to get the new line to show up is to switch my Table from Datasheet View, to Design View, back to Datasheet View and the line appears. Any idea why this may be happening and how to avoid it? Thank you

  • @blahblahx3ful
    @blahblahx3ful Жыл бұрын

    Hi love your video, however it seems I’m unable to import an excel that contains macro. It says “the wizard is unable to access information in the file xxxxxx. Please check that the file exists and is in the correct format” not sure if you have come across this error before?

  • @minageedinulya5976
    @minageedinulya59762 жыл бұрын

    The video was very understanding to me.. even my school teacher cannot explain as much as you Sir .. Thanks once again for the tutorial😍

  • @rajendraboodram21
    @rajendraboodram212 жыл бұрын

    keep up the good work my friend this is a blessing to have the breakdown of so much and to learn so much is wonderful.

  • @rodmarsh3089
    @rodmarsh3089 Жыл бұрын

    Hello how do I set up a crowfoot diagram chart for my ERD in my MS Access?

  • @HumFan
    @HumFan Жыл бұрын

    Thank you Jamie

  • @satyabanukil779
    @satyabanukil7792 жыл бұрын

    I have two tables with two separate forms. The first table based on the first table has a calculated text box. I want to show the textbox data to a field to another form. How to do it. Thanx and regards.

  • @TheDelicFlame
    @TheDelicFlame Жыл бұрын

    nice and easy u ahve asaple worksheet to practice

  • @vanessacornell2507
    @vanessacornell25072 жыл бұрын

    Amazing, simple yet easy to follow. I do want to learn how to make a data interface using Access.

  • @onelinkpmo2954
    @onelinkpmo29542 жыл бұрын

    We need your version of level 2 3 4 asap! Best teacher around

  • @normanpeters6465
    @normanpeters6465 Жыл бұрын

    Quick question. If I pulled from ans excel sheet and later go and update the excel sheet. Next time I open Access, would it also pull from the excel sheet or if I update the access sheet with the excel sheet, would it only pull the new additions?

  • @aziserak4743
    @aziserak47432 жыл бұрын

    thank you again well explained

  • @TeachersTech

    @TeachersTech

    2 жыл бұрын

    Glad I could help, your welcome!

  • @nadiasammut8188
    @nadiasammut8188 Жыл бұрын

    Thanks for your teaching.

  • @TeachersTech

    @TeachersTech

    Жыл бұрын

    You are very welcome