the lower pane in Query Design View
Yes it is.
It does not show in the query grid. On the Append To line you can pick the fields in the destination table that you want values to be appended to. The query grid is just for specifying what fields and records you want to be added to the destination table, so it only needs to show the source table.
It is known as the design grid.
Syntax
It will be added to the design grid when you double click a field list in Query Design View.
I am 99% certain it is true.
True
You can use the Max function and the Min function in a query to do it. They are both available when you use the Totals row in the query design grid.
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.
you need to in the design grid, in the Sort row, click the Course Names Sort arrow and pick Ascending.
Square brackets []
It's simply a control which takes some tabular data, and displays it in a grid. It will take it's feed from a datasource, such as a database query, and output it to the browser so that you see one row of the grid, for each record returned from the query. It can also allow for inline editing, sorting and paging of the data it displays - and can do this without any programming at all. Probably one of the most used data display controls used in ASP.Net.