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 has reviewed the forms you created and is pleased with
the way they look. However, she found it difficult to locate specific records.
Carla has asked if you could provide a simple way for her to select the
specific records she wants to view. If you can do this, she asks that you add
this feature to the student, coach, and maintenance personnel forms.

»