Page 61 - modular4.0
P. 61

Chapter Profile
                 Before using an Excel file as database, you must ensure that every column has a heading, as form
                 uses these headings to enter or retrieve a record.
                 By default, Form command is not visible on the ribbon. Follow the given steps to view the Form

                 command:






                     1   Click  on
                     the File tab.


                                                                                                   2   Select  the
                                                                                                   Options option.






                                        4   Select the Commands Not in the
                                          Ribbon option from the Choose
                                          commands from drop-down list.
                                                                                                    6    Select   the
                                                                                                    Form command
                                                                                                    and click on the
                                                                                                    Add >> button
                                                                                                    to    add    the
                                                                                                    command in the
                   3  Click on the                                                                  selected group.
                  Customize
                  Ribbon option.
                                                                                                    5  Click on Insert
                                                                                                    under Main Tabs
                                                                                                    and click on New
                                                                                                    Group     button
                                                                                                    to create a  new
                                                                                                    group.






                                                                   7  Click on the OK button.


                 The Form command will appear 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 required data.






                                                                                                   Excel as Database  59
   56   57   58   59   60   61   62   63   64   65   66