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
   48   49   50   51   52   53   54   55   56   57   58