Page 46 - Dig_CodeAI_V2.1_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 (Ver. 2.1)-VII
   41   42   43   44   45   46   47   48   49   50   51