Question

David is working in a database that organizes student exam grade information. He needs to find all students who have scored 100 on an exam. David can apply a(n) ________ to the data in order to show only records that meet the criteria.

Answer 1

Answer:

David can apply filter to the data in order to show only records that meet the criteria.

Explanation:

• Filter is a very helpful option that displays the records that you want to view, hiding rest of the unwanted records.
• Sometimes you want to extract and view only the records that match a specific criteria instead of viewing all the records.
• For example in the CUSTOMERS table which contains names, addresses, countries of customers. There are several customers from different countries but you only want to view the customers from Spain. So you can use filter feature to view all the customers from country Spain.
• In MS Access you can apply filters using Sort & Filter group in the Home tab by selecting the desired column. In SQL, WHERE clause can be used along with SELECT to for filtering and extracting certain records. SELECT will select the records from the table and WHERE clause will specify the criteria to select the certain records.