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:

To prepare for a payroll, Darnell must provide a list of
employees that includes their salary or hourly pay rate. The list must
also include Social Security numbers and employee IDs so that an outside firm
can properly process the payroll. Produce an employee list that provides this
information, and sort it so that it’s easy to find an employee by name. For
those employees who are on a salary, the list should show their monthly wage.
Save the query as qryPayroll.

»