Skip to main content
Business LibreTexts

17.11: Creating Basic Forms

  • Page ID
    46661
  • Learning Outcomes

    • Create basic forms

    Access makes it relatively easy to create a basic form.

    1. Select the table or query containing the data you are interested in seeing on your form in the Navigation pane.
    2. Go to the Create tab, and the Forms group and select Form.

    Access will create a basic form and open it in Layout view. You should be able to see the data you selected. In Layout view, you have some limited capabilities to make design changes to the form.

    In addition to creating a basic form, Access will check to see if there are one-to-many relationships existing between the table you selected to create the form and any other tables in the database. If so, it will add a datasheet based on the related table or query to your basic form. For example, if you create a basic form based on the Customers table, and there is a one-to-many relationship with the Orders table, Access will display all of the records in the Orders table that relate to the Customers table in Datasheet view.

    Learn More

    For detailed, step-by-step instructions Microsoft Access Help is an excellent resource and can be found by following this link: MS Access Help: Creating Forms