Microsoft Access Forms Tutorial: MS Access 2019
HTML-код
- Опубликовано: 1 авг 2024
- ✅ Download the free course exercise files to follow along
➡️ www.simonsezit.com/access-2019...
In this Microsoft Access forms tutorial, we teach you how to create a form in Access 2019, how to modify a form and change the layout and design. We then look at setting up Subforms in Access.
This Access tutorial is an extract from our full Microsoft Access 2019 course, available here ➡️bit.ly/3x8Qm1H
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
0:00:00 - Course Introduction
0:00:19 - Creating a Form
0:12:58 - Modifying a Form
0:18:29 - Exercise 04
0:20:38 - Forms in Layout View
0:31:50 - Forms in Design View
0:41:51 - Form Design
0:53:51 - Exercise 05
0:54:47 - Setting Up Subforms - Part 1
1:07:48 - Setting Up Subforms - Part 2
1:17:01 - Setting Up Subforms - Part 3
1:30:27 - Exercise 06
🌍 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:
ruclips.net/user/simonsezittra...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-) Наука
Deborah is wonderful instructor. I love the way she explains things. Thank you.
Thank you for sharing your knowledge via this video. Deborah has a nice tone of voice and good pace of explaining MS Access.
Thank you so much ,Deborah. The way you present is quite interesting!
Quite guiding. Thanks a lot dear tutor
Thank you. Only this way I'm able to understand the access
That is really amazing!
I did not find what I was looking for here, but it was a decent tutorial nonetheless, picked up a few new things.
VERY USEFUL, THANKS SO MUCH!!!
You're welcome!
great course ! Thank you so much
Thanks a bunch for the positive feedback! We're stoked that you found the course awesome! 😊
We have additional free tutorials for MS Access tutorials here 👉
ruclips.net/p/PLzj7TwUeMQ3g7dabQhzlqljY-bnxv1YFA
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
Great video!!! Thanks!!
Glad you enjoyed it. Thanks for watching! 🙂
Magnificent
Really like this tutorial -- Two suggestions: Would like it if you zoomed in more when talking about a certain area. Everything is so small it's too hard to see. Also, captioning would be helpful. I also have a comment: I always hide my ID field by making the field, border and text the same color as my background. I don't see that it's necessary for my users to see this field.
This is a really well done tutorial that answered all the questions I was trying (and failing) to figure out with other resources.
Glad to hear!
Thanks for the great effort and I hope you keep streaming the Access videos
More to come!
Excellent Tutorial, very well articulated.
Glad you think so!
Nice
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
Very good presentation.
Thanks for watching Kumaran!
@SimonSezIT - Not exercise files are included in download link, please update the download zip to include the missing exercise files. Thank you.
can i remove that status column on the left of the form? you don't see that in the design view of the form, but when you are in the form view you will see that vertical black line from top to bottom.
it is helpful
Thank you Kou Naren! We recently uploaded a 7-hour beginner and advanced course, if you need additional MS Access training -> ruclips.net/video/jCG2MTH9Ftw/видео.html
Excellent
Thank you so much 😀
Superb 👌
Thanks 🤗
I have a tabular form where there is a column called ABScore which has 5 rows each row against each row, which means there are 5 records under ABScore Col. Now I want to row number 1 will loop through other 9 records and compare with other rows. If row number 1 carries highest value, then it will put 1 to the column next to it since it secured highest point. Similarly, the second row will compare value with other 4 rows i. e. Rows 1, 3, 4 and 5 and make appropriate ranking against it's corresponding rank row. But I don't know the way how to do it. I'm from India where scope to learn is very small. Therefore request you to please make a tutorial on updating records by looping. Thnx and regards.
👌👌👌👌👌
Last exercise is too much of a rush, so many tasks given in such a short time I don't really know what I'm supposed to be producing.
Another comment: On the subforms part 2 it looked like she was going to explain how to use one form for two functions; 1) to add/edit and 2) to display for users. It's confusing because she just modifies the subform to be viewed by users, but then how would the staff edit it if it's the same form? Very confusing.
Thanks :) (Made me laugh when you said "recorded in Nov-2019", because at this time you still could travel)
The files I got when I signed up was not the same as in the tutorial. I got some files about movies.
Lol, I never even got any files so....
I cannot get these files to send
The exercise files provided are not the correct files for this tutorial.
🥰
Why do you make it impossible to get your files?
Sorry, we've noticed that the link sometimes doesn't load recently but one workaround that I found helpful was to open the download link in a new private/incognito browser. Hope that helps!
I found that I could not download them directly, but if you save them to a dropbox account first, you can then download them from the account.
design view looks nothing like its end result ...
ms 🙄
Screen is fuzzy.
Exemplary
Thanks Dominic, i appreciate that.
i think u said same things over and over again but thx
Thanks for your feedback. Hope you’ve enjoyed the tutorial
fake
Wish it was in American accent, I find this accent very annoying and distracting, thumbs down