Given a table with the structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the following would find all employees whose name begins with the letter "S" using Microsoft Access?
A)SELECT *
FROM EMPLOYEE
WHERE Name IN ['S'];
B)SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE 'S';
C)SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S*';
D)SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';

Question

Quizplus · Accepted Answer

In Microsoft Access, the wildcard character for matching any sequence of characters is '*', so 'S*' is used to find names that start with "S".

Given a Table with the Structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the Following