If you want to apply a new query while working in a table, follow these steps:
Select Query from the Format menu to open up the "Format Query" dialog. Note that the table name is already selected in the Based on box. The table name is also grayed out to show that the query you are about to create must be applied to this table, that is you can't choose another table (or relation).
Select the required query components, if there be any, in the Select Query Components box, or use the individual component pages to design new components, as explained in Creating and applying a query.
If you want to use this particular query again, then give it a name in Query Name and click on OK (otherwise leave the name blank).
The query will be applied to the table, but you will remain in Table Grid View. If you gave the query a name, it will appear under Queries in Database Manager. Thereafter it can be used just like any other query; that is to say, if you select it again in future it will open up a Query table based on the original table, without you having to go into the table first.