DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Criteria
|
|
Table
|
|
Field
|
|
Advanced Filter
|
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.