Create a database Rugby accdb that has two tables Players and Teams. The fields for the...

  

Transcribed Image Text:

Create a database Rugby accdb that has two tables Players and Teams. The fields for the Players table must be player, team, games, and points. The fields for the Teams table are team, location, league, stadium, games, and points. The tables can be filled with fictional or real data. The Players table must list at least 100 players with their team name, number of games played in a season and points scored in a season. The Teams table must list at least 20 teams, their home town, the league they play in, their home stadium name, number of games the team played at the stadium and the number of points the team scored at the stadium. Example Players Marco van Staden Andisa Ntsila Grant Williams Kobus Holtzhausen Example Teams Vodacom Bulls Toyota Cheetahs Cell C Sharks Ermelo Tomahawks Vodacom Bulls Toyota Cheetahs Cell C Sharks Ermelo Tomahawks Pretoria Bloemfontein Durban Ermelo 15 10 12 18 Currie Cup Currie Cup Currie Cup SA Rugby 29 42 8 42 Loftus Versveld Toyota Stadium Hollywoodbets Kings Park AJ Swanepoel Stadium 7 -0055 8 186 206 280 140 1. Write a program that shows all the teams from the Teams table in a list box. When the user clicks on one of the teams, the program should display the team's home stadium in a text box. 2. Write a program to display in a DataGridView control the names of all the teams, their home stadiums, and the teams' average points for home games (points / games). 3. Write a program to display, in a list box, the player (or players) in the Players table with the highest points. 4. Write a program to display, in a list box, the player (or players) in the Players table with the highest points average (points / games). 5. Write a program that shows all the teams from the Teams table in a list box. When the user clicks on one of the teams, the program should display, in a DataGridView control, the names of all the players in the Players table from that team, along with their average points. The players should be listed in descending order of their average points. 6. Write a program that shows all the players' points averages above 3.0 in a list box. When the user clicks on one of the points averages, the program should display, in a DataGridView control, the names of all the players in the Players table with that points average, along with their teams. The players should be listed in alphabetical order by their last names. 7. Write a program that uses the Teams table to calculate the overall points average for the players in the Currie Cup. 8. Write a program that uses the Teams table to calculate the total number of points in the Currie Cup. 9. Write a program to count the number of players in the Players table who play for a Currie Cup team. 10. Write a program to count the number of players in the Players table who play for a Bloemfontein team. 11. Write a program that contains two radio buttons captioned "Currie Cup" and "SA Rugby". When the user clicks on one of them, the program should display, in a DataGridView control, the names of all the teams in the Teams table from that league, along with their team points averages. The teams should be listed in descending order of their points average. 12. Write a program that contains two radio buttons captioned "Currie Cup" and "SA Rugby". When the user clicks on one of them the program should display in a DataGridView control the 11. Write a program that contains two radio buttons captioned "Currie Cup" and "SA Rugby". When the user clicks on one of them, the program should display, in a DataGridView control, the names of all the teams in the Teams table from that league, along with their team points averages. The teams should be listed in descending order of their points average. 12. Write a program that contains two radio buttons captioned "Currie Cup" and "SĂ Rugby". When the user clicks on one of them, the program should display, in a DataGridView control, the names of all the players from the league who had more than 40 points, along with their points average and home stadiums. The players should be listed in descending order of their points averages. 13. Write a program that shows all the teams from the Teams table in a list box. When the user clicks on one of the teams, the program should display, in another list box, the names of all the players in the Players table from that team, whose points average was greater than their teams' points average. The players should be listed in descending order of their points averages. 14. Write a program that requests a points average and a league (Currie Cup or SA Rugby) and then displays, in a list box, the names of all the players in the league whose points average is greater than the given points average. The players should be listed in descending order by the number of points they had during the season. The program should not allow the given points average to be greater than 10 or less than 0. 15. Write a program to display the player (or players) in the Currie Cup with the highest points average. 16. Write a program to display the player (or players) in the SA Rugby league with the most points. Crading Rubric Create a database Rugby accdb that has two tables Players and Teams. The fields for the Players table must be player, team, games, and points. The fields for the Teams table are team, location, league, stadium, games, and points. The tables can be filled with fictional or real data. The Players table must list at least 100 players with their team name, number of games played in a season and points scored in a season. The Teams table must list at least 20 teams, their home town, the league they play in, their home stadium name, number of games the team played at the stadium and the number of points the team scored at the stadium. Example Players Marco van Staden Andisa Ntsila Grant Williams Kobus Holtzhausen Example Teams Vodacom Bulls Toyota Cheetahs Cell C Sharks Ermelo Tomahawks Vodacom Bulls Toyota Cheetahs Cell C Sharks Ermelo Tomahawks Pretoria Bloemfontein Durban Ermelo 15 10 12 18 Currie Cup Currie Cup Currie Cup SA Rugby 29 42 8 42 Loftus Versveld Toyota Stadium Hollywoodbets Kings Park AJ Swanepoel Stadium 7 -0055 8 186 206 280 140 1. Write a program that shows all the teams from the Teams table in a list box. When the user clicks on one of the teams, the program should display the team's home stadium in a text box. 2. Write a program to display in a DataGridView control the names of all the teams, their home stadiums, and the teams' average points for home games (points / games). 3. Write a program to display, in a list box, the player (or players) in the Players table with the highest points. 4. Write a program to display, in a list box, the player (or players) in the Players table with the highest points average (points / games). 5. Write a program that shows all the teams from the Teams table in a list box. When the user clicks on one of the teams, the program should display, in a DataGridView control, the names of all the players in the Players table from that team, along with their average points. The players should be listed in descending order of their average points. 6. Write a program that shows all the players' points averages above 3.0 in a list box. When the user clicks on one of the points averages, the program should display, in a DataGridView control, the names of all the players in the Players table with that points average, along with their teams. The players should be listed in alphabetical order by their last names. 7. Write a program that uses the Teams table to calculate the overall points average for the players in the Currie Cup. 8. Write a program that uses the Teams table to calculate the total number of points in the Currie Cup. 9. Write a program to count the number of players in the Players table who play for a Currie Cup team. 10. Write a program to count the number of players in the Players table who play for a Bloemfontein team. 11. Write a program that contains two radio buttons captioned "Currie Cup" and "SA Rugby". When the user clicks on one of them, the program should display, in a DataGridView control, the names of all the teams in the Teams table from that league, along with their team points averages. The teams should be listed in descending order of their points average. 12. Write a program that contains two radio buttons captioned "Currie Cup" and "SA Rugby". When the user clicks on one of them the program should display in a DataGridView control the 11. Write a program that contains two radio buttons captioned "Currie Cup" and "SA Rugby". When the user clicks on one of them, the program should display, in a DataGridView control, the names of all the teams in the Teams table from that league, along with their team points averages. The teams should be listed in descending order of their points average. 12. Write a program that contains two radio buttons captioned "Currie Cup" and "SĂ Rugby". When the user clicks on one of them, the program should display, in a DataGridView control, the names of all the players from the league who had more than 40 points, along with their points average and home stadiums. The players should be listed in descending order of their points averages. 13. Write a program that shows all the teams from the Teams table in a list box. When the user clicks on one of the teams, the program should display, in another list box, the names of all the players in the Players table from that team, whose points average was greater than their teams' points average. The players should be listed in descending order of their points averages. 14. Write a program that requests a points average and a league (Currie Cup or SA Rugby) and then displays, in a list box, the names of all the players in the league whose points average is greater than the given points average. The players should be listed in descending order by the number of points they had during the season. The program should not allow the given points average to be greater than 10 or less than 0. 15. Write a program to display the player (or players) in the Currie Cup with the highest points average. 16. Write a program to display the player (or players) in the SA Rugby league with the most points. Crading Rubric

Answer rating: 100% (QA)

answer Create the Players table CREATE TABLE Players PlayerID AUTOINCREMENT PRIMAR... View the full answer