Page 36 - Computer_Genius_v2.1_C7_flipbook
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 retrieve a large amount of data efficiently. The database concept is one of the oldest ways
                  to maintain records in a conventional file-oriented data collection system. For example, students
                  record in school, items record in shop and employees record in an organisation are some examples
                  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 of data. Every column has a name like Employee Code, Employee Name, Department,
                  etc. A set of values for 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. 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.  To  view  the  Form  command,  follow  the
                  given steps:








                            1  Click on the File tab.






                                                                  2  Select the
                                                                  Options option.




                       34    Computer Genius (V2.1)-VII
   31   32   33   34   35   36   37   38   39   40   41