Data base Essay Example | Topics and Well Written Essays - 2000 words

Data base - Essay Example of units, covered semester and type of subject if major or minor type. 1. Click the NEW BUTTON then fill up the necessary information in the text box, after you finish the entry click the Save Button. 2. To open / edit the existing Module double click the row in the database listing then edit the information then click the update or delete. Inventory Menu This menu allows the user to add and view any inventory materials in a given room or facilities. This also help for easy monitoring of number of facilities and materials to be issued to staff members also. 1. Click the NEW BUTTON then fill up the necessary information in the text box, after you finish the entry click the Save Button. 2. To open / edit the existing Module double click the row in the database listing then edit the information then click the update button or delete button. Registration Entry In this window the user can view the students course with its corresponding subjects and units informations given to them in a semester during the enrolment. In this, will load the entire module schedule of the student during the registration. 1. Click the student button to select the student to register. 2. Click the add button then a new row will be added to the msflexgrid data 3. Double click the row to select the module available. 4. You can also navigate the available program on the lower part of this entry then you can click the load all button to load the entire module schedule in the student registration. 5. After you finish click the save button Back Up In case of database error arises there's a backup database to restore. Choose the Folder where you will store you back up...In this, will load the entire module schedule of the student during the registration. Set rst = de.cn.Execute("SELECT stschedule.*,(Student.level) as rlevel,Student.height, Student.course, Student.depart, Student.level, Student.lname, Student.fname, Student.mname FROM stschedule INNER JOIN Student ON stschedule.idno = Student.idno Where stschedule.idno =" & search1 & " ")