Question

Difference between filter and query in ms access

Answer 1

A filter can be used to display all the data of a single table based on a specified condition. Altering the data displayed changes the original data of the table. A query can be used to display selected data from one or more tables based on a specified condition or no condition at all.