Scribd Logo
Upload

Welcome to Scribd!

  • 5 views

    UNIT 3 CHAPTER 12

    Uploaded by

    Katsu Yamet

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    UNIT 3 CHAPTER 12

    Uploaded by

    Katsu Yamet
    5 views3 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    5 views3 pages

    UNIT 3 CHAPTER 12

    Uploaded by

    Katsu Yamet

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 3

    UNIT-3: DATABASE MANAGEMENT SYSTEM USING LIBREOFFICE BASE

    CHAPTER-12 Forms and Reports


    A. Multiple choice questions
    1. Which of the following toolbars contains the Label tool?
    (a) Standard Toolbar (b) Forms Controls Toolbar (c) Records toolbar (d) Formatting toolbar
    2. The Record toolbar has the buttons to move to the
    (a) first record (b) second record (c) last record (d) all records
    3. Which of the following is NOT true about forms?
    (a) It is the front end for data entry
    (b) It can contain only text fields
    (c) Graphics can be inserted on the form
    (d) It can contain only fixed number of records
    4. Which of the following keys is pressed to select only textbox on the form?
    (a) Alt (b) Shift (c) Ctrl (d) Tab
    5. Which of the following properties in the Properties: Label Field text box is used to insert a tool-tip on
    the form?
    (a) Tool Text (b) Help Text (c) Tool Tip (d) Help Tip
    6. Which of the following objects of LibreOffice Base is used to display data retrieved from one or more
    tables in a presentable manner?
    (a) Query (b) Form (c) Report (d) Panel
    7. Which of the following values of Date Format property is selected to view a calendar on the form?
    (a) Standard (short) (b) Standard (long) (c) Default (d) Standard (Medium)
    8. Which of the following commands on the Forms Control toolbar is used to toggle between Design
    View and Form view?
    (a) Design Mode (b) Toggle Mode (c) View Mode (d) Print mode
    9. Using which of the following objects in a database, can a report be generated?
    (a) Tables (b) Queries (c) Both a and b (d) Neither a nor b
    10. Which of the following components open along with the Report Wizard?
    (a) Report Builder (b) Add Fields dialog box (c) Both (a) and (b) (d) Neither (a) nor (b)

    B. State whether the following statements are True or False


    1. Report is an object of a database but form is not. FALSE
    2. We can choose the layout of the form. TRUE
    3. We have to add all fields of the table on the form. FALSE
    4. There are two ways n which a form can be created. TRUE
    5. A report is generated in a separate window. TRUE
    6. Once a control is added on to the form, it cannot be repositioned. FALSE
    7. The Record toolbar has the button to add a new record. TRUE
    8. We can create a report only using a table. FALSE
    9. By default, the records in a report are sorted in descending order. FALSE
    10. We can group data based on a particular field in a report. TRUE
    11. A report can have data only in row and column format. FALSE
    12. We can insert both date and time of generation of report. TRUE
    13. A report once created cannot be edited. FALSE
    C. Fill in the blanks
    1. A form can be used for enter and view data.
    2. Each field control consists of a label and field value.
    3. A label is a piece of text that specifies the data that should be entered in the field value text box.
    4. By default the border of the field text value is displayed in 3D.
    5. A tool tip is a small piece of text that is displayed when the mouse pointer is placed on a particular
    control on the form.
    6. The default orientation option for a report is landscape.
    7. A layout is the manner in which the labels, field values, titles etc. will be displayed in the report.
    8. The option to insert date and time in the report is present in insert menu.
    9. A Report Wizard contains six steps.
    10. A dynamic type of report changes automatically as the field values in the base table or query change.

    D. Answer the following questions


    1. Give one difference between a form and a report.
    Answer-
    FORM REPORT
    Form is the user-friendly data entry screen that The report helps to present the retrieved data in a
    allows to enter the data in the table easily by any user friendly, understandable and formatted
    user. manner.

    2. What is a field control with respect to forms?


    Answer- A form contains field controls arranged in a presentable and user-friendly manner. Each field
    control consists of a label and the field value text box.
    A label is a piece of text that specifies the data that should be entered in the field value text box.
    A field value text box is linked to the respective field in the table.

    3. Which tool on the Forms Record toolbar is used to insert text on the form?
    Answer- Text Box tool is used to insert text on the form.

    4. Name the two ways to create a form in LibreOffice Base.


    Answer- There are two ways to create a form
    • Using a Wizard
    • Using the Design View

    5. What is the difference between a static and a dynamic report?


    Answer-
    STATIC REPORT DYNAMIC REPORT
    Static Reports are the fixed snapshot of data at a Dynamic Report Updates automatically based on
    specific time. database changes.
    In Static Report, as the field values in the base In dynamic report, as the field values in the base
    table or query changes, the report will not change table or query changes, the report will also change
    automatically. automatically.
    It contains pre-defined set of data. It reflects current state of the database.
    It requires manual re-running or editing It gets updated automatically based on user
    interaction.
    This is not the default type of report. This is the default type of report.
    6. Write the function of Forms Controls toolbar and Records toolbar.
    Answer- Forms Control Toolbar:
    This toolbar contains various controls that can be added to the form.
    E.g. Adding a calendar to a date field, adding text to the form, adding a new record using a form.

    Records Toolbar:
    The Records toolbar contains the navigation control buttons in the extreme left. With the help of these
    buttons, we can traverse and view the records in the file. AS we move from one record to another, the
    record number in the record text boxes changes.

    You might also like