Microsoft Access Forms Tutorial: MS Access 2019

✅ Download the free course exercise files to follow along

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.

📝 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

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[khalilsoussou]

Deborah is wonderful instructor. I love the way she explains things. Thank you.

[monicaharmsen]

Thank you for sharing your knowledge via this video. Deborah has a nice tone of voice and good pace of explaining MS Access.

[yczeqdy]

Thank you so much, Deborah. The way you present is quite interesting!

[nadeemsalim]

@SimonSezIT - Not exercise files are included in download link, please update the download zip to include the missing exercise files. Thank you.

[tllwrcm]

Thanks for the great effort and I hope you keep streaming the Access videos

[stephaniewhitley]

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.

[Jamiewharton]

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.

[voliol]

I did not find what I was looking for here, but it was a decent tutorial nonetheless, picked up a few new things.

[Trisha_an_Artist]

Thank you. Only this way I'm able to understand the access

[wanjohimwangi]

Quite guiding. Thanks a lot dear tutor

[amy]

This is a really well done tutorial that answered all the questions I was trying (and failing) to figure out with other resources.

[Mattiphob]

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.

[garycannell]

Excellent Tutorial, very well articulated.

[RenjiSann]

Thanks :) (Made me laugh when you said "recorded in Nov-2019", because at this time you still could travel)

[satyabanukil]

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.

[rexcelsolutionsab]

The files I got when I signed up was not the same as in the tutorial. I got some files about movies.

[kaaa]

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

[stephaniewhitley]

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.

[brookesmith]

The exercise files provided are not the correct files for this tutorial.

[dara_]

design view looks nothing like its end result ...
ms 🙄