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
   54   55   56   57   58   59   60   61   62   63   64