Start the application to view the records

Assignment Help Database Management System

Reference no: EM13784631

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.

a. Start the application to view the records contained in the dataset, and then stop the application.

b. Open the Code Editor window. Code the btnAll_Click procedure so that it displays all the records.

c. Code the btnShape_Click procedure so that it displays the records for music boxes having the shape selected by the user.

d. CodethebtnSource_Clickproceduresothatitdisplaystherecordsformusicboxes either received as gifts or purchased by the user.

e. 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.

Reference no: EM13784631

Questions Cloud

Name three specific options that are available to genesis : Name three specific options that are available to Genesis Energy for obtaining needed capital. Identify and explain two ways Genesis Energy can improve its strategy.

Biodiversity and environmental conservation : Evaluate how biodiversity is important to environmental conservation.

In your opinion is any kind a hdc : Write a short paper on whether or not you agree with the Courts decision. Is it fair? In your opinion, is Any Kind a HDC

Consolidated federal income tax returns : Spacely Space Sprockets, Inc. was incorporated in Arkansas, and it has filed consolidated federal income tax returns as the parent corporation of an affiliated group of corporations since 1988. It is an accrual-basis, calendar year corporation.

Start the application to view the records : Start the application to view the records contained in the dataset, and then stop the application.

Good idea to foster conflict at work : Are there situations when it would be a good idea to foster conflict at work? How would you do that yet make sure that the conflict does not escalate into "unhealthy" conflict?

Income tax on the winnings : Mock cashed in the ticket, and gave $500,000 to Tuhi. Who owes income tax on the winnings? Did Mock make a gift to Tuhi?

Compare and contrast the complexity and components of the : Compare and contrast the complexity and components of the school budget between a high school, middle school and elementary school.

Distinguish between legal and employee rights : Normal 0 false false false EN-US X-NONE X-NONE Distinguish between legal and ..

User Account

All Pages