helps to create a query in design view
Answers
I don't understand your question!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!?
Explanation:
Here's how to create a simple select query using
Query Design.
Screenshot of the Query Design button highlighted.
Launch Query Design View
Click Query Design from the Create tab in the Ribbon.
Screenshot of selecting the tables.
Select the Tables
Select each table that you need in the query and click Add to add it to the query.
Once you've added all the tables you need, click Close to close the dialog box.
In this example, I add the City table and the Country table.
Screenshot of the query in Design View.
Add Fields
We are now in Design View.
The top pane is the Diagram Pane. It contains the tables that we selected in the previous step. These are the tables that are available for us to use in the query.
The bottom pane is the Query Pane. It contains the fields that we will actually use in the query, as well as any filtering criteria that we specify.
Double-click a field from a table in the top pane to make it appear in the bottom pane. Do this for each field you'd like in the query.
By default, the Show option is checked (in the bottom pane). This indicates that the field will be displayed when the query runs.
You could run the query now if you wanted. However, most of the time, you'll probably want to add some filtering criteria to the query.
Screenshot of the query in Design View with the query criteria. Close up of the query criteria.
Enter Criteria
Now that we've added the fields to include in the query, we can add criteria against those fields.
To specify a sort order, click in the Sort row for the field you'd like to sort by, and choose Ascending or Descending.
To apply filtering criteria against a field, add that criteria into the Criteria row for that field.
In this example, the query will return all cities where the population is greater than or equal to 7 million. It will also sort it by population in descending order.
You can also uncheck the Show option to apply criteria against a field that isn't actually displayed in the results.
For example, we could modify our query so that the population is not displayed in the results, even though it is used as a filtering criteria.
Screenshot of the result.
Run the Query
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 in the bottom right corner of Access.
Screenshot of the result.
The Result
The query displays the results in Datasheet View.
All fields that have had Show checked are displayed.
All criteria is also applied. In our example, only cities with a population of at least 7 million are displayed. Also, all three fields are displayed, sorted by population in descending order.
hope the answer is helpful
kindly mark me as a brainliest...