Question

How is the difference between 'Filter' and 'Quary' in MS-Access ?

Answer 1

Queries and filters both refine a group of messages into a subset, but queries yield a subset of all the messages in the Microsoft System Center Configuration Manager 2007 site database, while filtering yields a subset of the messages currently displayed in ConfigMgr Status Message Viewer. For example, if there are 1,000 messages in the Configuration Manager 2007 site database, you could define a query that returns 541 of those messages to ConfigMgr Status Message Viewer. You could then filter these messages so that only 17 are displayed.

Answer 2

Filter:A filter can be used to display all the data of single table based on a specified condition. Quary: A quart can be used to display selected data from one or more tables based on specified condition or no condition at all..