Access: Formatting Forms

[@junhaozheng5692]

thank you, and in just under one hour, i've learned all the basics to Access, thank you. This software has haunted me for years. Thank you thank you.

[@ruonanlin8131]

Your video really a life saver! Thank u!!!!

[@mhhh6349]

how can i describe a form as in let say its an organisation and you want to describe the members

[@rederatv]

When I hit tab on the keyboard, the highlighted field does not move in the order listed in the table. How can I resolve that?

[@saumyasrivastava7296]

Sir I have questions please solve what is formatting axis

[@i-dreamgraphics7352]

Good work!!, thank you

[@GCFLearnFree]

Welcome!

[@hareee234]

It looks like my access version does not show a pop up with the button command wizard, struggling to create an action for the button. Is it a build event?

[@GCFLearnFree]

Unfortunately, we can't provide specific troubleshooting advice.

[@Fox11836]

I had to click the drop-down button for the controls section on the Design tab, and right-click and add Use Controls Wizards to my quick access bar. In the quick access bar, I made sure it was on by looking for the icon to shadowed. I then had to go to the design view instead of the layout view. Then I selected the button from the controls section and in the detail section on the form I held the left mouse button to create the button to the size I wanted. As soon as I let go of the left mouse button the wizard finally opened.

[@muhammadidrees3322]

I have a question, that can we have one single form for entering data into two tables with different name's, have common fields...?

[@GCFLearnFree]

It is possible to add data to more than one table from a single form. If a table is connected to another table (with a table relationship), Access will add a subform automatically when you create a form based on the table. You can read our lesson on Creating Forms for more information: edu.gcfglobal.org/en/access2016/creating-forms/1/. Hope it helps!

[@fahri767]

is there any access file that we can download?

[@GCFLearnFree]

There is! You can click here to access our text-based Access 2016 tutorial, which has a downloadable sample database available in most of the lessons: www.gcflearnfree.org/access2016/. We hope it helps!

[@ahmedalmulki]

how to let users use this form , is there any good way i don't want my users open Access every time ?

[@GCFLearnFree]

I'm sorry, but they'll need Access to be able to open the database. You can click here for our free Access 2016 text-based tutorial, which has sample databases for you to use: www.gcflearnfree.org/access2016. We hope it helps!

[@lastfirst23163]

Could Access forms be used to create a questionnaire consisting of hundreds of questions?

[@GCFLearnFree]

Forms can certainly be used for this, although each question will probably need to be manually created. We're not sure if there's a way to speed up the process, but we feel like it would be a fairly involved form. We hope this helps!

[@lastfirst23163]

I was wondering because right now I have a table with ID's for each question and answer plus the text for every answer and question in those tables. But if I could just make a form with multiple fields it would work in a similar manner maybe? Just curious, thank you for your quick response.

[@GCFLearnFree]

Yes, it could. It would be a very complex database though! We offer the basics in our tutorial here: www.gcflearnfree.org/access2016/.

[@SNEED456]

entering data in the form does not enter it in the table it is based on

[@GCFLearnFree]

If you're having trouble, you may want to review our text-based lesson on creating and using forms in Access 2016: www.gcflearnfree.org/access2016/creating-forms/1/. We hope it helps!