Executing a Query
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
- Right-click anywhere in the query window, and select Run from the shortcut menu.
If you are creating a
The Query Designer returns results to your computer 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. For more information, see Interaction Between the Results Pane and the Database.
If you are creating an Update, Insert From, Insert Into, 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.
See Also
Clearing Query Results | Editing Rows in the Results Pane | Verifying a Query