What is the difference between using AND and OR as logical operators in a query?

What will be an ideal response?


Both AND and OR are used when you have multiple criteria in your query. AND returns records that meet both or all criteria. OR returns records that meet one or more of the criteria specified. AND criteria are on the same row of the query design grid. OR criteria are on different criteria rows.

Computer Science & Information Technology

You might also like to view...

You cannot open multiple documents in an Office program.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

The progression of input, processing, output, and storage is known as the _____.

A. ?secure storage cycle B. ?information processing cycle C. ?input transfer cycle D. ?output transmission cycle

Computer Science & Information Technology

The LED lights on a NIC can indicate all the following except _________ .

a. link b. activity c. speed d. crosstalk

Computer Science & Information Technology

Mike installed a new external DVD drive. The installation program required a reboot. As the system rebooted, Mike got a Blue Screen of Death error before Windows fully rebooted. He shut off the system and disconnected the external DVD drive. What should he try next?

a. Safe Mode b. Last Known Good Configuration c. Recovery Console d. Repair Install

Computer Science & Information Technology