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 expressed a need to see the details related to the
team assignments. She asks you to separate the data somehow so that she can
view each category of detail separately. The team details would include the
identity of the team (Team ID and Sport Name) along with the following
categories of information:

»