Page 277 - IT_V1.0_Class10
P. 277

Recap Zone


                       A form is a database object with a user-friendly interface for entering and viewing data in a visually
                      appealing and readable way.
                       When you see the form in the Form View mode, it displays the records.
                       At the bottom of the Database Form window, you’ll find the Form Navigation toolbar, which includes
                      navigation buttons.
                       In LibreOffice Base, you can rearrange the controls on your form as needed.
                       A tooltip is a small piece of text that is displayed when the mouse pointer is placed on a particular
                      control.
                       The Forms Controls toolbar in LibreOffice Base contains tools that are used for creating and managing
                      forms.
                       LibreOffice Base allows you to add or delete records from a form to the related table.
                       In LibreOffice Base, reports help you to analyse and interpret data.
                       The Report Controls toolbar contains the controls including Label, Text Box and Image.




                                                            Exercise



                                                   Section A (Objective Type Questions)
                 A.  Multiple choice questions.
                    1.  Which of the following allows you to view, enter and delete data in database?
                       i.  Report             ii.  Form                iii.  Query                   iv.  None of these
                    2.  In LibreOffice Base, ............................. helps to display the data in a summarised manner.
                       i.  Report             ii.  Form                iii.  Query                   iv.  Summary
                    3.  Which button on the Form Navigation toolbar is used to search for a specific record?
                       i.  New Record         ii.  Save Record         iii.  Find Record             iv.  Undo
                    4.  To generate a report in LibreOffice Base, which object can be used?
                       i.  Tables             ii.  Queries             iii.  Forms                   iv.  Both i and ii
                    5.  You are designing a form and need to add a tooltip for the “Customer ID” field to explain its purpose. What
                      should you do?
                       i.  Double-click the Text Box control for “Customer ID” and enter the tooltip in the Help text box
                       ii.  Right-click the form and select “Add Tooltip”
                       iii. Use the Form Controls toolbar to insert a tooltip
                       iv. Change the background color of the form

                 B.  State whether the following statements are true or false:
                     1.  Forms in a database are used to view and print information but cannot be used to enter
                      or modify data.                                                                        ............................
                     2.  Reports in a database can only present information from a single table.             ............................
                     3.  You can delete a record directly without any confirmation in LibreOffice Base.      ............................
                     4.  The “Undo Data Entry” button reverts the last entered data in a form.               ............................
                     5.  Tooltips help users understand the purpose of form controls in LibreOffice Base.    ............................




                                                                                               Forms and Reports    275
   272   273   274   275   276   277   278   279   280   281   282