VISUAL PROGRAMMING

QUESTION 5 BioSinar Sdn.Bhd plan to develop a VB system to store their employee details. You are hired as a programmer to build this system. The basic program has an interface as shown in Figure 12.0. The data will be put in a database named as "staffDetails.mdb" and all the data in the database is shown as in the interface. Staff Details Information Staff ID: 108546 Name: Ahmad Adham Full Time: Yes Add Hire Date: Save Delete January, 2021 Sun Mon Tue Wed Thu Fri 27 28 29 30 31 1 3 4 5 6 7 8 10 11 12 13 14 15 17 18 19 20 21 22 24 25 26 27 28 29 31 1 2 3 4 5 Today: 13/1/2021 Sat 2 9 16 23 30 6 Exit Salary First Previous Next Last Figure 12.0 Write a Visual Basic program for Add, Save, Delete, and Delete button. The program must be able to go the Next, Previous, First and Last record when the users click that particular button. Show a message box after users successfully add, save or delete the data. Name of the components used in connecting the database (staffDetails.mdb) are: Table Adapter Manager, StaffDetails BindingNavigator, StaffDetails Data Set, StaffDetails Binding Source, StaffDetailsTableAdapter. (15 marks) QUESTION 5 BioSinar Sdn.Bhd plan to develop a VB system to store their employee details. You are hired as a programmer to build this system. The basic program has an interface as shown in Figure 12.0. The data will be put in a database named as "staffDetails.mdb" and all the data in the database is shown as in the interface. Staff Details Information Staff ID: 108546 Name: Ahmad Adham Full Time: Yes Add Hire Date: Save Delete January, 2021 Sun Mon Tue Wed Thu Fri 27 28 29 30 31 1 3 4 5 6 7 8 10 11 12 13 14 15 17 18 19 20 21 22 24 25 26 27 28 29 31 1 2 3 4 5 Today: 13/1/2021 Sat 2 9 16 23 30 6 Exit Salary First Previous Next Last Figure 12.0 Write a Visual Basic program for Add, Save, Delete, and Delete button. The program must be able to go the Next, Previous, First and Last record when the users click that particular button. Show a message box after users successfully add, save or delete the data. Name of the components used in connecting the database (staffDetails.mdb) are: Table Adapter Manager, StaffDetails BindingNavigator, StaffDetails Data Set, StaffDetails Binding Source, StaffDetailsTableAdapter. (15 marks)