Create a form by using the Form tool (2024)

Create a form by using the Form tool

Access for Microsoft 365 Access 2021 Access 2019 Access 2016 More...Less

You can use the Form tool in Access to quickly create a single item form. This type of form displays information about one record at a time, as shown in the following illustration:

Create a form by using the Form tool (1)

1. The form displays information for a single record.

2. In some cases, Access adds a subdatasheet to display related information. For more information, see the section Automatic subdatasheet creation.

When you use the Form tool, all the fields from the underlying data source are added to the form. You can start to use the new form immediately, or you can modify it in Layout view or Design view to better suit your needs.

Note:This article doesn’t apply to Access web apps – the kind of database you design with Access and publish online.

Create a single item form

  1. In the Navigation Pane, click the table or query that contains the data that you want to see on the form.

  2. On the Create tab, in the Forms group, click Form.

    Access creates the form and displays it in Layout view. In Layout view, you can make design changes to the form while it is displaying data. For example, you can adjust the size of the text boxes to fit the data. For more information about form views, see the article Which view should I use: Layout view or Design view?

  3. To begin working with the form, switch to Form view:

    • On the Home tab, in the Views group, click View, and then click Form View.

Automatic subdatasheet creation

If Access finds a table that has a one-to-many relationship with the table or query that you used to create the form, Access adds a subdatasheet to the form that is based on the related table or query. For example, if you create a simple form that is based on the Customer table, and there is a one-to-many relationship defined between the Customer table and Orders table, the subdatasheet displays all the records in the Orders table that pertain to the current Customer record. If you decide that you do not want the subdatasheet on the form, you can delete the subdatasheet by switching to Layout view, selecting the datasheet, and then pressing DELETE.

If there is more than one table with a one-to-many relationship to the table that you used to create the form, Access does not add any datasheets to the form.

Need more help?

Want more options?

Discover Community

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Create a form by using the Form tool (2024)

FAQs

How do you Create a form using the form tool? ›

On the Create tab, in the Forms group, click Form. Access creates the form and displays it in Layout view. In Layout view, you can make design changes to the form while it is displaying data. For example, you can adjust the size of the text boxes to fit the data.

How do I Create a form form? ›

Create a form using a template
  1. Start at forms.office.com.
  2. Select My forms.
  3. Select a template.
  4. Select Preview>Computer or Mobile.
  5. Select Back to choose another template or edit the selected template.
  6. To edit a template, select a question to edit.
  7. Edit the question and/or the options specific to each type of question.

Which type of form is created using the form tool? ›

A basic form can be easily created by using the Form tool.

How do you Create a form in Access? ›

Create a form from an existing table or query in Access. To create a form from a table or query in your database, in the Navigation Pane, click the table or query that contains the data for your form, and on the Create tab, click Form. Access creates a form and displays it in Layout view.

What is the best tool to create a form? ›

  • Via Google Forms.
  • Via Microsoft Forms.
  • via Feathery.
  • Via Zoho Forms.
  • Via Ninja Forms.
  • Via Hubspot.
  • Via OnePageCRM.
  • Via LeadGen App.
Feb 13, 2024

What is the form tool used? ›

A form tool is used by mounting it onto a lathe or other machining equipment and then using it to cut a specific shape or form into a workpiece. The tool is designed to be used in a single pass, which means that it can create the desired shape or form in one operation.

What is a form tool? ›

1. or form tool : a tool or machine accessory so shaped that it imparts a predetermined contour or profile to the work. 2. : a pair of light tongs with broad flat ends used in manipulating and shaping softened glass.

What is form and use of form? ›

At its core, a form is a tool for collecting and organizing information. It is a structured document with spaces allotted for entering data, whether it's for administrative purposes, data gathering, or record-keeping. Forms have an awesome ability to standardize and streamline data collection.

What are the three basic types of forms? ›

In the context of forms, there are generally three basic types: input forms, output forms, and query forms. Input forms are used to collect data from users, such as registration forms or order forms. Output forms present information to users, such as reports or confirmation pages.

Why is there a need to create Forms? ›

You can use forms to control access to data, such as which fields of data are displayed. For example, certain users may not need to see all of the fields in a table. ➡Forms collect information and add to your Contacts database.

How do you run a query? ›

Follow these steps to run queries and get the desired results:
  1. Open the Microsoft Access app.
  2. Choose the database that contains the table you're querying.
  3. Go to the “Query” tab.
  4. Select “New” and “Query Design”.
  5. Double-click the tables with the desired data.
  6. Choose your fields and criteria and click “Run”.

How do I Create a form in Google forms? ›

How to use Google Forms
  1. Step 1: Set up a new form or quiz. Go to forms.google.com. ...
  2. Step 2: Edit and format a form or quiz. You can add, edit, or format text, images, or videos in a form. ...
  3. Step 3: Send your form for people to fill out. When you are ready, you can send your form to others and collect their responses.

How do I Create a new form using the split form tool? ›

In the Navigation Pane, click the table or query that contains the data that you want on your form. Or, open the table or query in Datasheet view. On the Create tab, in the Forms group, click More Forms, and then click Split Form.

Top Articles
Latest Posts
Article information

Author: Rev. Leonie Wyman

Last Updated:

Views: 5848

Rating: 4.9 / 5 (79 voted)

Reviews: 94% of readers found this page helpful

Author information

Name: Rev. Leonie Wyman

Birthday: 1993-07-01

Address: Suite 763 6272 Lang Bypass, New Xochitlport, VT 72704-3308

Phone: +22014484519944

Job: Banking Officer

Hobby: Sailing, Gaming, Basketball, Calligraphy, Mycology, Astronomy, Juggling

Introduction: My name is Rev. Leonie Wyman, I am a colorful, tasty, splendid, fair, witty, gorgeous, splendid person who loves writing and wants to share my knowledge and understanding with you.