Robert, a manager, uses Microsoft Access 2016 to retrieve employee details. He types <>50000 in the Criteria box in the Salary column in the design grid and runs the query. The results for the query include all the records _____.?

A. ?with values less than 50,000 in the Salary field
B. ?except the ones with 50,000 in the Salary field
C. ?with 50,000 in the Salary field
D. ?except the ones with values greater than 50,000 in the Salary field


Answer: B

Computer Science & Information Technology

You might also like to view...

Which of the following code fragments gives a random double value between 2 and 5 inclusive? You can assume that the random number seed has been set and any needed definitions and initializations have been made.

a) ``` 3.0*rand() + 2 ``` b) ``` 3.0*(RAND_MAX-rand())/RAND_MAX + 2 ``` c) ``` ((RAND_MAX-rand())/static_cast(RAND_MAX))*3 + 2``` d) ``` (RAND_MAX-rand())/static_cast(RAND_MAX)*5 -2 ``` e) ``` rand()/static_cast(RAND_MAX)*2 + 3 ```

Computer Science & Information Technology

What symbols are used in Publisher to indicate where a merge field has been entered?

A) Double angle brackets - <<>> B) Single angle brackets - <> C) Single straight brackets - [] D) Double straight brackets - [[]]

Computer Science & Information Technology

The term "_____" generally refers to systems that divide processing between one or more networked clients and a central server.

A. fat client B. glueware C. client/server D. mission-critical

Computer Science & Information Technology

What does the format command do?

What will be an ideal response?

Computer Science & Information Technology