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:

When you show qryEmployeeContact to Darnell, he realizes
that it would be more helpful if he could specify a particular warehouse before
producing the list, and then see the contact information only for the employees
who work in that warehouse. Create a query that meets these needs, saving it as
qryEmployeeContactByWarehouse. Test this query with valid and invalid warehouse
information.

»