Question

How does Access treat multiple criteria entered on the same line in query design view

a) AND
b) OR
c) NOT
d) XOR

Answer 1

Access treats multiple criteria entered on the same line in query design view as being linked with the AND operator.

Step-by-step explanation:

In Microsoft Access, when multiple criteria are entered on the same line in query design view, the default operator used is AND. This means that all the criteria entered must be satisfied for a record to be included in the query results.

For example, if you have a query to find all employees who are both male and have a salary greater than $50,000, you would enter the criteria like this:

• Gender: Male
• Salary: >50000

By using the AND operator, Access will only return the records that meet both criteria.