How To Create Query With Query Wizard In Access 2016?
Have you tried to mix up information from multiple tables in your database? Well Microsoft access 2016 offers a powerful query function with an easy to learn interface that makes it a snap to extract exactly the information you want from your database well this tutorial will help you in exploring the creation of simple query.
Steps To Create Query With Query Wizard In Access 2016
1.Go to the Create tab in the ribbon and click to the Query Design option here.
2.Select all the tables that you want in the query and then click Add to add it to the query.
After adding all the tables, click Close to close the dialog box.
So now you are in design view. The top pane is the Diagram Pane which contains the table that you have previously selected. These are the tables that are used for the query.
In the bottom pane, fields are kept that you will actually use in the query. As well as filtering criteria that we specify.
Make a double tap from a table in the top pane to make it appear in the bottom pane too. Repeat the same for each field that you would like to and in the query.
By default the show option is checked. This indicates that the field will be displayed when the query runs.
You can now run the query if you wanted. However mostly you probably want to add some filtering criteria to the query.
4. Enter Criteria
After adding the fields to include in the query, we can add certain against those fields.
To specify a sort order, click in the sort row for the fields you wants to sort by and do it in ascending or descending order.
Apply filtering criteria against a field add that criteria into criteria row for that field.
You can un-check the show option to apply criteria against a field that is not actually displayed in the results.
5.Click Run in the Ribbon to run the query.
You can also run the query simply by switching to datasheet view using the view button on the ribbon or the datasheet view icon present in the bottom right corner of access.
6. The query will display the results in datasheet view. The entire field that have checked show option are been displayed.
Save The Query
To run the query again later on you need to save it first.
Saving a query is like saving any other database object.
1.Make a right click over the query tab and select save from the contextual menu.
2.Assign a name for the query and click ok.
3.Query is now added to the left navigation pane, under a queries heading.
After saving you can go back and modify the query at any time by right clicking in the navigation pane and selecting design view.