Page 36 - Computer Genius Class 07
P. 36

As  you  know that  the Excel 2016 is used to store  data.  Excel 2016 allows  you  to use an Excel
                  workbook as a database. A database implies that organising the data in a manner which helps to
                  store and retrie e a large amount o  data e ciently. The data ase concept is one o  the oldest  ays
                  to maintain records in a con entional file oriented data collection system. For e ample  students
                  record in school  items record in shop and employees record in an organisation are some e amples
                  of database.









                             Field







                           Record









                  A database contains data in the form of rows and columns. A column is called a Field. It contains only
                  a single piece o  data.   ery column has a name li e  mployee  ode   mployee  ame  Department
                  etc. A set o   alues  or the fields is called a Record.

                  Form in Excel

                  One of the most important features of Excel 2016 is form. A form is a window used to display or
                  enter a record in an Excel worksheet. It provides various controls like text box and buttons to enter
                  and update data.  e ore using an   cel file as data ase  you must ensure that e ery column has a
                  heading as form uses these headings to enter or retrieve a record.
                   y  de ault   Form  command  is  not   isi le  on  the  ri  on.  To   ie   the  Form  command    ollo   the
                  given steps:








                            1  Click on the File tab.






                                                                  2  Select the
                                                                  Options option.




                       34    Computer Genius-VII
   31   32   33   34   35   36   37   38   39   40   41