Comments on the code and algorithms for both applications are required.
1- Open the Playhouse Solution (Playhouse Solution.sln) file contained in the ClearlyVB2012\Chap24\Playhouse Solution folder. Connect the application to the Play database, which is stored in the ClearlyVB2012\Chap24\Access Databases\Play.accdb file. The Play database contains one table named tblReservations. The table contains 20 records. Each record has three fields: a numeric field named Seat and two text fields named Patron and Phone. Drag the field objects to the appropriate label controls in the interface. Code the Click event procedures for the First Record, Last Record, Previous Record, and Next Record buttons. Save the solution and then start and test the application. Close the Code Editor window and then close the solution.
2- Open the MusicBox Solution (MusicBox Solution.sln) file contained in the ClearlyVB2012\Chap25\MusicBox Solution folder. The application is connected to the MusicBox database stored in the MusicBox.accdb file. The database contains a table named tblBox. The table contains 10 records, each composed of four text fields.
Start the application to view the records contained in the dataset, and then stop the application.
Open the Code Editor window. Code the btnAll_Click procedure so that it displays all the records.
Code the btnShape_Click procedure so that it displays the records for music boxes having the shape selected by the user.
CodethebtnSource_Clickproceduresothatitdisplaystherecordsformusicboxes either received as gifts or purchased by the user.
Code the btnCount_Click procedure to display (in a message box) the number of music boxes in the dataset.
f. Save the solution and then start and test the application. Close the Code Editor window and then close the solution.
1- Open the Playhouse Solution (Playhouse Solution.sln) file contained in the ClearlyVB2012\Chap24\Playhouse Solution folder. Connect the application to the Play database, which is stored in the ClearlyVB2012\Chap24\Access Databases\Play.accdb file. The Play database contains one table named tblReservations. The table contains 20 records. Each record has three fields: a numeric field named Seat and two text fields named Patron and Phone. Drag the field objects to the appropriate label controls in the interface. Code the Click event procedures for the First Record, Last Record, Previous Record, and Next Record buttons. Save the solution and then start and test the application. Close the Code Editor window and then close the solution.
2- Open the MusicBox Solution (MusicBox Solution.sln) file contained in the ClearlyVB2012\Chap25\MusicBox Solution folder. The application is connected to the MusicBox database stored in the MusicBox.accdb file. The database contains a table named tblBox. The table contains 10 records, each composed of four text fields.
Start the application to view the records contained in the dataset, and then stop the application.
Open the Code Editor window. Code the btnAll_Click procedure so that it displays all the records.
Code the btnShape_Click procedure so that it displays the records for music boxes having the shape selected by the user.
CodethebtnSource_Clickproceduresothatitdisplaystherecordsformusicboxes either received as gifts or purchased by the user.
Code the btnCount_Click procedure to display (in a message box) the number of music boxes in the dataset.
f. Save the solution and then start and test the application. Close the Code Editor window and then close the solution.
