Creating Data-Entry Forms for the Hershey College Intramural Department In this project, you…

Creating Data-Entry Forms for the Hershey College Intramural
Department

In this project, you continue your work for Carla Stockman,
assistant director of the intramural department at Hershey College. You have
already created several tables and queries for the intramural department
database. In this project, you will create some forms that will be used to
enter and update data. Carla has requested that you create forms for each of
the tables in the database. This will allow the department staff and student
workers to enter data easily and efficiently.

After you create the simple forms,
»

Creating Data-Entry Forms for the Hershey College Intramural
Department

In this project, you continue your work for Carla Stockman,
assistant director of the intramural department at Hershey College. You have
already created several tables and queries for the intramural department
database. In this project, you will create some forms that will be used to
enter and update data. Carla has requested that you create forms for each of
the tables in the database. This will allow the department staff and student
workers to enter data easily and efficiently.

After you create the simple forms, Carla asks that you
create some forms that will be used to assign students to teams in their chosen
sport. Carla states that it would be best to show the teams at the top of the
form and that it would be helpful if the teams can be browsed by sport (for
example, first you see the basketball teams, then the baseball teams, and so
on). She has asked that the lower portion of the form contain information
related to the students who are assigned to that team.

Complete the following:

Carla is very pleased with what you have provided so far.
She has asked for one more form that will help the staff review the coaching
assignments. Carla wants to have a form that will display the coaches in one
part of the form and the teams they coach in another part. She also asks you to
provide a command button that the staff can click to add coaches to the
database.

»