Now that you have worked with Robert Iko at the MovinOn moving and storage company to develop the…

Now that you have worked with Robert Iko at the MovinOn
moving and storage company to develop the design for the MovinOn database, he
explains that their most pressing task is to serve the needs of the Human
Resources department. Darnell Colmenero is an administrative assistant
responsible for many human resources tasks, and asks for your help extracting
information from the MovinOn database. Although an outside company processes
payroll for MovinOn, Darnell and others maintain all employment information and
strive to meet management’s goal of recruiting and retaining skilled, qualified
»

Now that you have worked with Robert Iko at the MovinOn
moving and storage company to develop the design for the MovinOn database, he
explains that their most pressing task is to serve the needs of the Human
Resources department. Darnell Colmenero is an administrative assistant
responsible for many human resources tasks, and asks for your help extracting
information from the MovinOn database. Although an outside company processes
payroll for MovinOn, Darnell and others maintain all employment information and
strive to meet management’s goal of recruiting and retaining skilled, qualified
employees who are well trained in customer service. Having employees working in
three warehouses in three states has made it difficult to track employee
information, and the potential merger and expansion means that human resources
must take advantage of the MovinOn database to maintain and retrieve employee
information. Darnell asks for your help in filtering data and creating queries
that provide the information that he needs.

Complete the following:

MovinOn wants to offer hourly pay rates that are competitive
with other moving companies in the Pacific Northwest. To identify nonsalaried
employees who might be eligible for a raise in pay, Darnell asks you to do the
following:

a. Identify employees at each warehouse who earn less than
$12.00 per hour. Do not include salaried employees in the list.

b. Let users specify a particular warehouse, and then see
information only for the employees who work in that warehouse.

c. Save the query as qryEmployeeLowWage.

»