Page 45 - Digicode_AI_class_7
P. 45

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.




                                                                        Advanced Features of Excel 2016   43
   40   41   42   43   44   45   46   47   48   49   50