Question: Visual Basic Program: Design a Windows application and write the code that will execute according to the program requirements below. Title: Little Leagues Baseball Team

Visual Basic Program: Design a Windows application and write the code that will execute according to the program requirements below.

Title: Little Leagues Baseball Team Database

Purpose: This Windows application opens an Access database that displays information about 22 boys and girls (ages 12-14) who are playing in the National Little League 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 calculates the average age of the team.

Program Procedures: In a Window application, the Access database file is opened and the user can 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 Window application that loads an Access database table, which includes the players number, first name, last name, parents name, address, city, state, zip, telephone, 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 and a graphic image.

2. The user can tap or click the Add new button on the navigation toolbar to add a new player to the team. The record is saved when the user taps or clicks the Save Data Button on the navigation toolbar.

3. The user can tap or click the Delete button on the navigation toolbar to delete a player. The record is permanently deleted when the user taps or clicks the Save Data button on the navigation toolbar.

4. The user can tap or 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.

5. The LittleLeague.accdb file is located on the USB drive (the E: drive).

6. Use a Try-Catch statement to catch an exception if the file is not available.

7. Please show the screenshots of the output.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!