WORKSHEET-35

COMPUTER SCIENCE (Book-II) Chapter # 7

Worksheet-35 6. There are  types of Form in the

database:
Chapter - 7
A. 3
MS Access Forms and Reports
(complete) B. 4
C. 5
1. Which of the following database object
acts as a user interface for a table? D. 6
A. Report 7. The field labels are listed on top of the
 Form.
B. Query
A. Justified
C. Form
B. Columnar
D. Table
C. Tabular
2.  database object is made for data
D. Datasheet
input.
8. When displaying a sub-form within the
A. Form
main form, which form is based on the
B. Report primary table?
C. Text field A. Neither main form nor sub-form
D. None of the above B. The sub-form

3. The control which is not directly C. The main form

connected to a field of the table is called: D. Both the main form and the sub-form
A. Bound control 9. Which of the following shortcut key is
B. Calculated control used to insert current time?
A. Ctrl + :
C. Unbound control
B. Ctrl + Alt + :
D. None of the above
C. Ctrl + ;
4. The text box is an example of:
D. Ctrl + T
A. Bound control
10. The sub-form is useful to display data
B. Unbound control from:
C. Calculated control A. Report
D. None of the above B. Table
5. Which of the following control is used to C. Query
enter and edit data in a database?
D. Both B & C
A. Text box
B. Label
C. Checkbox
D. None of the above

Your STEP Towards A Brighter Future! 562

COMPUTER SCIENCE (Book-II) Chapter # 7

11. In Form design view, grid lines are 16. What is true about a report?
helpful in:
A. It cannot delete data
A. Entering data in Form
B. It cannot input data
B. Storing Form elements
C. It cannot modify data
C. Aligning Form elements
D. All of the above
D. None of the above
17. Which of the following report is also
12. The reports are capable of displaying called a stacked report?
data in the form of:
A. Tabular report
A. Text
B. Columnar report
B. Chart
C. Justified report
C. Graph
D. None of the above
D. All of the above
18.  is made for data output:
13. __________ is used to execute different A. Tables
commands by clicking on it:
B. Queries
A. Enter key
C. Reports
B. Radio button
D. None of the above
C. Command button
19. Which of the following is used to delete
D. None of the above a record?
14. A report may not include: A. Ctrl + -
A. Exam results B. Backspace key
B. General ledgers C. Ctrl - -

C. Queries D. None of the above

D. Financial statements 20. __________ key is used to display

database window:
15. There are  layouts of the report: A. F5
A. 1 B. F7
B. 2 C. F9
C. 3 D. F11
D. 4

Your STEP Towards A Brighter Future! 563

COMPUTER SCIENCE (Book-II) Chapter # 7

ANSWER KEY (Worksheet-35) 8. (C) Main form is based on a primary table.

1 C 11 C 9. (A) Ctrl +: is used to insert current time.
2 A 12 D 10. (D) Sub-forms are used to display data from
3 C 13 C tables and queries with one - many
4 A 14 C relationship.
5 A 15 C 11. (C) Grid lines are used to align Form elements
6 B 16 D in Form design view.
7 C 17 B
12. (D) Report is the output of a database
8 C 18 C
application. It is used to display data from
9 A 19 A one or more tables in textual, graphical or
10 D 20 D chart form.
ANSWERS EXPLAINED 13. (C) The command button will execute
commands when we click on it.
1. (C) Anything through which data is entered or
accessed from a system is called an 14. (C) A report may include catalogs, general
interface e.g. touch screen of a smartphone ledgers, financial statements and
is used for both inputs and outputs. examination result sheets etc.
Similarly, the Form acts as an interface to 15. (C) In the database there are three layouts of
a table. report i.e.
2. (A) Form is frontend of the database. It is used i) Columnar report
for viewing, entering and retrieving data
from the database. ii) Tabular report
3. (C) The unbounded controls are not directly iii) Justified report
connected to a field. 16. (D) Reports are used to only display data in a
4. (A) A control whose source of data is a field in formatted way.
a table or query is called a bound control. 17. (B) The data in the columnar report is
We use bound controls to display values presented in a long column format so it is
that come from fields in our database. The also called stacked report.
values can be text, dates, numbers, Yes/No
values, pictures, or graphs etc. 18. (C) Report is the output of a database
application. These are used to display data
5. (A) Text box is used to enter or edit data in a from one or more tables in textual form,
database. graphical or chart form.
6. (B) There are four types of Form in the 19. (A) Ctrl + - is used to delete a record from a
database and these are as following: table/ relation.
i) Columnar Form 20. (D) The F11 key is used to display the
ii) Tabular Form database window.
iii) Justified Form
iv) Datasheet Form
7. (C) In tabular form, field labels are listed at the
top.
Your STEP Towards A Brighter Future! 564