Microsoft Access Tutorial - Beginners Level 1 (Quick Start)
HTML-код
- Опубликовано: 6 авг 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 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 😊
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
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!
Loud and clear 👏💯💖. I also love that everything is so vividly displayed on the screen.
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
Thanks, Jamie. Great beginners' Lesson!
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.
Thank you so much for the explanation. I really needed this looking Forward to the next course
This is super helpful! I had no idea at all and now it is making sense!
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!
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.
thanks to you , you have made me understand right from scratch.
I love it... This was so simple and easy to understand. Thank u so much... You taught it better than my teacher...
i have a ICT CT in 4 days, this *will* help me far better than my teacher
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
Thanks for sharing this video. It's straightforward to follow and easy to understand the basics. Thanks!
Love it. Thank you so very much! You are the best!
I used microsoft access a bit at work this year and it was great
Definitely a powerful program!
Amazing tutorial! I like how you kept it simple. You are a great teacher!
Thanks so much!
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!
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.
That was so clear... thank you
Wow. Quality teaching for a biginner. I am. Loving acess
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 ❤❤❤
Thank you! Great introducing video.
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
Incredibly helpful for a beginner. Thank you! Your teaching style is terrific with your pace and instructional content.
I watched the level1 access tutorial video and it was very helpful to me and it increased my knowledge.
Thanks
very helpful for a beginner, thank you .
Thank you so much...I can't stop watching your videos..am are student in Kenya 🇰🇪
wowwww!!!
Am in love with this tutorial ❤️💕
Great tutorial! Thank you.!
Great,easy to understand.
Best fast understand tutorial on access.
Thank you! This was really helpful👍👍
So helpful!! Been meaning to get started on access and kept putting it off but feeling able to make a start now!
Thank You! You made this simple and it no longer looks like a daunting program.
Thank you very much!
Nice one it really has been simplified...
Thank you for sharing your knowledge! This is truly helpful 🙏😊
Very good and helpful tutorial. Thank you.
Many thanks!
He is a wonderful teacher!
Thank so much and i want to learn more from you
thx for this vid. im new to acess. and writing a test about it.
Thank great tutorial,I love it.
I've looking for a video like this on RUclips for e long time! Thank you so much for sharing with us! God bless you!
You are so welcome!
Thanks for the tutorial. Really helped a lot. Hope you'd create a tutorial about relationships
This is very helpful, thank you
THIS IS AWESOME TUTORIAL. ON TO PART 2.
Thank you I was having trouble using it!
You’re welcome!
Thank you sir for sharing your knowledge.
you’re amazing man
Thanks alot dear tutor thanks alot you helped me very well
Thank you so much for this, you are a great teacher!
After a long time I'm finally learning it again
Thanks sir - fantastic job
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 RUclips? I poked around quite a bit, but can't seem to find anything other than this Lesson #1.
Thanks for info
Thanks really helpful
Great job , thanks very mush
your video is helpful, thanks sir
It's just wow and I like it
Thank You So Much
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.
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
Thank you, it very useful tutorial but I would like to know if there is more than just this session.
thank u sir for your tutorial
TQ..very helpfull for my first time learner
Thank you for this tutorial. Just wondering, can this be used as database for patient records? like an EMR? ....cheers!
Amazing 👍
Hi, if the linked excel has new rows, will those new rows be reflected in the imported access table?
Thanks for your teaching.
You are very welcome
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.
thank you again well explained
Glad I could help, your welcome!
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
You're great teacher
This is amazing ❤
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.
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.
you are the best
very helpful
WELL DONE techer 🥰🥰
Thank you Jamie
Amazing, simple yet easy to follow. I do want to learn how to make a data interface using Access.
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?
Thanks Boss
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
it is really helpful for beginners.😃
Simply amazing. Thank you for the Tutorial Sir.
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
The video was very understanding to me.. even my school teacher cannot explain as much as you Sir .. Thanks once again for the tutorial😍
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.
nice and easy u ahve asaple worksheet to practice
We need your version of level 2 3 4 asap! Best teacher around
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?
Hello how do I set up a crowfoot diagram chart for my ERD in my MS Access?
You did an excellent job. ? Phone numbers ...how did you get the dash appear