Which help to retrive the filtered data based on specific
Answers
Answer:To filter data to include data based on a "contains specific text" logic, you can use the FILTER function with help from the ISNUMBER function and SEARCH function. In the example shown, the formula in F5 is: = FILTER(B5:D14,ISNUMBER(SEARCH("rd", B5:B14)),"No results") W
Explanation:Query helps us to retrieve the filter data upon some specified conditions.
Queries, tables, forms and reports are basically objects used in Microsoft Access.
Tables helps us to arrange arrange the data in columns and rows.
The queries help us to retrieve data from the tables based on some specified conditions.
The forms help us to enter the data in the tables or the queries easily. It is basically a user friendly interface.
The report is a object which help to represent data in a printable form which can be printed.
There a different types of queries such as crosstab query, SQL query, action query, parameter query, etc.
All the different types of queries have different functions.