Use of the Site for Students - Essay Example

Program Guide Main menu In the main menu you can access the FILE, ADMIN, MAINTENANCE, and REPORTS menu Under the FILE MENU you can access the Register Student, Module Maintenance, Student Maintenance, Inventory Maintenance, Setup, and Exit. Under the ADMIN menu you can access the Create Program and Staff Maintenance. Under the MAINTENANCE you can access back up, and restore database Program Menu Creation of Programme entries are being encode here. Selection of subjects for a given time and schedule are being created here. 1. To enter new entry click the NEW BUTTON then fill up all the textbox needed like program code, program name school year, semester and director. 2. Click the ADD BUTTON to add new row in the msflexgrid data and double click the column of each row to enter module code and name, days, time from, time to, room , type and capacity. 3. click the save button if you are finish for that program 4. To open the existing program just click the OPEN BUTTON a search window will appear the select the one of the existing program. Student Maintenance In this system student information are created here and requires every student to register first for personal information and to be used for any emergency purposes. 1. Click the NEW BUTTON then fill up the necessary information in the text box, after you finish the entry click the Save Buttton. 2. To open / edit the existing Student click the FIND BUTTON a search window will appear then search the student you like to open /edit then click the ok button. Faculty maintenance Faculty staffs are also to be recorded as well to monitor their subjects on hand and for any future purposes. 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 Staff click the FIND BUTTON a search window will appear then search the student you like to open /edit then click the ok button. Module Maintenance Information about any subjects in a given curriculum can be viewed and displayed in this window for staffs and students as well. Information like subject codes, subject descriptions, no. 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 database. Restore Database This menu will help the user to restore the database in case of any problems arises in current database. Choose the Folder where the back up database is located then click the restore Button to restore. LIST OF TABLES Student Table NAME DATA TYPE DESCRIPTION IDNO CHARACTER ID Code "Primary Key" COURSE CHARACTER Course DEPART CHARACTER Department LNAME CHARACTER Last Name FNAME CHARACTER First Name MNAME CHARACTER Middle Name STREET CHARACTER Street CITY CHARACTER City PROVI CHARACTER Province CPHONE CHARACTER Cell Phone Number WPHONE CHARACTER Work Phone Number EMAIL CHARACTER Email Address GENDER CHARACTER Gender STATS CHARACTER Stats BIRTH DATE Date Of Birth WEIGHT CHARACTER Weight HEIGHT CHARACTER Height Staff Table NAME DATA TYPE DESCRIPTION IDNO CHARACTER Staff Code "Primary Key" LNAME CHARACTER Lastname FNAME CHARACTER Firstname MNAME CHARACTER Middle Name CPHONE CHARACTER CellPhone WPHONE CHARACTER Work Phone EMAIL CHARACTER Email Address ADDRESS CHARACTER Home Address FACULTY CHARACTER Faculty Program Table NAME DATA TYPE DESCRIPTION REFNBR CHARACTER Ref Nmber("Primary Key") CODE CHARACTER Module Code DESC CHARACTER Module Description UNITS CHARACTER Units DAYS1 CHARACTER Days e.g M-W-F STIME CHARACTER Start Time ETIME CHARACTER End Time ROOMNBR CHARACTER Room Number TYPE CHARACTER Type CPCTY NUMBER Capacity of Class Room YEAR1 CHARACTER Year YEAR2 CHARACTER Year SEM CHARACTER Semester SNAME CHARACTER Program Name DIRECTOR CHARACTER Director Name PGCODE CHARACTER Program Code Module Table NAME DATA TYPE DESCRIPTION CODE CHARACTER Module Code "Primary Key" DESC CHARACTER Description UNITS CHARACTER Units LEVEL CHARACTER Level SEM CHARACTER Semester TYPE CHARACTER Type SUPERVISOR CHARACTER Supervisor Inventory Table NAME DATA TYPE DESCRIPTION CODE CHARACTER Module Code "Primary Key" DESC CHARACTER Description UNITS CHARACTER Units LEVEL CHARACTER Level SEM CHARACTER Semester TYPE CHARACTER Type SUPERVISOR CHARACTER Supervisor Student Register/Schedule Table NAME DATA TYPE DESCRIPTION IDNO CHARACTER Student IDCode"Primary Key" CODE CHARACTER Module Code DESC CHARACTER Module Description UNITS CHARACTER Units DAYS1 CHARACTER Days e.g M-W-F STIME CHARACTER Start Time ETIME CHARACTER End Time ROOMNBR CHARACTER Room Number TYPE CHARACTER Type CPCTY NUMBER Capacity of Class Room REFNBR CHARACTER Reference Number for Program YEAR1 CHARACTER Year YEAR2 CHARACTER Year SEM CHARACTER Semester SNAME CHARACTER Program Name DIRECTOR CHARACTER Director Name PGCODE CHARACTER Program Code User table NAME DATA TYPE DESCRIPTION USERNAME CHARACTER Username "Primary Key" PASSWORD CHARACTER Password LEVEL CHARACTER Level of Access FNAME CHARACTER Firstname LNAME CHARACTER Lastname TITLE CHARACTER Title Class Room Table NAME DATA TYPE DESCRIPTION ROOMID CHARACTER Room Code "Primary Key" Desc CHARACTER Description Note CHARACTER Remarks Some SQL Commands from the Program Written in Visual Basic 1. Student Report: 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 & " ") If rst.RecordCount Read More