Question: what is the difference between creating a query and using a filter?
Answer: A filter can be used to display all the data of a single table based on a specified condition. ... A query can be used to display selected data from one or more tables based on a specified condition or no condition at all. The result of the query can be saved for later use.