Access: Creating Forms

In this video, you’ll learn the basics of creating forms in Access 2019, Access 2016, and Office 365. Visit edu.gcfglobal.... for our text-based lesson.
This video includes information on:
• Adding additional fields to a form
• Adding design controls
• Creating a combo box
• Using subforms
We hope you enjoy!

[@johnsharples7129]

This is truly masterful. Easy to follow and beautifully enunciated. Thank you.
A question for you. I am converting a large flat database to relational using the "Analyze table" wizard. How do I increase the size of the window as I can't scroll to all of the created tables?

[@vishanagrawal2487]

Thanks sir

[@GerBargerbos]

Great intro. All I needed to get started. Thanks!!

[@nemo9396]

If you need to add like a hundred different drop down menus / combo boxes, do you do them one by one? What if you have all the fields ready in Excel, how do you approach importing data for multiple combo boxes? Do you need a different table for each of those 100 combo boxes?

[@stephenguan9443]

Excellent Video, but i don't know how to make that search function. anyone can help or share the file or code?
A million thanks.

[@11101nagw]

I'm writing tomorrow lol So I'm watching most of your vids. Thanks!!!

[@sakshampundir5825]

Thank you

[@megan2484]

When I click the combo box in the field, nothing happens. The wizard box does not open to allow me to enter values.

[@GCFLearnFree]

Sounds like a glitch. Have you tried closing Access 2016 entirely and then reopening it?

[@megan2484]

@@GCFLearnFree I did and it worked for a while, but then it's back to not working.

[@GCFLearnFree]

We're sorry to hear it! Unfortunately, we're a small nonprofit and don't offer troubleshooting services. We recommend further Googling this to see whether it's a common and/or easily fixable Access issue. Sorry we couldn't be more helpful to you!

[@megan2484]

@@GCFLearnFree it's fine. I found a way around it. :) thanks

[@heartyrkhives]

I hope I can do it on my phone 😫

[@abilmomin8871]

Thanx for saving my time

[@Sunflower0508]

This is amazing
Your videos helped me out alot
Thank you soo much

[@GCFLearnFree]

You are so welcome!

[@tishanyamckenzie7653]

This is a lovely and informative video

[@Steynkasegwe]

Very beautiful worked like magic

[@yalobeko7978]

Thank you

[@NuCrowe]

So my supervisor is asking me to pull any info from the form I created on any student( I work at a college). He thinks the form is like an online data base, kinda like a search engine but isn't this limited to the main access data base? Isn't the form just a duplicate of your access data sheet right? So what he is asking can't be possible. Am I wrong? Some help please.

[@GCFLearnFree]

If the student data is stored in an online database, it may be possible to pull data with an Access form (even if it isn’t stored in your Access database). However, you will first need to link your Access database to the online database, which is fairly advanced. This is a bit outside our area of expertise, but this article may help you decide whether this will be feasible with your database: support.office.com/en-us/article/Import-or-link-to-data-in-an-SQL-Server-database-a5a3b4eb-57b9-45a0-b732-77bc6089b84e.

[@NuCrowe]

I found what I needed, thank you!

[@manthanpatki146]

Awesome video

[@abilmomin8871]

can I get the template of it ??

[@GCFLearnFree]

Yes, we do! Just check out our text-based lesson, go to the bottom of the page, and click on Practice Database to download. Hope this helps!

[@jacobkaufman5315]

This video is clear and helps greatly. Thank you!

[@henryhunter1773]

So helpful!
I really needed to learn this quickly, thanks for the upload

[@GCFLearnFree]

No problem!

[@ruthvikkrishna1420]

thanks for the help i have a computer test tomorrow

[@GCFLearnFree]

Best of luck!

[@zamakhwakha9789]

excellent. thanks a lot.

[@GCFLearnFree]

You are welcome!

[@Lam-ll1lh]

Excellent video!!!