Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 45 - 2505_CoreGPT(Podar)_Flipbook_C7
P. 45

    4                       Using Calc as Database

                         Goal Glimpse

                             Using Form in Calc                              Sorting Data

                             Filtering Data                                  Using Validity
                             Calculating Subtotal in Database                Analysing Data using Pivot Tables

                     In the previous class, you have learnt how to format a Calc worksheet. Suppose, you have to highlight
                     cells that contain values greater than a particular value or sort data in ascending or descending
                     order. Calc provides you easy options for doing these types of formatting on a worksheet.

                           USING FORM IN CALC

                     The Form is a tool that makes it easier to add, edit and remove rows in tables within spreadsheets.
                     It helps you avoid scrolling sideways, especially when the table has many columns or wide ones.
                     To make the Calc data table work well, it should have a header row, where each cell has the name
                     of the column. These names in the header row will then be used as labels for each data field in
                     the form.
                     Adding a New Record

                     To add a new record in Calc, follow the given steps:

                     Step 1  Place the cursor in the header
                              row of the table.
                     Step 2  Click on the Data menu in the
                              Menu bar.

                     Step 3  Select Form option from the

                              drop-down menu.
                              The Data  Form dialog box
                              will appear on the screen.

                     Step 4  Fill in the desired data in the
                              form fields.

                                                                                            Using Calc as Database       43

| 40 41 42 43 44 45 46 47 48 49 50 |