Well-structured Std 11 Computer Textbook MCQ Answers and Std 11 Computer MCQ Answers Ch 12 Forms and Reports can serve as a valuable review tool before computer exams.
GSEB Std 11 Computer Chapter 12 MCQ Forms and Reports
Question 1.
To perform operations on the table by using …………….. .
(A) Table Datasheet view
(B) Table Wizard view
(C) Table Database view
(D) All of these
Answer:
(A) Table Datasheet view
Question 2.
To perform operations on the table to view information by using ………………… .
(A) Query Database View
(B) Query Wizard View
(C) Query Datasheet View
(D) All of these
Answer:
(C) Query Datasheet View
Question 3.
The datasheet views in the form of row and columns are called.
(A) row
(B) column
(C) cell
(D) table
Answer:
(D) table
Question 4.
In base using spreadsheet style it is called ……………… .
(A) Black and Gray / Style
(B) Black and White / Style
(C) Black and Green / Style
(D) Black and Red / Style
Answer:
(B) Black and White / Style
Question 5.
Small names for defining fields are not ……………..
(A) self explanatory
(B) self readable small
(C) self visual
(D) all of these
Answer:
(A) self explanatory
Question 6.
To enter data in database known as ……………… .
(A) Report
(B) Form
(C) Query
(D) Macro
Answer:
(B) Form
Question 7.
To show data in a decissive role which one is used in Base ?
(A) Report
(B) Form
(C) Query
(D) Macro
Answer:
(A) Report
Question 8.
To display output in the formatted manner using ……………….. .
(A) table
(B) form
(C) report
(D) query
Answer:
(C) report
Question 9.
……………….. objects displayed in left pane of the database window.
(A) Table, Queries
(B) Forms, Reports
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 10.
Base also offers similar alternatives to view and work with data in the tables its known as ……………….. .
(A) table
(B) form
(C) report
(D) query
Answer:
(B) form
Question 11.
Form resembles the ……………… .
(A) paper and pen
(B) chalk and duster
(C) pen and pencil
(D) white board and marker
Answer:
(A) paper and pen
Question 12.
……………. is front end for data entry and editing.
(A) Table
(B) Form
(C) Report
(D) Query
Answer:
(B) Form
Question 13.
Forms can be designed using ………………… .
(A) process
(B) color
(C) name and logo
(D) all of these
Answer:
(D) all of these
Question 14.
For which purpose forms are created ?
(A) To display output of query
(B) To display information
(C) To entering information
(D) To prepare table
Answer:
(C) To entering information
Question 15.
By what main purpose the report is to be prepared ?
(A) To create table
(B) To present information through professional
(C) Use of record for statistical information
(D) Enter the details
Answer:
(B) To present information through professional
Question 16.
Form can be design by ………………. option.
(A) Table, Query
(B) Table, Report
(C) Query, Report
(D) Query, Macro
Answer:
(A) Table, Query
Question 17.
How many types are available to create a form ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 18.
Which option is use to create a form ?
(A) Using Wizard
(B) Using Design View
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 19.
Which type is easy to create a form ?
(A) Wizard
(B) Design View
(C) Both (A) and (B)
(D) None of these
Answer:
(A) Wizard
Question 20.
There are ………………. methods to start form wizard.
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 21.
Which option is display a type of starting form wizard ?
(A) Right click on table and open Design view
(B) Click on Form Icon and open Design view
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 22.
What is use to create a data entry form for form wizard ?
(A) Table
(B) Query
(C) Report
(D) Both (A) and (B)
Answer:
(D) Both (A) and (B)
Question 23.
Click on forms icon and choose use wizard to create a form option from ……………….. .
(A) window
(B) tasks
(C) database
(D) datasheet
Answer:
(B) tasks
Question 24.
Click on forms icon tasks pen, how many options is available ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 25.
Which option you can see click on form icon ?
(A) Create Form in Design view
(B) User Wizard to create Form
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 26.
Click using wizard to create a form right click on table name which option is used ?
(A) Form Sheet
(B) Form Wizard
(C) Form View
(D) Form Database
Answer:
(B) Form Wizard
Question 27.
Right click on table, the form wizard will open ………………. dialog box.
(A) 1
(B) 2
(C) 3
(D) 4
Answer:
(B) 2
Question 28.
How many steps are available to create form using form wizard ?
(A) 5
(B) 6
(C) 7
(D) 8
Answer:
(D) 8
Question 29.
Which is the first step of form wizard ?
(A) Get Joined Field
(B) Field Selection
(C) Add Subform Field
(D) Set up a Subform
Answer:
(B) Field Selection
Question 30.
To create a form for choose field, which step you can use ?
(A) First
(B) Second
(C) Third
(D) Fourth
Answer:
(A) First
Question 31.
All the fields of the table are listed under …………….. of form wizard dialog box.
(A) available field
(B) fields in the form
(C) existing field
(D) database fields
Answer:
(A) available field
Question 32.
To move all available fields to the …………….. .
(A) available fields
(B) fields in the form
(C) existing field
(D) database field
Answer:
(B) fields in the form
Question 33.
……………… symbol is used to move all available fields to the fields in the form list.
Answer:
Question 34.
To go next step of form wizard. Click on …………….. button.
(A) Then
(B) After
(C) Next
(D) Past
Answer:
(C) Next
Question 35.
Which is the second step of form wizard ?
(A) Get joined fields
(B) Field selection
(C) Add subform fields
(D) Set up a subform
Answer:
(D) Set up a subform
Question 36.
Which step is used for setting up a subform ?
(A) First
(B) Second
(C) Third
(D) Fourth
Answer:
(B) Second
Question 37.
Which is the third step of form wizard ?
(A) Get joined fields
(B) Fields selection
(C) Add subform fields
(D) Set up a subform
Answer:
(C) Add subform fields
Question 38.
Which step is used for arrangement of sub form ?
(A) First
(B) Second
(C) Third
(D) Fourth
Answer:
(C) Third
Question 39.
Which is the fourth step of form wizard ?
(A) Get joined fields
(B) Fields selection
(C) Add subform fields
(D) Set up a subform
Answer:
(A) Get joined fields
Question 40.
To join the field. Which step is used ?
(A) First
(B) Second
(C) Third
(D) Fourth
Answer:
(D) Fourth
Question 41.
Which is the fifth step of form wizard ?
(A) Set name
(B) Apply style
(C) Arrange controls
(D) Set data entry
Answer:
(C) Arrange controls
Question 42.
……………. step consists of aligning various controls on the form.
(A) Fifth
(B) Sixth
(C) Seventh
(D) Eighth
Answer:
(A) Fifth
Question 43.
Form control consist of ………………. parts.
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 44.
Form control consist of ………………. .
(A) label
(B) field
(C) both (A) and (B)
(D) none of these
Answer:
(C) both (A) and (B)
Question 45.
……………… step when performed determines, how the table and Field will be visible on the screen.
(A) Set name
(B) Arrange controls
(C) Apply style
(D) Set data entry
Answer:
(B) Arrange controls
Question 46.
Form labels can be aligned on the ……………… .
(A) left side
(B) right side
(C) both (A) and (B)
(D) none of these
Answer:
(C) both (A) and (B)
Question 47.
The field corresponding to a label can be arranged in ………………… ways.
(A) 3
(B) 4
(C) 5
(D) 6
Answer:
(B) 4
Question 48.
In form corresponding to a label can be arranged ……………. .
(A) Columnar-Labels Left Columnar-Labels on Top
(B) As Datasheet
(C) In Blocks-Labels Above
(D) All of these
Answer:
(D) All of these
Question 49.
Which is the sixth step of form wizard ?
(A) Set name
(B) Apply style
(C) Arrange controls
(D) Set data entry
Answer:
(D) Set data entry
Question 50.
Which step is used for data entries to be checked ?
(A) Fifth
(B) Sixth
(C) Seventh
(D) Eighth
Answer:
(B) Sixth
Question 51.
Which is the seventh step of form wizard ?
(A) Set name
(B) Apply styles
(C) Arrange controls
(D) Set data entry
Answer:
(B) Apply styles
Question 52.
Which step is used for experiment with different possible settings ?
(A) Fifth
(B) Sixth
(C) Seventh
(D) Eighth
Answer:
(C) Seventh
Question 53.
How many colors are available in form wizard style ?
(A) 7
(B) 8
(C) 9
(D) 10
Answer:
(D) 10
Question 54.
In form wizard, how many options are available in field border ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(B) 3
Question 55.
Which option are seen in form wizard by field border ?
(A) No border
(B) 3D look
(C) Flat
(D) All of these
Answer:
(D) All of these
Question 56.
Which is the eighth step of form wizard ?
(A) Set name
(B) Apply style
(C) Arrange controls
(D) Set data entry
Answer:
(A) Set name
Question 57.
To give a name to a form which option is used ?
(A) Fifth
(B) Sixth
(C) Seventh
(D) Eighth
Answer:
(D) Eighth
Question 58.
Last step of form wizard give permission by how many types to open a form ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 59.
Last step of form wizard gives ……………… types of facility to open a form.
(A) work with the form
(B) modify the form
(C) both (A) and (B)
(D) none of these
Answer:
(C) both (A) and (B)
Question 60.
Last step of form wizard gives facility like …………… to open a form.
(A) view
(B) edit
(C) zoom
(D) all of these
Answer:
(B) edit
Question 61.
Which type of modification you can do in form ?
(A) Moving control on form
(B) Change background of Form control
(C) Change any field of label
(D) All of these
Answer:
(D) All of these
Question 62.
Which option is used to select the label ?
(A) Alt + Click
(B) Tab + Click
(C) Ctrl + Click
(D) Shift + Click
Answer:
(C) Ctrl + Click
Question 63.
In the following option which option is used for label field control ?
(A) Height, Width
(B) Font, Alignment
(C) Visibility of a control, Name
(D) All of these
Answer:
(D) All of these
Question 64.
The controls in the main form consist of …………….. parts.
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 65.
Which option displays a controls in the main form ?
(A) Label
(B) Field
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 66.
Clicking a ……………… selects the entire control.
(A) label
(B) field
(C) both (A) and (B)
(D) none of these
Answer:
(C) both (A) and (B)
Question 67.
A border appears around the control with eight ………………. handles.
(A) Red
(B) Green
(C) Sky
(D) Black
Answer:
(B) Green
Question 68.
A border appears around the control with ………………. green handles.
(A) 4
(B) 6
(C) 8
(D) 10
Answer:
(C) 8
Question 69.
To choose either a label or a text field press ……………… key.
(A) Ctrl
(B) Alt
(C) Shift
(D) Tab
Answer:
(A) Ctrl
Question 70.
To increase the width of form which green handle is used.
(A) Upper green handle of right side
(B) Upper green handle of left side
(C) Between green handle of right side
(D) Between green handle of left side
Answer:
(C) Between green handle of right side
Question 71.
Move the cursor over the middle of green handle on the right side it should be changed in a ……………… sign.
(A) hand
(B) arrow
(C) line
(D) text
Answer:
(B) arrow
Question 72.
If you can see the changing size at button on the screen double click on ………………. .
(A) position and size
(B) place and size
(C) position and range
(D) place and amount
Answer:
(A) position and size
Question 73.
How many options are available in position and size dialog box ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 74.
Which option is available for size in position and size dialog box ?
(A) Width, Size
(B) Width, Height
(C) Width, Alignment
(D) Width, Arrange
Answer:
(B) Width, Height
Question 75.
You ever rested a mouse pointers for a while on buttons in toolbar. What you can see ?
(A) Tooltip
(B) Toolpin
(C) Toolline
(D) Tooltext
Answer:
(A) Tooltip
Question 76.
Tool tip means ?
(A) Important word
(B) Mainform words
(C) Exchange word
(D) Helping words
Answer:
(D) Helping words
Question 77.
You can see tool tip in which color box ?
(A) Red
(B) Green
(C) Yellow
(D) Sky blue
Answer:
(C) Yellow
Question 78.
What is shown in tool tip ?
(A) The origin of tool
(B) The discriptive of tool
(C) The visibility of tool
(D) One-two words about the intension of tool
Answer:
(D) One-two words about the intension of tool
Question 79.
Controls placed on data entry ……………… in base can be tagged with help text.
(A) Table
(B) Form
(C) Report
(D) Control field on form
Answer:
(D) Control field on form
Question 80.
Text box to select the control right click the control and choose …………….. option.
(A) Element
(B) Control
(C) Properties
(D) Fields
Answer:
(B) Control
Question 81.
To attach a tool tip the text box control associated with label. Which option has selected in properties dialog box ?
(A) Help text
(B) User text
(C) Tool text
(D) Assistant text
Answer:
(A) Help text
Question 82.
Which dialog box is open when right click on text field and choose control option in form ?
(A) Control:Text
(B) Properties:Text
(C) Control:Text box
(D) Properties:Text box
Answer:
(D) Properties:Text box
Question 83.
Which attribute is used to change the date field to calendar control ?
(A) Date format
(B) Dropdown
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 84.
In form right click on date field and choose control field which dialog box is open ?
(A) Properties:Date/Time
(B) Control:Date/Time
(C) Properties:Date Field
(D) Control:Date Field
Answer:
(C) Properties:Date Field
Question 85.
To change the date field to calendar field, which attribute is used from date field ?
(A) Date Field
(B) Data format
(C) Date control
(D) Date type
Answer:
(B) Data format
Question 86.
Which list box you can see when click on date format properties of date field ?
(A) Pool-up list box
(B) Text list box
(C) Option list box
(D) Drop down list box
Answer:
(D) Drop down list box
Question 87.
When click on arrow button the list of the options drop down. What we can say to this one ?
(A) Drop down list box
(B) Text list box
(C) Radio button list box
(D) Option list box
Answer:
(A) Drop down list box
Question 88.
In date format drop down list with …………….. as the default setting.
(A) Standard(long)
(B) Standard(short YY)
(C) Standard (short YYYY)
(D) Standard (short)
Answer:
(D) Standard (short)
Question 89.
Scroll down to the drop down properties it is default setting ………………. .
(A) Yes
(B) No
(C) On
(D) Off
Answer:
(B) No
Question 90.
Toolbar known as …………….
(A) form control toolbar
(B) form design toolbar
(C) form view toolbar
(D) form wizard toolbar
Answer:
(A) form control toolbar
Question 91.
Which tool button is used for on/off the design mode ?
Answer:
Question 92.
Which button is used to open properties dialog box of Date field ?
Answer:
Question 93.
On which toolbar you can see Control Icon and Design Mode On/Off Icon ?
(A) Form Control toolbar
(B) Form Design toolbar
(C) Form Tool toolbar
(D) Form View toolbar
Answer:
(A) Form Control toolbar
Question 94.
The background for a form can be a ……………… .
(A) Color
(B) Figure
(C) Drawing
(D) Any one of these
Answer:
(D) Any one of these
Question 95.
To change the back graph …………….. option is used.
(A) Tools → Options
(B) Edit → Options
(C) View → Color
(D) Color → Edit
Answer:
(A) Tools → Options
Question 96.
Which option is used to change the background color of form ?
(A) Tools → options → OpenOffice.org → change → Colors
(B) Tools → options → OpenOffice.org → Edit → Colors
(C) Tools → options → OpenOffice.org → Colors
(D) Tools → options → OpenOffice.org → Background
Answer:
(C) Tools → options → OpenOffice.org → Colors
Question 97.
You can also use a graphic file as the background perform the following steps to change background right click on the blank space in a form which sub menu is open ……………… .
(A) Graphics
(B) Page
(C) Image
(D) Background
Answer:
(B) Page
Question 98.
In page style dialog box, how many option are in As ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 99.
In page style dialog box, which option you can see in As ?
(A) Color
(B) Graphics
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 100.
Toolbar is known as ……………………… .
(A) form control toolbar
(B) form design toolbar
(C) form view toolbar
(D) form wizard toolbar
Answer:
(C) form view toolbar
Question 101.
To see one by one record in form which button is used ?
(A) Form button
(B) Record button
(C) Navigation button
(D) Navigator button
Answer:
(C) Navigation button
Question 102.
How many buttons are in navigation bar ?
(A) 4
(B) 5
(C) 6
(D) 7
Answer:
(B) 5
Question 103.
Navigation button is known as …………….. .
(A) next record
(B) previous record
(C) first record
(D) last record
Answer:
(C) first record
Question 104.
Navigation button is known as ……………. .
(A) next record
(B) previous record
(C) first record
(D) last record
Answer:
(B) previous record
Question 105.
Navigation button is known as ……………… .
(A) next record
(B) previous record
(C) first record
(D) last record
Answer:
(A) next record
Question 106.
Navigation button is known as …………….. .
(A) next record
(B) previous record
(C) first record
(D) last record
Answer:
(D) last record
Question 107.
Navigation button is known as ……………… .
(A) next record
(B) previous record
(C) first record
(D) last record
Answer:
(C) first record
Question 108.
To go on first record, which navigation button is used ?
Answer:
Question 109.
To go on last record, which navigation button is used ?
Answer:
Question 110.
Which navigation button is used to go current record to before record ?
Answer:
Question 111.
Which navigation button is used to go for current record to after record ?
Answer:
Question 112.
Which navigation button is used to go for adding new record ?
Answer:
Question 113.
By opening a form which record is displayed ?
(A) First
(B) Last
(C) New record
(D) Any one of these
Answer:
(A) First
Question 114.
In the form you can view ……………… record at a time.
(A) 1
(B) 2
(C) 3
(D) Many
Answer:
(A) 1
Question 115.
Which option is used to find particular record in form ?
(A) Search Record
(B) Display Record
(C) Find Record
(D) Discover Record
Answer:
(C) Find Record
Question 116.
Which option displays Find Record Icon ?
Answer:
Question 117.
Which dialog box open, when click on find record icon ?
(A) Record Find
(B) Find Record
(C) Record Search
(D) Search Record
Answer:
(C) Record Search
Question 118.
Which Navigation button is used to add new record in form ?
Answer:
Question 119.
You can also ……………….. through a form using the Delete Record button on the form view toolbar.
(A) remove record
(B) erase record
(C) delete record
(D) cancel record
Answer:
(C) delete record
Question 120.
…………….. button is used to remove the unwished record from form.
Answer:
Question 121.
At times user might want to find specific record which option is used ?
(A) Wizard view
(B) Design view
(C) Form control
(D) Form view
Answer:
(D) Form view
Question 122.
Clicking on delete record button will delete record and …………….. record will be display.
(A) before
(B) after
(C) first
(D) last
Answer:
(B) after
Question 123.
To search any information in base, you can use ……………. .
(A) table
(B) form
(C) report
(D) query
Answer:
(D) query
Question 124.
A record can be deleted through a form using the …………….. button.
(A) box
(B) cell
(C) document
(D) report
Answer:
(A) box
Question 125.
The result displayed by query is not ……………….. .
(A) accurate
(B) organized
(C) both (A) and (B)
(D) none of these
Answer:
(C) both (A) and (B)
Question 126.
………………. provides a way to present the information retrieved in an attractive, arranged and decisive manner.
(A) Form
(B) Report
(C) Query
(D) All of these
Answer:
(B) Report
Question 127.
Report displays information in which form ?
(A) Attractive
(B) Arranged
(C) Decisive
(D) All of these
Answer:
(D) All of these
Question 128.
One of the purposes of generating a report is ……………….. .
(A) To make a hard copy of output
(B) To make a displayed copy of output
(C) To entering information
(D) To editing information
Answer:
(A) To make a hard copy of output
Question 129.
The output on printed paper is called …………….. .
(A) soft copy
(B) hard copy
(C) software copy
(D) hardware copy
Answer:
(B) hard copy
Question 130.
One of the purposes of generating a report is to make ……………. output.
(A) soft copy
(B) hard copy
(C) software copy
(D) hardware copy
Answer:
(A) soft copy
Question 131.
The layout of report is generally designed by keeping in mind the look of the …………….. .
(A) hard copy require
(B) report view
(C) both (A) and (B)
(D) none of these
Answer:
(C) both (A) and (B)
Question 132.
You can create report, by report wizard at a time …………….. .
(A) 1
(B) 2
(C) 3
(D) 4
Answer:
(A) 1
Question 133.
You can create report based on ……………. .
(A) table, form
(B) table, query
(C) form, query
(D) form, macro
Answer:
(B) table, query
Question 134.
If you want to use fields from different tables, it is advised that you to create a ………………. .
(A) table
(B) form
(C) query
(D) macro
Answer:
(C) query
Question 135.
Which option you will use for Report Wizard ?
(A) Right click on table and select report wizard
(B) Left click on table and select report wizard
(C) Right click on reports ICON in database window and select report wizard
(D) Left click on report ICON in database window and select report wizard
Answer:
(A) Right click on table and select report wizard
Question 136.
How many option you can see at right side while you click on reports icon in database window ?
(A) 1
(B) 2
(C) 3
(D) 4
Answer:
(A) 1
Question 137.
Which option you can see at right side while you click on report icon in database window ?
(A) Use design view to create report
(B) Use wizard to create report
(C) Both (A) and (B)
(D) None of these
Answer:
(B) Use wizard to create report
Question 138.
How many dialog box you can see while you select report wizard ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 139.
How many steps are available to create a report by report wizard ?
(A) 5
(B) 6
(C) 7
(D) 8
Answer:
(B) 6
Question 140.
Which is the first step of report wizard ?
(A) Sort option
(B) Grouping
(C) Field selection
(D) Labeling fields
Answer:
(C) Field selection
Question 141.
Which step is used for selecting a field in report wizard ?
(A) First
(B) Second
(C) Third
(D) Fourth
Answer:
(A) First
Question 142.
Report can be created in this chapter are based on ………………… .
(A) table
(B) query
(C) (A) or (B)
(D) none of these
Answer:
(C) (A) or (B)
Question 143.
To create a report field selection step all fields of table is seen in ……………. .
(A) available field
(B) fields in report
(C) table fields
(D) all fields
Answer:
(A) available field
Question 144.
When you select a field to create a report it is in ……………… .
(A) available fields
(B) fields in report
(C) table fields
(D) all fields
Answer:
(B) fields in report
Question 145.
To select field one by one in field Selection which button is used ?
Answer:
Question 146.
To select all the fields in Field Selection which button is used ?
Answer:
Question 147.
To go next step of create a report, click on which button ?
(A) Next
(B) Then
(C) After
(D) Last
Answer:
(A) Next
Question 148.
Which is the second step of report wizard ?
(A) Sort options
(B) Grouping
(C) Field selection
(D) Labeling fields
Answer:
(D) Labeling fields
Question 149.
Which step give label or alias of report wizard ?
(A) 1
(B) 2
(C) 3
(D) 4
Answer:
(B) 2
Question 150.
Which is the third step of report wizard ?
(A) Sort option
(B) Grouping
(C) Field selection
(D) Labeling fields
Answer:
(B) Grouping
Question 151.
……………… step of wizard is grouping the field.
(A) 1
(B) 2
(C) 3
(D) 4
Answer:
(C) 3
Question 152.
Which is the fourth step of report wizard ?
(A) Sort option
(B) Grouping
(C) Field selection
(D) Labeling fields
Answer:
(A) Sort option
Question 153.
……………… step give facility to field for ascending order or descending order.
(A) 1
(B) 2
(C) 3
(D) 4
Answer:
(D) 4
Question 154.
Which is the fifth step of report wizard ?
(A) Sort option
(B) Grouping
(C) Field selection
(D) Labeling
Answer:
(C) Field selection
Question 155.
……………… step of report wizard gives us choice of various layouts.
(A) 3
(B) 4
(C) 5
(D) 6
Answer:
(C) 5
Question 156.
Fifth step of report wizard include ……………. .
(A) color combination
(B) positioning of field
(C) alignment of text
(D) all of these
Answer:
(D) all of these
Question 157.
Which is the sixth step of report wizard ?
(A) Sort option
(B) Grouping
(C) Field selection
(D) Labeling
Answer:
(B) Grouping
Question 158.
In step on ……………… you will be asked to give the title of the report.
(A) 3
(B) 4
(C) 5
(D) 6
Answer:
(D) 6
Question 159.
How many report you can create by last step of report wizard ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 160.
Which type of report you can create by last step of report wizard ?
(A) Static
(B) Dynamic
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 161.
In ………………. report option the data in the output of report will remain same every time.
(A) static
(B) dynamic
(C) both (A) and (B)
(D) none of these
Answer:
(A) static
Question 162.
……………… report option will allow us to see the effect of any changes made in the table.
(A) Static
(B) Dynamic
(C) Both (A) and (B)
(D) None of these
Answer:
(B) Dynamic
Question 163.
Click on ………………. button, you can see report in last step of report wizard.
(A) close
(B) end
(C) finish
(D) stop
Answer:
(C) finish
Question 164.
What you can see in upper part of report ?
(A) Author name
(B) Date
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 165.
The author name and date will depend on the …………………. .
(A) machine name
(B) create report date
(C) open report date
(D) all of these
Answer:
(D) all of these
Question 166.
The data contents will be according to the entry that you have done in the ……………… .
(A) table
(B) query
(C) macro
(D) all of these
Answer:
(A) table
Question 167.
We will create ……………….. so we can create report containing records between any two desired dates.
(A) Select query
(B) Cross tab query
(C) Parameter Query
(D) Update Query
Answer:
(C) Parameter Query
Question 168.
If you create two date based parameter query you have to write condition in ……………….. box.
(A) criterion
(B) sort
(C) control
(D) date
Answer:
(A) criterion
Question 169.
Which condition you will write for creating two date based parameter query ?
(A) BETWEEN date 1 AND date 2
(B) BETWEEN :date AND :date
(C) BETWEEN:date AND:date 2
(D) BETWEEN:date 1 and :date2
Answer:
(C) BETWEEN:date AND:date 2
Question 170.
Arrange the following works while creating report with the help of Report Wizard.
(1) Give proper sub name of field’s name.
(2) Select the proper field.
(3) Select the Report Wizard by right click on table / query.
(4) Select the layout
(5) Sort out with the help of field.
(6) Create the group of fields.
(A) 3, 2, 1, 6, 4, 5
(B) 3, 2, 1, 6, 5, 4
(C) 3, 1, 2, 6, 5, 4
(D) 3, 2, 1, 5, 6, 4
Answer:
(B) 3, 2, 1, 6, 5, 4
Question 171.
After creating report, you can display in which form ?
(A) Hard copy
(B) Soft copy
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 172.
If you want to create a hard copy you will click on which button ?
Answer:
Question 173.
tool button is on which tool bar ?
(A) Database toolbar
(B) Drawing toolbar
(C) Standard toolbar
(D) Formatting toolbar
Answer:
(C) Standard toolbar
Question 174.
If you want to create a soft copy, you will click on which button ?
Answer:
Question 175.
tool button is on which toolbar ?
(A) Database toolbar
(B) Drawing toolbar
(C) Standard toolbar
(D) Formatting toolbar
Answer:
(C) Standard toolbar
Question 176.
What is the full form of PDF ?
(A) Portable Document Format
(B) Portable Document File
(C) Portable Document Folder
(D) Portable Document Form
Answer:
(A) Portable Document Format