How to Use MS Access - Microsoft Access 2019 Full Tutorial - 2.5 Hours
ฝัง
- เผยแพร่เมื่อ 30 มิ.ย. 2024
- In this feature-length Microsoft Access training tutorial, we teach you how to use Microsoft Access 2019. This Microsoft Access course is aimed at people completely new to Access. We'll show you how to get set up using Access before taking you through the essentials, such as how to create tables, manage basic databases, and import data from Excel.
This MS Access tutorial was taken from the full MS Access 2019 Beginners course available on Simon Sez IT ► bit.ly/3rBQ8Pw
If you've been looking to learn MS Access, and how databases work. Then this MS Access for beginners course is the place to start!
Skip to the part of the tutorial most relevant to you:
0:00:00 - Introduction to Access 2019
0:03:32 - Acquiring Access 2019
0:07:55 - Structure of the Course
0:10:19 - Using Database Templates
0:21:15 - Creating, Saving, and Opening Databases
0:27:56 - The Access Workspace and Backstage
0:41:37 - Online Help and Tell Me What You Want To Do
0:50:20 - Working with the Ribbon
0:59:49 - The Quick Access Toolbar
1:05:47 - Contextual Menus
1:08:25 - The Status Bar
1:12:31 - Keyboard Shortcuts
1:16:09 - Key Tips
1:20:03 - Exploring Acces Options
1:29:18 - Creating a Table and Fields
1:40:48 - Indexed Field
1:49:32 - Lookup Wizard
2:01:07 - Numeric Fields
2:08:54 - Importing Data from Excel
2:19:50 - Backing up your Database
2:23:50 - Compact and Repair
For more videos teaching Microsoft Access, take a look here:
MS Access 2016 Tutorials - • Microsoft Access Tutor...
MS Access 2013 Tutorials - • Microsoft Access 2013 ...
Below are links to some of our most popular TH-cam tutorials!
- Introduction to Windows 10: • Windows 10 Tutorial - ...
- Microsoft Teams Crash Course: • Microsoft Teams Tutori...
- Excel 2019 Beginners Course: • Microsoft Excel Tutori...
- Introduction to QuickBooks 2020: • QuickBooks Tutorial: Q...
- How to Add video to Microsoft PowerPoint: • How to Add Videos to a...
- Learn PivotTables in One Hour: • Pivot Table Tutorial -...
- Microsoft Project 2016 Tutorial for Beginners: • Microsoft Project Tuto...
Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
StreamSkill.com: StreamSkill.com/
TH-cam Channel: / simonsezittraining
Subscribe to our channel:
th-cam.com/users/simonsezittra...
If you enjoyed the video, please give a "thumbs up", leave some comments, and subscribe to the channel ;-) #simonsezit - วิทยาศาสตร์และเทคโนโลยี
![LISA - ROCKSTAR (Official Music Video) REACTION [SHE'S BACK!]](http://i.ytimg.com/vi/QBxE30vavMQ/mqdefault.jpg)
I was planning to make a small program using Python and SQLite3. After watching this course, I am planning to go for Access. Thank you for the brilliant tutorial!
I had used it last in 2011 and Debra did an awesome job in the tutorial. Thank you so much, Debra.
I was using and had to give up FileMaker Pro 5.5 when I upgraded my OS to WIN 10. I really enjoyed going back to classroom here. Very professional, precise and informative.
You are a living legend. I am now listening to all the tutorials on your channel. they are the best beyond doubt. The tutorials are easy to follow and practice. Thank you!!!
Why Thank you Isheanesu, I'm thrilled you think so.
Deb did a fantastic job explaining the use of MA-2019. I truly appreciate the knowledge and how it was presented. Also, her voice/accent is awesome.
Thanks for your positive feedback!
Im literally watching this video and learning it for my business. Thank you!
Fantastic!
I'm trying to learn for a job I plan to apply for in a few months😎
0:00:11 - Introduction to Access 2019
0:03:32 - Acquiring Access 2019
0:07:55 - Structure of the Course
0:10:19 - Using Database Templates
0:21:15 - Creating, Saving, and Opening Databases
0:27:56 - The Access Workspace and Backstage
0:41:37 - Online Help and Tell Me What You Want To Do
0:50:20 - Working with the Ribbon
0:59:49 - The Quick Access Toolbar
1:05:47 - Contextual Menus
1:08:25 - The Status Bar
1:12:31 - Keyboard Shortcuts
1:16:09 - Key Tips
1:20:03 - Exploring Acces Options
1:29:18 - Creating a Table and Fields
1:40:48 - Indexed Field
1:49:32 - Lookup Wizard
2:01:07 - Numeric Fields
2:08:54 - Importing Data from Excel
2:19:50 - Backing up your Database
2:23:50 - Compact and Repair
Why have you duplicated what is already in the description box you numpty.
Koga Master, you are AWESOME!
This is outstanding. One of the more excellent instructional videos I have seen on YT. As it says, this is intended for novice Access users and it does a fantastic job of getting the basics without any of the uncomfortable asides & turn offs that other TH-cam instructional videos tend to employ. Another user mentioned voice/pitch, and the instructive voiceover is not distracting (as other vides sometime are). Absolutely on point with the pacing and flowing from one point to the next topic. Great Work Deb and team!
Wow, thank you for that Akiles, we're glad that you liked it.
Very clear and easy to follow. I'd used ACCESS awhile back, but, needed a refresher especially with the newer features. Thanks Deb
You're welcome! I'm happy that you found it useful to you.
@@SimonSezIT I was unable to complete the course as I couldn't locate lesson 1's excel speadsheet.
Thanks to Deborah for being so professional and patient with us all.
Delighted that you’ve enjoyed the tutorial Stelios!
We have additional free tutorials for MS Access tutorials here 👉
th-cam.com/play/PLzj7TwUeMQ3g7dabQhzlqljY-bnxv1YFA.html and 300+ hours of free training here 👉 th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
I will, i will :-)
And thank you :-)
Fantastic training video. Congratulations to Debra. What I liked pretty much : clear prononciation, excellent pace and very well structured. Just one small remark : have you noticed the two icons at the bottom right of the presentation ? They're hiding what you do in that area.
Thanks for your feedback Philippe, delighted to hear that you’ve enjoyed the training video! 😎
Much useful! Informative. Greatly appreciate all efforts put in creating this.
Glad you enjoyed it!
Amazing brand new to access now I feel I know as much as I need to! 😁
You got this!
Debra,you are a brilliant instructor! I have watched a number of videos on Ms Access, but none as good as yours.
Wow, thank you John, you’ve made my day!
Thanks again team for an awesome course. Watched this twice. Feel very comfortable with everything you demonstrated. Your teaching style is brilliant.
Our pleasure!
Nice course. Voice and pronunciation excellent. Perhaps enlarge the screen, somewhat small on a tablet.
Even as advanced user, started with Access 2 😁 myself, I picked up of renewed some new knowledge here and three
Keep up the good work.
I'm fifty minutes into the video and all we've done is learn to save,open/close, access the Help functon,, and stop the welcome screen from openingevery time I open a db.
I recommend FF unless you've never used any Office products before. If you have ANY experience with Word or Excel, the first hour is going to drag on forever
Ikr??? What a waste of time!
I watched this entire video & have now moved on to Part 1 of your Access training & it is the same video, with someone else teaching the course and a small amount of additional information (which is needed to watch Part 2)? I understand it's the 2016 video but the script is almost verbatim. Maybe just add to this one that it is the same as the 2016, so if someone's planning on watching Part 1-Part 3 they could just skip this one. I really do appreciate the free training and the time and effort you took to create this, it is just very inconvenient to have wasted 2 1/2 hours of time (especially since I am learning this to create a database for a non-profit, for free).
I am enjoying all of your courses. They are very educational. And also, you have beatiful voice:)
Glad you think so!
Your course is fantastic. I have come across a problem I hope you can fix it. When I added an E=Mail field, in the drop-down box I accidentally clicked on Google Chrome. How do I change this to an E-Mail Account?
Great work!
Thanks for the visit
Excellent. Thank you.
Glad you enjoyed it!
Thank You!
You're welcome!
thank you, SO much
Glad it helped!
Great Job!!!!!!!
Thank You Alfredo!
Excellent tutorial. Much thanks
Glad you think so, Christopher! We recently uploaded a longer video for the beginner and advanced course, 7 hours of Access 2019 training -> th-cam.com/video/jCG2MTH9Ftw/w-d-xo.html
Thank you so much my Dear Teacher;
You are very welcome
WONDERFUL COURSE
Delighted to hear that!
Do you have a tutorial on how to connect different databases? I wan tto make a contact list, team list database and connect the team list of tasks to complete database.
one of the best tutorial
Thank you Ambrose
Evidently, most of you guys do appreciate the hard work Simon & Deb has put in. But some forget that it's complimentary.
If you aren’t a first timer in any Ms tool, just watch from 1.29.00 to 2.10.00
100% CORRECT...Great job from her.
this is the very basic use of access in general
Thanks ma'am
Keep watching!
2:07:45 what about maximum price of trip must be greater or equal than minimum price of trip (not zero), is that possible to compare to an other field in the same record?
I have other Access 2019 books I can use to work with this course on
Access 2019.
We have additional free tutorials for MS Access tutorials here 👉
th-cam.com/play/PLzj7TwUeMQ3g7dabQhzlqljY-bnxv1YFA.html
Do you provide files for us practice and to follow your lessons. If not, if will be difficult to follow your class without files.
Unfortunately, not with this video. We are uploading a longer version of this training in September, it will include demo and exercise files.
I really diddnt need to know how to give feedback or how to change the theme...
Not able to find / see the Link with files to go along with this course. Am I over looking that link?
i think you are
@@dtopshotaa You think wrong
@@scotmars Have to become a Simon Sez member to gain access to the templates.
I have access mdb file made in 2010. It will work with access 2019
I wish this was made from a blank desktop database and not from a Contact template. Some of this info is very helpful but it's hard to follow along when someone is using a template to teach. For example: When starting from Blank Desktop Database, there are no forms, you have to create a form.
Thanks for the suggestion Nikki, much appreciated
@@SimonSezIT other than that, this has been super helpful and I learned a lot. I do appreciate your hard work! 💜
@@SimonSezIT IMHO, it's easier to start out with a Contact Template for newbie to comprehend the Basic Foundation. And I trust any bloke who follows the tutorial would have no problem creating his/her own DB from a Blank Template.
2:20:46 "one of the advantages" ... meaning disadvantages :)
It may have its drawbacks, but it has its advantage since we only need to backup a single file. Unless of course if we have linked external tables and data. :)
how can i get these template files please
You can get the full course including all the instructor files by becoming a Simon Sez IT member: www.simonsezit.com/signup/
i reallly want to like this, but look 404 likes lol
Video literally starts at 1:30:00 so much unnecessary intro
Some people find the basics and the context useful!
Extremely slow , too much time in useless stuff like explaining how to minimize, Maximize and close a window. This course seems to be focused for the elderly...
It is a beginner course intended for people brand new to Access, so we assume no prior knowledge. :)
This could be less boring. Soo repetative.
Thanks for your feedback. I'll take your suggestion on board.
Would disagree. Based on anecdotal evidence, I'd say the people I've taught remembered better with more repetition.
Would argue for the first 90 mins to be spun out and slightly reworked as a general office training. I'm not saying it's bad (as imho it's quite good) and I know this is the basic acces training, but if a student needs these basics taught, acces shouldn't be the example used. If you are that new to office, you really should stick to word and excel.
@@SimonSezIT I don't mind investing hundreds of hours just to reach advanced level. And another hundreds to use the application like an expert, full of innovation and confidence.
@@SimonSezIT ignore this ignorant person. The tutorial is perfect, especially for beginners. I think what he wants is a more advanced tutorial and he's in the wrong place for that.
Keep up the good work!
trust me you will waste your time
Sorry you feel that way. In case you haven't yet, you can select the specific topics you need to watch using the timestamps provided in the description box. Have a nice day!