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:

Robert tells you that the Human Resources department has
made another request. As they
»

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:

Robert tells you that the Human Resources department has
made another request. As they reviewed employee data, they noticed that
employee reviews have not been recorded in the database. Prior to the creation
of this database, employee reviews were done on paper and stored in a file
cabinet. Human Resources plans to record their reviews directly into the
database. They have requested a form they can use to enter the results of their
employee review. The information will be recorded in the Comments field with a
free format (that is, the HR representative who does the review will simply
write notes into this comments field). Reviews are done every three years. Your
form should display only those employees who have been employed more than three
years. Create a query that will limit the data to employees who fit this
specification, and then create a form that will properly display the employee
data (all fields). Robert suggests that you use the same technique as you used
on the employee form to open the form in which HR can record their notes about
the employee. Name the form frmEmployee3YearReviews, and use a similar name for
the corresponding query

»