Which query do you use to answer the question “Which employees earn more than 5000 USD a month”?
Which query do you use to answer the question “Which employees earn more than 5000 USD a month”?
(A) Search query
(B) Select query
(C) Cross tab query
(D) Update query
In Microsoft Access and similar database systems, a Select query helps pull out certain data by setting conditions. For instance, to locate employees with salaries exceeding 5000 USD, you set up a select query that looks for records where the salary is above 5000. This method effectively isolates the needed information.