In this exercise, you modify the application from Exercise 2. Use Windows to make a copy of the Jacoby Solution folder. Rename the copy Jacoby Solution-LINQ. Open the Jacoby Solution (Jacoby Solution.sln) file contained in the Jacoby Solution-LINQ folder. Add a button named btnTotal to the form. Change the button’s Text property to & Total Sales. The button’s Click event procedure should display the total sales amount in a message box. Test the application appropriately.

Data From Exercise 2:

Open the VB2015\Chap14\Jacoby Solution\Jacoby Solution (Jacoby Solution.sln) file. The application is connected to the Sales database, which contains a table named tblSales. Each record in the table has four numeric fields named RecordNum (the primary key), YearNum, MonthNum, and Sales. The btnAdd_Click procedure should allow the user to add records to the database, but only when the four text boxes contain data. The record numbers in the database must be unique. The records should appear in numerical order by the record number. Code the application and then test it appropriately.