12th class (Fsc) computer unit 7 MCQs
chapter 7 MCQs 12th Class computer
Microsoft Access-Forms and Reports:
1. Forms are designed for:
a. Accepting change
b. Input data
c. All of them
d. Manipulate data
2. How many are basic layouts of forms in Microsoft access?
a. 4
b. 2
c. 5
d. 3
3. The forms are the ……… end of our database in Microsoft access.
a. Back
b. Front
c. Both A & B
d. None of these
4. A ……… auto form displays one record at a time.
a. Datasheet
b. Tabular
c. Justified
d. Columnar
5. ……… auto form displays one record at a time.
a. Datasheet
b. Columnar
c. Justified
d. Tabular
6. The forms are designed to:
a. Analysis
b. Data capturing
c. Managing output result
d. Data manipulation
7. How many form layouts are provided by MS Access?
a. 4
b. 2
c. 5
d. 3
8. A form that contains a sub form is called:
a. Report
b. Form
c. Child form
d. Main form
9. What is the function of a form in MS Access?
a. Change existing data
b. View one record at a time
c. Add new data
d. All
10. Which view can be used to enter or modify data in the underlying table?
a. Form design view
b. Form view
c. New form view
d. Table design view
11. Which of the following is used to create and modify a form?
a. Form design view
b. Form view
c. New form view
d. Table design view
12. All of the following are form layouts except?
a. Justified
b. Tabular
c. Relationship
d. Columnar
13. When displaying a sub-form within a main form which form is based on the primary table?
a. The main form
b. Neither main form nor sub form
c. Both the main-form and the sub-form
d. The sub-form
14. Which of the following option is used for editing forms in MS Access?
a. Resizing objects
b. Grid lines
c. Snap to grid
d. All
15. Which of the following is used to display a list of items in forms?
a. List box
b. Combo box
c. Both A & B
d. Neither A nor B
16. Which of the following is used to display yes/no values?
a. Checkbox
b. Option buttons
c. Both A & B
d. None
17. A form that contains the sub form is called:
a. Report
b. Form
c. None of them
d. Main form
18. A form within another form is called:
a. Multi-form
b. Sub-form
c. Main form
d. None
19. A sub form can be created using:
a. Sub form wizard
b. The form wizard
c. Drag and drop method
d. All of these
20. Which of the following is a one-to-many relation?
a. Person-Date of birth
b. Student-Reg no.
c. Country- Capital
d. Mother- Daughter
21. You can drag the ……… bar to move the property sheet window around on your screen.
a. Scroll bar
b. Title bar
c. All of them
d. Status bar
22. A report provides a column for each field of the records in rows under the column header is known as:
a. Datasheet
b. Tabular
c. Justified
d. Columnar
23. ……… can be previewed on the screen before printing.
a. Sub form
b. Report
c. Form
d. None of them
24. Which of the following is used to retrieve data from one or more tables of database and to present it to the user in a formatted way?
a. Query
b. Report
c. Table
d. Form
25. How many are the layout of report?
a. 4
b. 2
c. 5
d. 3
26. A report may be based on:
a. Form
b. Table
c. Attributes
d. Relationship
27. How many reports layouts are?
a. 4
b. 2
c. 5
d. 3
28. Which of the following is used to retrieve data from database and represent it to the user in a formatted way?
a. Table
b. Form
c. Report
d. Query
29. A report may be based on:
a. Both a table and a query
b. A table but not a query
c. A query but not a table
d. None of these
30. Which of the following is not a function of report?
a. Output of database application
b. Display data
c. Print data
d. Edit data
31. A single report can display data from:
a. One table
b. Many tables
c. Both A & B
d. None of these
32. Which type of report lists every field for every record in a single column?
a. Columnar reports
b. Tabular report
c. All of these
d. Summary report
Click here to go directly on chapter no.8