Page 46 - Digicode_AI_class_7
P. 46

4  Select the
                                                                                                Commands Not
              3  Select the Customize                                                           in the Ribbon
             Ribbon option from  the                                                            option from
             left pane.                                                                         the Choose
                                                                                                commands
                                                                                                from drop-down
                                                                                                list.
              6  Scroll down and select
             the Form command and
             then click on the Add>>                                                             5  Select the
             button.                                                                            Insert tab and
                                                                                                click on  the
                                                                                                New Group.




                                                                     7  Click on the OK button.








            The Form command will appear under the Insert tab on the 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:


                                                              2  Click on the Form
                            1  Click on the Insert tab.      command from the ribbon.







                 3  Click on the
                 New button.




                                                                                         4  Enter the details
                                                                                         and  click on  the
                                                                                         Close button.


            Record will be added in the worksheet.

                 44    DigiCode AI-VII
   41   42   43   44   45   46   47   48   49   50   51