1 Open the JM Sales Solution (JM Sales Solution sln) file contained in the VB2015 Chap14 JM Sales Solution folder The application is connected to the AnnualSales database, which contains a table named tblSales Each record in the table has two numeric fields YearNum (the primary key) and Sales The btnAdd Click procedure should allow the user to add records to the database The btnDelete Click procedure should allow the user to delete records (by year number) from the database Use SQL to code the procedures Test the application appropriately Be sure to try adding a record whose year number matches an existing year number

Question

1  Open the JM Sales Solution (JM Sales Solution sln) file contained in the VB2015  Chap14   JM Sales Solution folder  The application is connected to the AnnualSales database, which contains a table named tblSales  Each record in the table has two numeric fields  YearNum (the primary key) and Sales  The btnAdd Click procedure should allow the user to add records to the database  The btnDelete Click procedure should allow the user to delete records (by year number) from the database  Use SQL to code the procedures  Test the application appropriately  Be sure to try adding a record whose year number matches an existing year number

SolutionInn · Accepted Answer

The Answer is in the image, click to view ...

Question: 1. Open the JM Sales Solution (JM Sales Solution.sln) file contained in the VB2015Chap14 JM Sales Solution folder. The application is connected to the AnnualSales

Step by Step Solution