When you have finished designing your query, you can run it.
Note If you want to test whether the syntax of the query you are creating is correct, you can verify the query. For details, see Verifying a Query.
To execute a query
If you are creating a Select query, the results of the query appear in the Results pane.
The Query Designer runs queries in batches (incrementally) so that you can begin viewing results as soon as possible, and so that you can perform other tasks while the query is underway.
If you are creating an Update, Insert, Insert Values query, Delete, or Make Table query, the Query Designer displays a message indicating how many rows were affected by the query.
For information on viewing results and navigating in the Results pane, see Results Pane.