create tab
It will be added to the design grid when you double click a field list in Query Design View.
It is known as the design grid.
create tab
you need to in the design grid, in the Sort row, click the Course Names Sort arrow and pick Ascending.
the lower pane in Query Design View
Yes it is.
You can do it in the Design Grid in Design View or you can do it through SQL view if you know how to use SQL.
by using the query wizard or design view
It will depend on the design of your table and your query. If you have done something like brought the table in twice into the design of the query you will get multiple records. There are occasions when you would need to bring in the same table twice, but usually you don't. If you have it in twice it will list records multiple times. Go to the design view of the query and if you see the table there more than once, delete the extra copies of it, so that there is only one. Then design your query and it should be ok.
It enables you to run a query by clicking on the button. You can choose what query to run when you design it.
Run button
Start the new query in design view and add in the table that you want when it asks you. It will now appear in the top part of the window, above the design grid. To bring a field into the design grid, you can do a number of things. You can drag a field down and drop it into the column. You can start to type the field into the column. You can pick it from a drop down list in the column. Simplest of all, you can just double click on the field in the field list and it will be put into the design grid.