Kay:
I think this is another case of your sample test software using terms
incorrectly. Like the 'divided formula' in your other post the term 'sub
query' is used wrongly here. A subquery is a query within another query and
can be used in the WHERE clause to restrict the result set of the outer query
or in the SELECT clause to return a computed column. That's not what they
are talking about here as far as I can see.
I think that what they are looking for is simply a query based on another
query, Students query 1, but returning only the first four columns from that
query. All you need to do for this is open the query designer in the normal
way, add the Students query 1 to it in the same way as you'd add a table,
then add the first four columns (fields) to the query design grid and open it
in datasheet view.
This seems to be a simple exercise on how to base one query on another. The
resulting query is not a sub query, but just another query.
Having now seen two examples of how badly the questions in your tests are
phrased I think you are not only unlikely to derive any benefit from them,
but more importantly are going to be misled by them due to the incorrect use
of the terminology. If I were you I'd go into Control Panel and uninstall
the test software before it leads you down any more garden paths. You'd get
a lot more benefit from reading a decent general primer on Access such as
John L Viescas's 'Microsoft Office Access Inside Out', and working through
the topics on the CD which accompanies it. Or there are plenty of online
tutorials; Google Access+Tutorial and you should find some to choose from.
Ken Sheridan
Stafford, England
