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.
You might also like to view...
An item stored in a memory location can be a number, text or a Boolean value.
Answer the following statement true (T) or false (F)
A technician has connected a USB printer to a workstation and shared the printer on the local workstation for other users on the network to utilize. The technician successfully printed a test print from the printer’s console and the workstation that the printer is physically connected to. After leaving the customer’s site, the technician received a call from the customer stating no one other than the local user can print to the printer. Each time they attempt to print, they receive an “Access Denied” message. Which of the following is the most likely reason the other users cannot print?
A. The printer is malfunctioning and requires service. B. The USB cable is defective and needs to be replaced. C. The other users lack sufficient permissions for the shared printer. D. The other users need to have the print drivers updated for the printer.