81
Which query do you use to answer the question "Which employees earn more than $5000 a month"?
Answer & Solution
Answer: Option
C
Solution:
The correct answer is Option C: Select query. In Microsoft Access, a Select query is used to retrieve and display data from one or more tables based on certain criteria. It is the most commonly used type of query for finding and displaying specific information from a database.
To answer the question "Which employees earn more than $5000 a month," you would create a Select query that specifies the condition to filter the results. The query would look something like this:
SELECT EmployeeName, Salary FROM Employees WHERE Salary > 5000;
Explanation of why other options are incorrect: Option A: Search query is not a standard type of query in MS Access. Option B: Cross tab query is used to summarize data and create a pivot table-like view, which is not suitable for answering a question about individual records. Option D: Update query is used to modify existing data in a table, not for retrieving or filtering data.
Therefore, the most appropriate type of query to use for finding employees earning more than $5000 a month is a Select query.
To answer the question "Which employees earn more than $5000 a month," you would create a Select query that specifies the condition to filter the results. The query would look something like this:
SELECT EmployeeName, Salary FROM Employees WHERE Salary > 5000;
Explanation of why other options are incorrect: Option A: Search query is not a standard type of query in MS Access. Option B: Cross tab query is used to summarize data and create a pivot table-like view, which is not suitable for answering a question about individual records. Option D: Update query is used to modify existing data in a table, not for retrieving or filtering data.
Therefore, the most appropriate type of query to use for finding employees earning more than $5000 a month is a Select query.