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 Access 2013 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?

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

Create a form by using the Form tool? ›

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.

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.

What is the use of form tool? ›

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.

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

To create a new split form by using the Split Form tool, in the Navigation Pane, click the table or query that contains the data, and then on the Create tab, click More Forms, and then click Split Form. Access creates the form and you can make design changes to the form.

How to create a form using the form wizard in Access? ›

On the Create tab, in the Forms group, click Form Wizard. Follow the directions on the pages of the Form Wizard. Note: If you want to include fields from multiple tables and queries on the form, do not click Next or Finish after you select the fields from the first table or query on the first page of the Form Wizard.

How to create a form step by step? ›

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 to create forms easily? ›

Login to your Canva account and search for “form templates”.
  1. Pick a design or start with a blank template. Choose a pre-made form template design. ...
  2. Customize your form. Edit your form by adding text, labels, logos, and other graphic elements. ...
  3. Download and print. ...
  4. Publish and share your form.

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 free form tool? ›

Free-Form Select (with synonyms) is a technique in printmaking, graphic design and image processing. Result of a Free-Form Select. Original. Result. The effect is to erase background colors or elements from a motif to create stand-alone objects.

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.

Where is split form tool? ›

On the Create tab, in the Forms group, click More Forms, and then click Split Form.

How to create an Access form? ›

To create a form:
  1. In the Navigation pane, select the table you want to use to create a form. ...
  2. Select the Create tab, locate the Forms group, then click the Form command.
  3. Your form will be created and opened in Layout view.
  4. To save the form, click the Save command on the Quick Access Toolbar.

What is the difference between a form created using the form tool method and split form method? ›

A split form differs from a form/subform combination in that the two views are connected to the same data source and are synchronized with one another at all times. Selecting a field in one part of the form selects the same field in the other part of the form.

What is the difference between form and form wizard? ›

(a) Forms provide the basic means for inputting data for the application. (b) Form wizard helps you to create a form step by step.

What is form and form wizard? ›

The Data Form Wizard is a flexible tool which creates forms which execute a single query. The queries can be related to a single table in a database or to a query which uses many tables. When a query is executed a Recordset object is produced that represents all of the records, returned by the query.

How do I open a form in Access? ›

To open an existing form:
  1. Open your database, and locate the Navigation pane.
  2. In the Navigation pane, locate the form you want to open.
  3. Double-click the desired form.
  4. It will open and appear as a tab in the Document Tabs bar.

What is the best way to create a fillable form? ›

A step-by-step guide to creating a basic fillable form in Microsoft Word
  1. Opening Microsoft Word and starting a new document. ...
  2. Adding form fields (text boxes, checkboxes, radio buttons). ...
  3. Setting properties for each form field (label, options, default values). ...
  4. Testing the form within Word. ...
  5. Save and distribute your form.
Sep 20, 2023

What is the best program for creating forms? ›

Top 14 Form Builder Software
  1. ClickUp. ClickUp is the world's leading project management and form builder tool. ...
  2. Jotform. Via Jotform. ...
  3. Google Forms. Via Google Forms. ...
  4. Microsoft Forms. Via Microsoft Forms. ...
  5. Elementor Form Builder. Via Elementor. ...
  6. Feathery. via Feathery. ...
  7. Paperform. Via Paperform. ...
  8. Gravity Forms. Gravity Forms.

How do I turn a form into a fillable form? ›

Select a file or scan a document. Acrobat analyzes your document and adds form fields automatically. Add new form fields from the top toolbar, and adjust the layout using tools in the right pane. Save your fillable PDF form and share it with others, or click Distribute to collect responses automatically.

Top Articles
Latest Posts
Article information

Author: Lidia Grady

Last Updated:

Views: 5917

Rating: 4.4 / 5 (65 voted)

Reviews: 80% of readers found this page helpful

Author information

Name: Lidia Grady

Birthday: 1992-01-22

Address: Suite 493 356 Dale Fall, New Wanda, RI 52485

Phone: +29914464387516

Job: Customer Engineer

Hobby: Cryptography, Writing, Dowsing, Stand-up comedy, Calligraphy, Web surfing, Ghost hunting

Introduction: My name is Lidia Grady, I am a thankful, fine, glamorous, lucky, lively, pleasant, shiny person who loves writing and wants to share my knowledge and understanding with you.