Question

what are the different ways of adding fields in a query design grid in window 10​

Answer 1

Answer:

For each field, perform these two steps: Under Tables/Queries, click the table or query that contains the field. Under Available Fields, double-click the field to add it to the Selected Fields list. If you want to add all fields to your query, click the button with the double right arrows (>>).

Answer 2

Answer: select the fields to be included in the query using one of the following ways:

1) Double-click on the field. it will be placed in the next available column in the Query Design Grid.

2) Click on the field and drag it to the required column in the grid.

3) Double-click the asterisk (*) to include all the fields of the table.

4) Type the field name directly in the required column of the grid.

Explanation: By using this method you can add the fields on the Query Wizard.