FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

WHAT IS DATABASE MANAGEMENT

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
____ contains the condition on the basis of which the records will be filtered in the Query output.
A
Criteria
B
Table
C
Field
D
Advanced Filter
Explanation: 

Detailed explanation-1: -Answer: Explanation: ADO Filter Property.

Detailed explanation-2: -Explanation :-Criteria is the property which contains the condition on which the records are been filtered in the Query output. Explanation :-One criteria or more than that criteria is needed in satisfying/providing the data that we are finding. Such type of criteria is to be termed as compound criterion.

Detailed explanation-3: -ANSWER. On the Home tab, in the Sort & Filter group, click Advanced and then click Advanced Filter/Sort on the shortcut menu. Add the fields on which you want to filter to the grid.

Detailed explanation-4: -Explanation: What is the use of Criteria row in the Query design grid? Criteria row helps to filter the records according to a given criteria.

There is 1 question to complete.