What is the difference among using a filter and a query to find records?
Filter is used to quickly limit the records as we are already viewing in a Datasheet or a form to those that match the criteria that we specify. In contrast to this, Query is used to view selected fields and records from one or more tables, then save the query to open it later or use it as the basis of a form or a report.