Computer Science, asked by harithavs16, 4 months ago

What are all the steps involved in creating a form in MS access​

Answers

Answered by Nageshwar64912
4

Answer:

pls follow me and mark me as a branliest answer and give me thanks

Explanation:

To create a form:

In the Navigation pane, select the table you want to use to create a form. ...

Select the Create tab, locate the Forms group, and click the Form command. ...

Your form will be created and opened in Layout view. ...

To save the form, click the Save command on the Quick Access toolbar.

Answered by gwynethwingell3
1

Answer:

To create a form:

Access makes it easy to create a form from any table in your database. Any form you create from a table will let you view the data that's already in that table and add new data. Once you've created a form, you can modify it by adding additional fields and design controls like combo boxes.

In the Navigation pane, select the table you want to use to create a form. You do not need to open the table.

Select the Create tab, locate the Forms group, and click the Form command.

Your form will be created and opened in Layout view.

To save the form, click the Save command on the Quick Access toolbar. When prompted, type a name for the form, then click OK.

About sub forms

If you created a form from a table whose records are linked to another table, your form probably includes a sub form. A sub form is a datasheet form that displays linked records in a table-like format. For instance, the sub form included in the Customers form we just created displays linked customer orders.

We probably don't need to include this sub form because we just want to use the Customers form to enter and review contact information. If you find that you don't need a sub form, you can easily delete it. To do this, simply click it and press the Delete key on your keyboard.

However, sub forms are often quite helpful. Depending on the content and source of your form, you might find that the sub form contains useful information, like in the example below. In our Orders form, the sub form contains the name, quantity, and price of each item contained in the order, which is all useful information.

Adding additional fields to a form

When you use the Form command on an existing table, all of the fields from the table are included in the form. However, if you later add additional fields to the table, these fields will not automatically show up in existing forms. In situations like this, you can add additional fields to a form.

To add a field to a form:

Select the Design tab, then locate the Tools group on the right side of the Ribbon.

Click the Add Existing Fields command.

The Field List pane will appear. Double-click the desired field(s).

The field will be added.

You can also use the above procedure to add fields to a totally blank form. Simply create a form by clicking the Blank Form command on the Create tab, then follow the above steps to add the desired fields.

To add a field from a different table:

You can also add fields from different tables in your database to the form.

From the Field List pane, click Show All Tables.

Click the plus sign + next to the table that contains the field you want to add, then double-click the desired field.

The new field will be added.

Adding design controls

Design controls set restrictions on the fields in your forms. This helps you better control how the data is entered into your forms, which in turn helps keep the database consistent.

Combo boxes

A combo box is a drop-down list you can use in your form in place of a field. Combo boxes limit the information users can enter by forcing them to select only the options you have specified.

Combo boxes are useful for fields that have a limited number of possible valid responses. For instance, you might use a combo box to make sure people only enter a valid U.S. state while entering an address, or that they only choose products that already exist in your database while placing an order.

To create a combo box:

In Form Layout view, select the Design tab, then locate the Controls group.

Select the Combo Box command, which looks like a drop-down list.

Select the desired location for the combo box. A line will appear to indicate the location where your combo box will be created. In our example, we'll place it between the City field and the Add to Mailing List? fields.

The Combo Box Wizard dialog box will appear. Select I will type in the values that I want, then click Next.

Type the choices you want to appear in your drop-down list. Each choice should be on its own row.

In our example, we are creating a combo box for the Add to Mailing List? field in our form, so we will enter all of the possible valid responses for this field. Users will be able to select one of three choices from our finished combo box: No, Yes - Weekly, and Yes - Special Events and Offers.

Explanation:

Similar questions