YOUTH LEAUE SOCCER TEAM DATABASE Design a Windows application and write the code that will execute according to the program requirements in Figure 10-70. Before designing the user interface, create a Use Case Definition. Before writing the code, create an event planning document for each event in the program.

REQUIREMENTS DOCUMENT Date: May 13, 2019 Date Submitted: Application Title: Youth League Soccer Team Database Purpose: This Windows application opens an Access database that displays information about 22 boys and girls (ages 1214) who are playing in the National Youth League Soccer championship. The data in the database can be viewed, updated, and deleted in the Windows form. The application computes in three separate counts the number of team members who are 12, 13, or 14 years old, and calculates the average age of the team. Program In a Windows application, the Access database file is opened and the user can Procedures: view, add, and delete records as needed. You can also display the total number of players of each age (12, 13, or 14) in the database. Algorithms, 1. The user first views a Windows application that loads an Access database Processing, and table, which includes the player's number, first name, last name, parent's Conditions: name, city, state, zip, phone, and age. A navigation toolbar appears at the top of the Windows form, allowing the user to move from record to record. The Windows form also includes a title. 2. The user can click the Add new button on the navigation toolbar to add a new player to the team. The record is saved when the user clicks the Save Data button on the navigation toolbar. 3. The user can click the Delete button on the navigation toolbar to delete a player. The record is permanently deleted when the user clicks the Save Data button on the navigation toolbar. 4. The user can click the Ages Button object to compute the total number of team members who are 12, 13, or 14 years old. The user can also compute the average age of the team. Notes and Restrictions: The Soccer.accdb file is located on the USB drive (the D drive). Comments: The Soccer.accdb file is available on CengageBrain.com. FIGURE 10-70 REQUIREMENTS DOCUMENT Date: May 13, 2019 Date Submitted: Application Title: Youth League Soccer Team Database Purpose: This Windows application opens an Access database that displays information about 22 boys and girls (ages 1214) who are playing in the National Youth League Soccer championship. The data in the database can be viewed, updated, and deleted in the Windows form. The application computes in three separate counts the number of team members who are 12, 13, or 14 years old, and calculates the average age of the team. Program In a Windows application, the Access database file is opened and the user can Procedures: view, add, and delete records as needed. You can also display the total number of players of each age (12, 13, or 14) in the database. Algorithms, 1. The user first views a Windows application that loads an Access database Processing, and table, which includes the player's number, first name, last name, parent's Conditions: name, city, state, zip, phone, and age. A navigation toolbar appears at the top of the Windows form, allowing the user to move from record to record. The Windows form also includes a title. 2. The user can click the Add new button on the navigation toolbar to add a new player to the team. The record is saved when the user clicks the Save Data button on the navigation toolbar. 3. The user can click the Delete button on the navigation toolbar to delete a player. The record is permanently deleted when the user clicks the Save Data button on the navigation toolbar. 4. The user can click the Ages Button object to compute the total number of team members who are 12, 13, or 14 years old. The user can also compute the average age of the team. Notes and Restrictions: The Soccer.accdb file is located on the USB drive (the D drive). Comments: The Soccer.accdb file is available on CengageBrain.com. FIGURE 10-70