Raj, a professor, uses Microsoft Access 2016 to manage student details. He enters 50 in the Criteria row in the PhysicsMarks column and 50 in a different Criteria row in the MathMarks column. In this case, the query datasheet, created by Raj, will most likely include the records for students with a PhysicsMarks field value :
A)equal to 50 and a MathMarks field value equal to 50.
B)not equal to 50 and a MathMarks field value not equal to 50.
C)equal to 50 or a MathMarks field value not equal to 50.
D)not equal to 50 or a MathMarks field value equal to 50.

Question

Raj, a professor, uses Microsoft Access 2016 to manage student details. He enters 50 in the Criteria row in the PhysicsMarks column and 50 in a different Criteria row in the MathMarks column. In this case, the query datasheet, created by Raj, will most likely include the records for students with a PhysicsMarks field value : ​
A)equal to 50 and a MathMarks field value equal to 50.
B)not equal to 50 and a MathMarks field value not equal to 50.
C)equal to 50 or a MathMarks field value not equal to 50.
D)not equal to 50 or a MathMarks field value equal to 50.

Quizplus · Accepted Answer

The Answer of Raj, a professor, uses Microsoft Access 2016 to manage student details. He enters 50 in the Criteria row in the PhysicsMarks column and 50 in a different Criteria row in the MathMarks column. In this case, the query datasheet, created by Raj, will most likely include the records for students with a PhysicsMarks field value : ​
A)equal to 50 and a MathMarks field value equal to 50.
B)not equal to 50 and a MathMarks field value not equal to 50.
C)equal to 50 or a MathMarks field value not equal to 50.
D)not equal to 50 or a MathMarks field value equal to 50.

Raj, a Professor, Uses Microsoft Access 2016 to Manage Student