Microsoft Access Tutorial - Beginners Level 1 (Quick Start)
Vložit
- čas přidán 20. 07. 2024
- 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...
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
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 😊
Feedback?
Good work
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
U can make it girl ge patient 😊
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.
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!
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
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.
Loud and clear 👏💯💖. I also love that everything is so vividly displayed on the screen.
i have a ICT CT in 4 days, this *will* help me far better than my teacher
Thanks, Jamie. Great beginners' Lesson!
Thank you so much for the explanation. I really needed this looking Forward to the next course
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!
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.
Amazing tutorial! I like how you kept it simple. You are a great teacher!
Thanks so much!
This is super helpful! I had no idea at all and now it is making sense!
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
thanks to you , you have made me understand right from scratch.
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...
Well done. This was very helpful. I followed along, creating the database as the teacher performed the task.
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 👏👏
You are very welcome! I’m glad the videos help people out.
@@TeachersTech Yes you are helping us a lot. I even learned video editing from you.
Thanks a lot
I love it... This was so simple and easy to understand. Thank u so much... You taught it better than my teacher...
Love it. Thank you so very much! You are the best!
Incredibly helpful for a beginner. Thank you! Your teaching style is terrific with your pace and instructional content.
Thank you so much...I can't stop watching your videos..am are student in Kenya 🇰🇪
Love your video, great presentation to explain how to use access, your are really a good teacher that knows how to teach!
I appreciate that!
Thanks for sharing this video. It's straightforward to follow and easy to understand the basics. Thanks!
Thank You! You made this simple and it no longer looks like a daunting program.
I used microsoft access a bit at work this year and it was great
Definitely a powerful program!
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 ❤❤❤
Wow. Quality teaching for a biginner. I am. Loving acess
Thank you! Great introducing video.
Thanks for the tutorial. Really helped a lot. Hope you'd create a tutorial about relationships
I watched the level1 access tutorial video and it was very helpful to me and it increased my knowledge.
Thanks
I've looking for a video like this on CZcams for e long time! Thank you so much for sharing with us! God bless you!
You are so welcome!
So helpful!! Been meaning to get started on access and kept putting it off but feeling able to make a start now!
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 CZcams? I poked around quite a bit, but can't seem to find anything other than this Lesson #1.
That was so clear... thank you
Thank you for sharing your knowledge! This is truly helpful 🙏😊
wowwww!!!
Am in love with this tutorial ❤️💕
very helpful for a beginner, thank you .
Nice one it really has been simplified...
Thank you! This was really helpful👍👍
Best fast understand tutorial on access.
Thank you I was having trouble using it!
You’re welcome!
thx for this vid. im new to acess. and writing a test about it.
Very good and helpful tutorial. Thank you.
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.
THIS IS AWESOME TUTORIAL. ON TO PART 2.
After a long time I'm finally learning it again
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💗
Very helpful
Great tutorial! Thank you.!
He is a wonderful teacher!
Thank so much and i want to learn more from you
Thank you sir for sharing your knowledge.
Thank you very much!
Thank great tutorial,I love it.
your video is helpful, thanks sir
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.
Thus video came at the perfect time because my twins are creating an elections database using access. Absolutely 💯 love your channel and tutorials
Teacher 🅝🅘🅒🅔 I'm v liked so if you're new information level 1/4 sends wait
I'm living next to an air force base and want to make an overview of all types of aircraft and units that have been there from 1940 till 1996. Sometimes there's an overlap from squadrons and aircraft types but that is not always the cause.
A query should show when a particular type of aircraft (or flying unit) was in use at any moment in time.
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...
Glad I could help! I'll be creating a series of videos on this topic.
Thank you for this tutorial. Just wondering, can this be used as database for patient records? like an EMR? ....cheers!
you’re amazing man
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.
Thank you, it very useful tutorial but I would like to know if there is more than just this session.
Thank you so much for this, you are a great teacher!
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?
Hi, if the linked excel has new rows, will those new rows be reflected in the imported access table?
Thanks alot dear tutor thanks alot you helped me very well
Thanks really helpful
Amazing, simple yet easy to follow. I do want to learn how to make a data interface using Access.
Hello how do I set up a crowfoot diagram chart for my ERD in my MS Access?
Simply amazing. Thank you for the Tutorial Sir.
WELL DONE techer 🥰🥰
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
Best of the best on CZcams won’t find any better thank you sir
So nice of you
Thank you so much for the tutorial. You explain everything so well!!
Great Tutorial, you are excellent James at explaining things in simple terms. I look forward to part 2.
Thank you, glad you liked it.
Thanks sir - fantastic job
Perfect timing because just started database management class and we are going to use access.Thanks for the info.
Glad it was helpful!
@@TeachersTech bro what are you’re timings,I just got out of that class…are you a wizard :0 and yes it did help
We need your version of level 2 3 4 asap! Best teacher around
You did an excellent job. ? Phone numbers ...how did you get the dash appear
Great job , thanks very mush
TQ..very helpfull for my first time learner
Many thanks!
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?
The video was very understanding to me.. even my school teacher cannot explain as much as you Sir .. Thanks once again for the tutorial😍
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.
you are the best
Thank you Soo much for this tutorial. This will benefit me alot in saving time at my work place
You’re welcome!
You're great teacher
It's just wow and I like it
it is really helpful for beginners.😃
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
I think teaching the different tools/icons should happen as you need them. It was too much explanation prior to getting to the building part but I like how calm you are.
nice and easy u ahve asaple worksheet to practice
thank you again well explained
Glad I could help, your welcome!
very helpful
Hello friends. Great MS Access!
Thanks for your teaching.
You are very welcome
Thanks for info