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:

David Bowers is considering providing bonuses to long-term
employees. Darnell asks you to list the 10 employees who have worked for
MovinOn the longest. Name the query qryLongestEmployment.

»