CS2453: Visual Basic VB 8: Karate Objectives 1. Create VB applications that use databases. 2. Connect to a database 3. Use the DataGrid View control 4. Use data bound controls 5. Query using data from a database 6. Use SQL to query Situation Using the Karate database that came with the text book, create a complete query application. You are to complete Programming Challenges 5 -8 Include pre-defined queries with an appropriate name for each query. All these Challenges are to be displayed as menu options. For example, results for Programming Challenge 5 and 6 will be displayed for menu option" List Members by Join Date". Group the menu options meaningfully. You are to also include menu options that will: 1. Display the first name, last name and phone numbers of all members of the Kyoshi Karate School 2. Display details of all payments made to the Kyoshi Karate School. Each of the queries can display results on separate forms. Include on each separate form, a menu option to close the form. Refer to the Karate School Management Application (page 678 - 692) as a guide while you create your application. You are to create your own interface and make sure that you create each form as neat and self explanatory as possible Specifications 1. Recuring Specifications that are required for the Karate program 1. The form must be renamed and the title changed to reflect YourFirstName and YourLastName as Karate Queries by YourFirstName YourLastName. (If Pat Programmer was creating this program, it would be Karate ueies by Pat Programmer) 2. Code must be grouped and commented in compliance with this course's programming standards . ALL files, forms, and controls MUST be renamed 4. Option Strict and Option Explicit must be ON 5. ALL controls on the form must be in logical TabOrder sing TabIndex in the Properties window for each control. Label1 (or similar name) does not appear at runtime most efficient. 6. The text property of Labels must be changed so that 7. Data types for variables and constants must be the 8. Use With..End With if and when appropriate 9. ToolTips 10 Various erroneous inputs will be tested during the grading process. If any of them result in the program halting of crashing, the maximum credit will be 50%. If submitted by the initial deadline, it may be resubmitted until the final deadline. Work that is late or resubmitted is subject to a 10% penalty, but that might be better than 50% or a 0 2. Connection Strings must not include absolute paths (paths to files on your C:VB20151Chapteri0...) The programs MUST run without modifications when they are graded CS2453: Visual Basic VB 8: Karate Objectives 1. Create VB applications that use databases. 2. Connect to a database 3. Use the DataGrid View control 4. Use data bound controls 5. Query using data from a database 6. Use SQL to query Situation Using the Karate database that came with the text book, create a complete query application. You are to complete Programming Challenges 5 -8 Include pre-defined queries with an appropriate name for each query. All these Challenges are to be displayed as menu options. For example, results for Programming Challenge 5 and 6 will be displayed for menu option" List Members by Join Date". Group the menu options meaningfully. You are to also include menu options that will: 1. Display the first name, last name and phone numbers of all members of the Kyoshi Karate School 2. Display details of all payments made to the Kyoshi Karate School. Each of the queries can display results on separate forms. Include on each separate form, a menu option to close the form. Refer to the Karate School Management Application (page 678 - 692) as a guide while you create your application. You are to create your own interface and make sure that you create each form as neat and self explanatory as possible Specifications 1. Recuring Specifications that are required for the Karate program 1. The form must be renamed and the title changed to reflect YourFirstName and YourLastName as Karate Queries by YourFirstName YourLastName. (If Pat Programmer was creating this program, it would be Karate ueies by Pat Programmer) 2. Code must be grouped and commented in compliance with this course's programming standards . ALL files, forms, and controls MUST be renamed 4. Option Strict and Option Explicit must be ON 5. ALL controls on the form must be in logical TabOrder sing TabIndex in the Properties window for each control. Label1 (or similar name) does not appear at runtime most efficient. 6. The text property of Labels must be changed so that 7. Data types for variables and constants must be the 8. Use With..End With if and when appropriate 9. ToolTips 10 Various erroneous inputs will be tested during the grading process. If any of them result in the program halting of crashing, the maximum credit will be 50%. If submitted by the initial deadline, it may be resubmitted until the final deadline. Work that is late or resubmitted is subject to a 10% penalty, but that might be better than 50% or a 0 2. Connection Strings must not include absolute paths (paths to files on your C:VB20151Chapteri0...) The programs MUST run without modifications when they are graded