You find yourself working in an Access table filtering out some unnecessary data and it dawns on you this filtering is something you’ll end up doing frequently. It would make sense to store this process as a query in the database.
Okay, so now I have to switch over to the Create tab and design a new query based on the filter I just applied. Or do I? You can actually save the filter you just applied as a query. The process is simple.
Go to the File tab and choose Save As > Save Object As > Save As.
Once you click the Save As button you will be prompted to name the results as either a query, form, or a report.
It really is that simple. The filter you just ran is now a query and can be used whenever necessary.