Page 58 - TP_Modular_V2.1_Class7
P. 58

EXCEL AS DATABASE
                    06














                            Your Aim

                            to learn about:

                                     Form in Excel                           Using Form in Excel
                                       Sorting Data                            Filtering Data
                                        Conditional Formatting                   Using Data Validation
                                         Using Subtotal Command                  Using Pivot Table

                  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.

                  A database contains data  in
                  the form of rows and columns.
                  A  column is  called  a  Field.  It   Field
                  contains only a single piece of
                  data. Every column has a name
                  like  Employee  Code,  Employee
                                                       Record
                  Name, Department, etc. A set of
                  values for the fields is called a
                  Record.
                                                                               Data in Excel Worksheet
                      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:

                  Step 1   Open Excel 2016 and click on the File tab. The Backstage view appears.

                   56       Modular (Ver. 2.1)-VII
   53   54   55   56   57   58   59   60   61   62   63