S
Sandy
I am currently studying for ECDL Advanced Access and am at present doing
some mock tests.
One of the questions within a test is as follows:-
"Open the query 'Within funding area'. This query shows all the students who
are eligible for free courses however three of the students have now left
the the area and are no longer eligible. You should apply criteria to the
'ID' field so that the query no longer shows records '116', '289' and
'343'."
Naturally being a mock test there is an answer sheet which gives two options
as correct-
1. '<>116 And <>289 And <>343' (- this option works).
2. '<>118 Or 289 Or 343' (- which does not work).
My question is:- Is there a second option or have the "mock" examiners just
got it wrong?
Thanks
Sandy
some mock tests.
One of the questions within a test is as follows:-
"Open the query 'Within funding area'. This query shows all the students who
are eligible for free courses however three of the students have now left
the the area and are no longer eligible. You should apply criteria to the
'ID' field so that the query no longer shows records '116', '289' and
'343'."
Naturally being a mock test there is an answer sheet which gives two options
as correct-
1. '<>116 And <>289 And <>343' (- this option works).
2. '<>118 Or 289 Or 343' (- which does not work).
My question is:- Is there a second option or have the "mock" examiners just
got it wrong?
Thanks
Sandy
