Page 59 - TP_Modular_V2.1_Class7
P. 59
Step 2 Select the More option and then select Options option. The Excel Options dialog box
appears.
Step 3 Click on the Customize Ribbon option from the left pane.
Step 4 Select the Commands Not in the
Ribbon option from the Choose
commands from drop-down list. A list
of commands that are not visible on the
ribbon appears.
Step 5 Create a new tab or group. Select the
tab and group you have just created to
add the Form command.
Step 6 Select the Form command and click
on the Add>> button to add the
command in the selected group. The
Form command appears under the
selected group. Excel Options dialog box
Step 7 Click on the OK button. The Form command will appear on the ribbon.
Form command on ribbon
USING FORM IN EXCEL
As you know that you can add, update and delete a record using a form. A form displays only
one record at a time. To perform all these operations, first you need to create an Excel worksheet
and enter the desired data.
Adding a New Record
Perform the following steps to add a new record:
Step 1 Click on the Form command from
the ribbon. The Sheet1 dialog box
appears displaying the first record
from the worksheet.
Step 2 Click on the New button. All the
fields will be blank.
Step 3 Enter the details and click on the
Close button. Record will be added
Sheet1 dialog box Adding a record
in the worksheet.
Searching a Record
Follow the given steps to search a particular record:
Step 1 Click on the Form command. The Sheet1 dialog box appears.
Step 2 Click on the Criteria button. All the fields of the form will be appeared blank.
Excel as Database 57

