Using Visual Basic, develop a Course Record Keeping Application (CRKA) to keep track of the courses that you have completed at PMU.
Design the User Interface as shown in Figure 1 below.
Figure 2: Updating Number of Courses Label
Next, insert the necessary code to enable the user to perform the insert, retrieve, update, delete, and clear operations. Tip: copy the code from the VB Code folder or from the Music Sales application developed in the lab and make the necessary changes. At startup, make sure that the Course ID ComboBox lists the IDs of all courses that have been inserted before (adjust the Number of Courses label accordingly).
Next, log in to Oracle SQL Developer and use the CREATE TABLE command in Chapter 7 to create your MYCOURSES table. The table should have three columns as shown in Table 1 below:
Attribute Name Data Type
ID VARCHAR(10)
Title VARCHAR(50)
FGrade VARCHAR(3)