Sarah, a manager, uses Microsoft Access 2016 to manage employee details. She enters "Dan" in the Criteria row in the FirstName column and "Smith" in the same Criteria row in the LastName column in the design grid. In this case, the query datasheet, created by Sarah, will include the records for employees with a FirstName field value _____.
A)not equal to Smith or a LastName field value equal to Dan
B)equal to Dan or a LastName field value equal to Smith
C)equal to Smith and a LastName field value not equal to Dan
D)equal to Dan and a LastName field value equal to Smith

Question

Sarah, a manager, uses Microsoft Access 2016 to manage employee details. She enters "Dan" in the Criteria row in the FirstName column and "Smith" in the same Criteria row in the LastName column in the design grid. In this case, the query datasheet, created by Sarah, will include the records for employees with a FirstName field value _____. ​
A)not equal to Smith or a LastName field value equal to Dan
B)equal to Dan or a LastName field value equal to Smith
C)equal to Smith and a LastName field value not equal to Dan
D)equal to Dan and a LastName field value equal to Smith

Quizplus · Accepted Answer

When criteria are entered in the same row in the design grid in Microsoft Access, it implies an AND condition, meaning the query will return records that meet all the specified criteria. Therefore, the query will include records for employees whose FirstName is "Dan" AND whose LastName is "Smith".

Sarah, a Manager, Uses Microsoft Access 2016 to Manage Employee