Creating Forms  «Prev  Next»
Lesson 3 Creating an AutoForm
Objective Create an AutoForm from the fields in one table.

Create Access AutoForm

Using the AutoForm feature is the easiest way to create a form. An AutoForm is a form created from one table: it displays all the fields in the table for one record at a time. If the table has subdatasheets, the AutoForm automatically creates a subform to display the subdatasheet.
There is more than one way to create an AutoForm.

Ways to create Access AutoForm

There are several other ways to create an AutoForm. Most notably, anywhere you see the New Object button (for instance, the datasheet view of both tables and queries) you can use it to create an AutoForm. However, there are actually three types of AutoForms, and you should know about all of them. Remember that the definition of an AutoForm is a form created from the fields in one table. However, the format of the AutoForm can vary. Three formats are available:
  1. Columnar: This format is what you create with the AutoForm button. The form is a two-column format with the list of field names on the left and the field contents on the right. Only one record is displayed at a time.
  2. Tabular: This format creates a glorified datasheet. It is a little more attractive, but it displays field names in a row along the top, and multiple records in rows underneath.
  3. Datasheet: This type of form looks like a datasheet. The form you created in the Simulation showed the fields from the Hours table in this style.

To choose the style of your AutoForm, follow these steps:
  1. Display the Forms view of the database window.
  2. Click the New button on the database window toolbar.

Access Formats 
New Form

Options:
- Form Wizard
- AutoForm: Columnar
- AutoForm: Tabular
- AutoForm: Datasheet
- Chart Wizard
- PivotTable Wizard

Create a new form without using a wizard.

Prompt:
Choose the table or query where the object's data comes from:
[Dropdown box for selection]

Corresponding Data:
  1. Form Creation Methods:
    • Form Wizard
    • AutoForm (Columnar, Tabular, Datasheet)
    • Chart Wizard
    • PivotTable Wizard
  2. Action:
    • Allows the user to select a table or query as the data source for the form creation.

  1. Select the type of AutoForm you would like to create from the three listed.
  2. Choose the table or query to base the form on.
  3. Click OK.


The steps below take you through the easiest way to create one: using the New Object button on the database window toolbar.
Window Toolbar
Window Toolbar

  1. The New Object button is the second to last button on the toolbar as shown here. You simply click the down arrow next to the New Object button to see the list of new objects, then select the AutoForm option.

Autoform Option
Autoform Option

  1. Access creates an AutoForm using the table that you selected. Because the Projects table had the Hours table defined as a subdatasheet, this form actually has two sections –
    1. the fields from the Projects table, and
    2. at the bottom, a datasheet-like presentation of the fields in the Hours table.
  2. When you close the form, Access will ask you if you want to save it. You can choose to use the name Access suggests (which will be the same as the name of the table the form is based on) or you can type a new name.
An AutoForm is a good way to create a form that you can then edit to make the form you really need.
Learn to display different records in a form, in the next lesson.

SEMrush Software 3 SEMrush Banner 3