Question

Section-BD
Chapter
Answer the following
- Name the three views in which a form can be displayed. +
How do you create a form? 56
Explain the design grid of the query window. 3
How do you apply multiple criteria to the same table? Explain with an ea
emputer In Everyday Life (Application Based Questions)
Mrs Sumita is a class teacher of Science (Physics, Chemistry and Biology) in a school
wants to keep track of the performance in Science by her students.
(a) Suggest a table structure (field names, data types) for the above process.
b) Also, state the Criterion for the following:
(i) To display all information of students who got marks above 90 in Physics.
(ii) To display all information of students who got marks above 90 in Physics, Chemisala
and Biology
​

Answer 1

Explanation:

Section-BD

Chapter

Answer the following

- Name the three views in which a form can be displayed. +

How do you create a form? 56

Explain the design grid of the query window. 3

How do you apply multiple criteria to the same table? Explain with an ea

emputer In Everyday Life (Application Based Questions)

Mrs Sumita is a class teacher of Science (Physics, Chemistry and Biology) in a school

wants to keep track of the performance in Science by her students.

(a) Suggest a table structure (field names, data types) for the above process.

b) Also, state the Criterion for the following:

(i) To display all information of students who got marks above 90 in Physics.

(ii) To display all information of students who got marks above 90 in Physics, Chemisala

and Biology