Case 18-1
Emily, a professor, uses Microsoft Access 2016 to manage student information. She refines queries to display selected records and enters criteria using operators to filter the records and display required information.
To retrieve the details of all the students except those with the FirstName field value "Andrew," Emily should enter _____ in the Criteria row in the FirstName column in the design grid.
A. ?!={"Andrew"}
B. ?<>"Andrew"
C. ?NOT LIKE = Andrew
D. ?EXCEPT(Andrew)
Answer: B
Computer Science & Information Technology
You might also like to view...
A while loop can be used to code both definite and indefinite loops.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology
All the variables for one individual person are called a(n) ____.
A. data source B. field C. main document D. record
Computer Science & Information Technology
The major advantage of the payback period is that it takes into account the time value of money.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology
Both __________ produce output that is independent of both the plaintext and the ciphertext. This makes them natural candidates for stream ciphers that encrypt plaintext by XOR one full block at a time.
A. CBC and ECB B. OFB and CTR C. ECB and OFB D. CTR and CBC
Computer Science & Information Technology