Providing Data-Entry Forms for MovinOn Inc. In this project, you continue working with Robert Iko,..

Providing Data-Entry Forms for MovinOn Inc.

In this project, you continue working with Robert Iko, the
information manager for MovinOn. Robert asks you to begin building forms that
let users view and enter data. He suggests that you start by building some
simple forms that will be used for entering data into the customers, drivers,
employees, trucks, and warehouses tables. He also needs a few more
sophisticated forms that you can base on queries or multiple tables.

 Complete the following:

The Human Resources department has asked that you create a
form with which they can view the
»

Providing Data-Entry Forms for MovinOn Inc.

In this project, you continue working with Robert Iko, the
information manager for MovinOn. Robert asks you to begin building forms that
let users view and enter data. He suggests that you start by building some
simple forms that will be used for entering data into the customers, drivers,
employees, trucks, and warehouses tables. He also needs a few more
sophisticated forms that you can base on queries or multiple tables.

 Complete the following:

The Human Resources department has asked that you create a
form with which they can view the warehouses and the employees who work in each
warehouse. This form is not to be used for data entry, rather the HR department
will use it to view the employee assignments and review the salaries by
warehouse. Robert has assigned you to create this form. In the main form,
Robert asks that you place the pertinent data from the warehouse table. In this
case, you do not need to add all the fields from the table. In the subform,
Robert asks that you place data from the employees table that shows the
employees for each warehouse, their position title, and what they are paid.
(Note: Remember that some of the employees are paid a salary and some are paid
an hourly rate. For this form, you will need both fields included.) As always,
check your work carefully and make any adjustments you feel are necessary. Name
this form frmWarehouseAndEmployees.

»