1) Equals a) * b) NOT c) >= d) = 2) Greater than a) Between <expr1> and <expr2> b) YES/NO (on YES/NO fields) c) = d) > 3) Less than a) >= b) Between <expr1> and <expr2> c) < d) = 4) Greater than or equal to a) = b) * c) > d) >= 5) To find values between, inclusive a) Between <expr1> and <expr2> b) LIKE c) < d) >= 6) To match any number of characters a) * b) Between <expr1> and <expr2> c) = d) < 7) To find data when there are several possible spellings a) Between <expr1> and <expr2> b) >= c) LIKE d) = 8) To exclude records a) YES/NO (on YES/NO fields) b) * c) > d) NOT 9) To find Yes or No fields a) < b) YES/NO (on YES/NO fields) c) = d) Between <expr1> and <expr2> 10) Before 01/05/2015 a) <=05/01/15 b) <01/05/2015 c) <01/MAY/2015 11) Paid less than £50 deposit a) <=50 b) <£50 c) <50 12) When inserting a new filed for Telephone No, the data type is.. a) Currency b) Short Text c) Number 13) Over £700 means in the criteria box we write... a) >£700 b) >=£700 c) >=700

Query Criteria Summary

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?