Assalamualaikum....
This will be the last of my computer in education course. So far....I really did enjoy in doing all my assignments from the beginning of week 1 until today. There are so much knowledge about ICT that I gain from this course.
Okay, moving on, for this week assignment we were asked to create a database for students using OpenOffice.
First of all, we need to click on the database on the OpenOffice
Then, we need to create 4 tables: Student, Family, Curriculum and Co-Curriculum.
We need to choose *create form in Design View*
When we click on that, some like in the picture below will appear:
In the table, we need to fill in the Field Name and Field Type. As an example, if we want to create a table for student, we need to fill the Field Name with 'No.Matrik' , 'Student.Name' and so on. We also need to set up a primary key for the table. For us, we will choose the 'No.Matrik' as the Primary Key for all the tables. After we have finish with it, the table will look something like this:
We need to create 3 more tables for *family*, *Curriculum* , and *Co-Curriculum* with the same method that we use to create the Student Table.
After we have finished will all the 4 tables, the tables will appear like this:
Next step will be to create a form for *Student* , *Family* , *Curriculum* and *Co-Curriculum*
To create a form, we need to click on *Use Wizard to Create Form*
When we click on that menu, something like the picture below will appear:
Then we can choose the table that we want to add in our Form. As for example, to make a *Student Form* , choose the *Student Table*. After that, we can click on *Finish*. We can also choose the layout of our Form by clicking on the *Arrange Control* on the left side menu.
When we have finish, the form will look like this:
Create 3 more forms for *Family* , *Curriculum* and *Co-Curriculum*. After we have finished all, we can all the forms on the Form section:
We also need to create a 'Relationships' for all the 4 tables that we have made so that all the for table will be connected. To create a 'Relationship' , click on the 'Tools' menu then click on the 'Relationships'. When we have click on that, something like the picture below will appear:
When we have done with the relationships, we can proceed on filling in all the 4 forms. We need to *save* all the detail that we have fill in the forms. When we have finish filling in all the forms, it will look like this:
Student Form
Family Form
Curriculum Form:
Co-Curriculum
After finished all the form, we will proceed in creating a *Queries* for student, family, curriculum and also Co-curriculum. To create a queries, we need to click on the *Use Wizard to Create Queries* .
When we click on that, something like the below will appear:
As we did previously for Forms, we also need to select which table that we want to add on our Queries and when we have done, just click on *Finish*
After we have finish with it, our Queries will look like this:
Do the same for the rest of the queries for *Family* , *Curriculum* and also *Co-Curriculum*. When we have finished with all the Queries, we can view all of the Queries on the Queries section.
After we have finished with the Queries, we continue by creating a report for *Student* , *Family* , *Curriculum* and *Co-Curriculum* .
To create a report, click on *Use Wizard to Create Report*
When we click on that, it will appear like this:
Same as we did before, we have to choose which table that we want to add in our report. After we have choose the table that we want, we then start creating out report.
After have finish creating the report, it will look something like this.
Student Report
Then, we can print out all the reports if we want to.