Page 52 - ModularV1.1 _c6_flipbook
P. 52

06                EXCEL AS DATABASE



















                            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, MS Excel is used to store data. MS Excel allows you to use an Excel workbook as
                  a database. A database implies organising the data in a manner that 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 records in
                  school, items records in shop and employees records in an organisation.

                  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         Field

                  name such as Employee Code,
                  Employee Name, Department,
                  etc. A set of values for the
                  fields is called a Record.         Record

                      FORM IN EXCEL                                            Data in Excel Worksheet

                  One of the most important features of MS Excel 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 MS Excel 2010 and click on the File tab. The Backstage view appears.




                  50      Modular (Ver. 1.1)-VII
   47   48   49   50   51   52   53   54   55   56   57