You can go back and forth between Datasheet view and Design view to modify your query. Saving the Query Saving a query Modifying the Query The Query Results The query results are displayed in Datasheet view.
![how to create a microsoft access database how to create a microsoft access database](https://dev.mysql.com/doc/connector-odbc/en/images/external-data-odbc.png)
Clicking the Datasheet view button next to it will also run the query. The Run Button Clicking the Run button will run the query. You can choose which tables are shown in the results, which fields to use, add filtering criteria, and more. Query Design View Query Design View allows you to specify the precise criteria for the query. You can also include other queries to use within a query. Tables to Include in the Query The Show Table dialog allows you to choose which tables to include in the query. You could also use the Query Wizard button next to it to launch the Query Wizard, however, Design view gives you more control over the query. The Query Design Button Click the Query Design button to create a query in Design view. click Save, and name it at the prompt.īelow are screenshots showing the above steps. You also have the option of saving your query. To save the query, right-click on the query tab. The results of the query will be displayed. Click the Run button (or just switch to Datasheet view).Choose the fields to include, and adjust the criteria.Choose the tables to include in the query.Click the CREATE > Query Design button on the Ribbon.To create a query in Access 2013 or 2016: