Page 53 - ModularV1.1 _c7_flipbook
P. 53
Step 2 Select the 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 appear.
Step 5 Select the tab and group in which you
want to add the Form command. You
can also create a new tab or group.
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, 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 any record.
Step 2 Click on the Form command
from the ribbon. The Sheet1
dialog box appears displaying
the first record from the
worksheet.
Step 3 Click on the New button. All the
fields will be blank. Sheet1 dialog box Adding a record
Step 4 Enter the details and click on the Close button. Record will be added 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 appear blank.
Excel as Database 51

