Microsoft Access Tutorial: 7 Hours of Beginner to Advanced Training
ฝัง
- เผยแพร่เมื่อ 27 มิ.ย. 2024
- ✅ Download the course files to follow along and practice what you learn ➡️www.simonsezit.com/access-201...
In this Access 2019 Beginner to Advanced training course, we cover the basics of Microsoft Access and expand to more advanced skills. We'll go over database templates, creating and saving your very first database, using the lookup wizard, backing up your database, and creating linked tables.
We'll also explore the datasheet view, how to set up a Northwind Database, link to tables in other databases, install the SQL Server Express, the basics macros, and so much more!
We've even included downloadable instructor and exercise files from our paid-for courses so you can follow along and complete the exercise in this course. This will help you put what you are learning into practice and master MS Access 2019.
✅ www.simonsezit.com/access-201...
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Simon Sez IT Intro
00:00:21 - Introduction to Access 2019
00:03:40 - Acquiring Access 2019
00:08:05 - Structure of the Course
00:10:28 - Using Database Template
00:21:29 - Creating, Saving, and Opening Databases
00:28:10 - Access Workspace and Backstage
00:41:52 - Online Help
00:50:35 - Working with the Ribbon
01:00:03 - Quick Access Toolbar
01:06:00 - Contextual Menus
01:08:40 - The Status Bar
01:12:49 - Keyboard Shortcuts
01:16:29 - Key Tips
01:20:23 - Access Options
01:29:39 - Creating a Table and Fields
01:41:10 - Indexing Fields
01:49:52 - Lookup Wizard
02:01:27 - Numeric Fields
02:09:15 - Exercise 01
02:12:41 - Importing Data from Excel
02:23:39 - Exercise 02
02:29:17 - Backing Up Your Database
02:33:14 - Compact and Repair
02:39:39 - Design in the Datasheet View
02:49:50 - Sorting and Filtering in Datasheet View
02:59:52 - Entering and Modifying Data in Datasheet View
03:10:47 - Creating a Link Table
03:21:22 - Setting Up Relationships
03:31:18 - Exercise 03
03:41:42 - Advanced Course Overview and Content
03:46:50 - Primary Keys and Indexing Rules and Guidelines
03:56:45 - More About Indexes
04:05:22 - Setting Up Northwind Database
04:08:58 - Working in Datasheet View
04:20:02 - Customizing Datasheet View, Sorting and Filtering Options
04:37:17 - Subdatasheets
04:46:39 - Exercise 01
04:47:47 - Linking to Tables in Other Databases
05:01:14 - Acquiring and Installing SQL Server Express
05:26:34 - Exercise 02
05:27:50 - Splitting Database into Front-end and Back-end
05:37:29 - Converting a Shared Table into a Local Table
05:48:54 - Exercise 03
05:50:45 - Addressing Multi-User Issues when Sharing Data
06:00:38 - Basics of Macros
06:14:05 - Macros on Events; AutoExec
06:26:05 - More about AutoExec
06:42:18 - Macro Security Settings
06:48:50 - Exercise 04
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit.com/ssit-first...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Data Analysis using Microsoft Tools 👉 • Data Analysis using Mi...
✅Microsoft Access Training video playlist 👉 • How to Use Microsoft A...
✅ Microsoft Excel Beginner's Training here 👉 • Microsoft Excel Beginn...
✅ Introduction to Databases Training here 👉 • Introduction to Databa...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
th-cam.com/users/simonsezittra...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-) - วิทยาศาสตร์และเทคโนโลยี
![ความรักของยักษ์เขียว (ทศกัณฐ์) - เดี่ยว ไออุ่น [OFFICIAL MUSICVIDEO 4K]](http://i.ytimg.com/vi/yCCy-QVHqK8/mqdefault.jpg)
✅ Download the free course files to follow along and practice what you learn ➡www.simonsezit.com/access-2019-beginner-to-advanced-course-files/
🔥Check out our FREE 300+ hour training course playlist here 👉th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🔥We have additional free tutorials for MS Access tutorials here 👉
th-cam.com/play/PLzj7TwUeMQ3g7dabQhzlqljY-bnxv1YFA.html
very educative and thanks a lot for this wonderful opportunity.
great
Dear Deborah Ashby, I wanted to take a moment to thank you for the incredible Microsoft Access Tutorial. Your explanations were clear and concise, and your voice was easy to follow, making it a pleasure to learn from your videos. As a beginner (been using Access for just over a year now - regret why I did not learn it sooner a decade, or two ago), I found your tutorials incredibly helpful in building my skills in Microsoft Access, and I was able to progress quickly to more advanced features. I am truly grateful for your dedication to creating such high-quality educational content. Once again, thank you for your hard work and commitment to helping others learn. Your contributions to the community are greatly appreciated
Hi Deb, another detailed entire training course from Simonsez, looking forward to watching the programme.
Many Many thanks.
Gordon, Halifax UK.
You are very welcome, Gordon. Thank you for the kind feedback :-)
It is certainly the best Access course I had been exposed to in years. Deborah Ashby is very didactic, and her way of teaching is clear and follows the natural steps of learning. Deborah and Simon Sez IT, you are the best! Thank you very much.👍
Wow, thank you! You are very welcome 😃
She is taking english speaking teaching courses to the next level , quite calm yet rhythmic and imposing , should you jump on that tempo and mood you will learn no doubt!
Awesome tutorial. Deb is easy to understand, stays on track, and gave more than enough information for me to start a genealogy census records database linked to an ancestor DB and locality DB.
Awesome, that is great to hear! Thanks for watching! 🙂
thanks a lot, really waiting for it.
Thank you Deb Ashley and thank you SimonSezIT for this very good ACCESS video
You are so welcome! Thanks for taking the time to leave a nice comment :-)
The First hour and a half is very basic "Tips for using MS office" and has little to do specifically with Access.
From 1:30:00 to 3:40:00 is the introduction to Access up to creating your first link table/ relationship.
At 3:40:00 the class breaks off abruptly, just before beginning Forms, and we jump ahead to the "Advanced" portion of the class
When the class instruction picks up again at 3:47:00, we see that the forms have all been created for our exercise database. That whole section of the Beginner course, where we learned how to make forms, has been skipped.
Hi! I know this is late, but we do have a separate video on Access Forms that might help: th-cam.com/video/-wjrRhOjuaU/w-d-xo.html
Thank you! I am working through this course. I find it incredible, and I am glad there is a form section. I appreciate the follow up to that comment you replied to@@SimonSezIT
Very well explained. Easy to understand.👌
Thanks for watching our training, Ravi 😀
Thank you Deb Ashley and thank you SimonSezIT for this helpful video access 😀
You are so welcome!
Deb, you are the best instructor!
Thank you for your kind comment! It's always heartwarming to hear that my teaching is appreciated. Thanks for watching 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
This has been great. TY!
Thank you too!
Deb you are such a great teacher i followed your 6hrs cause and enjoyed it , keep up the good work
Thank you so much for your kind words, I'm glad you enjoyed the course! 😊
We have additional free tutorials for MS Access tutorials here 👉
th-cam.com/play/PLzj7TwUeMQ3g7dabQhzlqljY-bnxv1YFA.html
nice training................... thanks alot
hi deb, thanks for that great course you offered, I was to start access in these days.
Hope you enjoy it! 🙂
Thank you very, very much for this course. This is helping me a lot. Very well explained and easy to understand.👍
Glad it was helpful! We have additional free tutorials for MS Access tutorials here 👉
th-cam.com/play/PLzj7TwUeMQ3g7dabQhzlqljY-bnxv1YFA.html
Thank you so much
really great tutorial !
Thank you so much
Thanks a bunch for the shoutout! We're thrilled that you found the tutorial really helpful. 😊
We have additional free tutorials for MS Access tutorials here 👉
th-cam.com/play/PLzj7TwUeMQ3g7dabQhzlqljY-bnxv1YFA.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
I am waiting brother 👍👍👍
We hope the training meets and exceeds your expectations! Thanks for watching :-)
dziękuję za pomoc, wszystko rozumiem. Elastico fantastico.
Thank you
Many thanks Deborah. ❤
Glad you enjoyed it! Thanks for leaving a nice comment. ❤
This training is so fantastic and I like the calmness of the facilitator although she has hidden her face.
I am a teacher and I'm enjoying your MS Access tutorials so much, especially your voice.
Wow, thank you!
Good work.
Thanks for your positive feedback.😊
We have a lot more courses on MS Office and other topics, with 300+ hours of free training here 👉 th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
The imports work fine in the exercises but if you change the lookup to "allow multiple values" in let's say the ActivityLevel field then you can no longer import any data into the table from excel or a text file... So what is a workaround to be able to import data into access with a table that has a lookup with "allow multiple values" enabled?
You are explaining everything So Clearly-
Are you offering A certificate to candidate?
Many years ago I tryed to do some work with Access, did one database for my brothers wines, did it all from scratch just by trail and error but soon got it to work as I wanted. Then it all just stopped there, I found Excel and it was easier to use, not so advanced as Access, but not as nice to look at.
So, why not try it again and here I am, following your tutorial and enjoy every minute of it. Great work from all of you... Thumbs up from Sweden 🙂
Hey there! Thanks a bunch for sharing your experience. It's always interesting to hear how our journeys with different software unfold. We're glad you're finding the tutorial enjoyable and we hope it's helping you dive back into the world of Access. Thumbs up from Sweden to you too! 😊
We have additional free tutorials for MS Access tutorials here 👉
th-cam.com/play/PLzj7TwUeMQ3g7dabQhzlqljY-bnxv1YFA.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
tbl Tour Trip Type Table Tab Triptype, Data Type. I'm sure all this alliteration and duplicate word choices seemed like a good idea at the beginning...
Where there is continuation of access videos such as reports. I am having problem with gaps vertical, even using set up shrink. The gaps happens when street line, or city or zip or state or fax is not available. It's a directory of 24 counties. Not all counties provided all the data. The report presents uneven space between each paragraph. Although I make same size for each field. The only field I made bigger box is the County name and drop cap to stand out. Thank you for all your videos.
At 6:25 -- Office 2019 Home and Business doesn't include Access. Why is that being shown as an option for obtaining Access?
Hello, Deb; question: is everything done in DB, forms, and design mode; has the corresponding VBA code behind the screen?
IOW, is everything we see in an Access DB will have a VBA code behind it?
Could all the screens, including aesthetics (look, layout, color scheme) be created with VBA code in Access?
Finally, does Simon Sez It have a similar extended course of using VBA with Access?
Do you have any course on Microsoft access 360 which includes professional form designing as well VBA basic knowledge
No, but our course for Access 2021 is coming out soon, which will have functions closer to the 365 version.
Thumbs up!
In the relational tables section when you’re working with the link table, you drag and drop, well that is fine, I am visually impaired and do not drag and drop, so how do I do this strictly with keyboard shortcuts?😊
Deborah, The text file "EspiritDeTourTripImport.txt does not import. Error Message = FieldDuration Days does not exist in destination table 'tbltrip'. I have checked, it does appear in the tbltrip table in access, but not in the text file. It does not import the excel file with the same message, but Field Duration Days is in the excel file as well as the Access file. I can not go any further, because the files do not import.
Deborah I am sorry. It was my mistake. I found it and corrected it. In my table the field name "DurationDays" was only "Duration". Therefore, because the field name was different, Access did not want to allow it to be imported. After I corrected it, it imported perfectly.
Dear Deborah, Do you have a SQL or MySQL course similar to the Access Course?
How do you make multiple lines text fields? The only way is CTRL+Enter but you see just a part of the text and you can't add a scrollbar. If you increase the field height it messes the resolution of the YES/NO checkbox next to it if you have one. You didn't put the original destriction of the trip which was long. You put a short version.
Unable to import the text or Excel spreadsheet with Access from Office 365. Just keep getting the error "Cannot perform this operation", then I click OK, then another error pops up saying "An error occurred trying to import file ''. The file was not imported." Do you know why that would be? I'm using a new Windows 11
This is an amazing compliation however, one major hick-up I'm facing with Microsoft Access is on currency. How can I change the default currency in Microsoft Access 2019 in a manner that it works for all data?
It seems this bit hasn't been exhaustively figured out.
I'm new to this but I feel like there's some coding that can be done somewhere to offer a more satisfying permanent solution for one's Access copy.
go to design view and click format to change determined field
6:36:48 Did I miss it or did you not explain the SetTempVar? 😢
OK - OMG - gaping hole alert: at 3:32:08, where you set-up the countries visited, there is no segment that tutors for this table or the TblTripCountry at 3:32:19. Need some continuity here ... 🙄
Hey Deb, at 2:00:01, there's a check box feature that appears on the "Country" selection column in the datasheet view that isn't covered in the narrative. Since I just started watching this series, I'm wondering if that will be covered at a later time in the series. If so, you might consider adding some kind of subtitle that effect so folks aren't sitting around wondering what was missed.
Hi! In the Lookup Field Properties, setting the Allow Multiple Values field to Yes will show the checkbox in your table.
Perfect - thank you! @@SimonSezIT
Hello... Its interesting and capturing attention. However, I am unable to download exercise. Please help me on it.
Sorry to learn about this issue. Please try clearing your browser cache or trying another web browser.
Could not import either the Excel or text files into the Esprit De Tour tbltrip file. I checked all the field names to be sure they were correct, etc. but I keep getting the following error message:
Microsoft Access was unable to append all the data to the table.
The contents of fields in 12 record(s) were deleted and 0 record(s) were lost due to key violations.
*if data was deleted, the data you pasted or imported doesn't match the field data types or the FieldSize property in the destination table.
*if records were lost, either the records you pasted contain primary key values that already exist in the destination table, or they violate referential integrity rules for a relationship defined between tables.
Do you want to proceed anyway?
and I cannot import the data. Suggestions?
What you didn't do I check the column headers radio button
Why enter 0 for both the minimum and maximum prices and then change them?
im watching this before my exam. im gonna fail its too late
Good luck with your exam! :-)
@@SimonSezIT cheers
Did you pass?
If you want to gain complete knowlege of MS Access then do watch this video and use the free course materials
You're spot on!
Cant download course files
Easily skip first 1.30 Hours.
I never took a Microsoft course. Test proved that I was 98% Excel proficient, she taught me how to change the basics. Other need that.
Is there query section? I could not see it
Query is not included in this long video but check some of these short videos we have:
th-cam.com/video/Xh30Xa9pvGM/w-d-xo.html
th-cam.com/video/WA05h2_tMs8/w-d-xo.html
Hope this helps!
@@SimonSezIT Thanks, I already found your videos and watching now (:
And I was a fool to buy this course on udemy while it is available freely on youtube.
The entire course is not included on TH-cam. But we're glad you are enjoying the free content :-)
@@SimonSezIT I came to youtube because the server on udemy wasn't working from some hours, and found this.
5:12:50
5:27:52
Never taught us about forms, reports and queries only tables!
I don't get the excitement in the comments. I would have preferred a basic course, explaining how to build a database from tables, to form, to views and reports... Ant then moving into more advanced stuff, like relations and whatnot. Instead the course goes from something very basic, like how to make bold font, or table creation, to then spend a lot of time talking about filters, indexes.... without ever even touching forms and such. Not practical at all for real cases, especially for the hours invested, not much is teached that can be applied effectively
Not very straight to the point
I love Deb's accent -- but the audio quality is horrible. It sounds like she's recording in the bottom of a steel barrel, and the hollow reverberation makes her very difficult to understand.
Also, at the introduction a man says that they are making the tutorial sample files available for free. That's true -- but it comes with a big caveat: To get them you have to provide your e-mail address and agree to subscribe to their mailing list. Your mileage may vary, but that's not a fair exchange. Give me the files, let me do this course, and THEN if I like it I might subscribe. Trying to force me to subscribe in advance is a complete turn-off.