CARMEL SCHOOL KUWAIT
INFORMATION TECHNOLOGY
PROJECT FILE
2025-2026
NAME : ELHAM YOUSUF
CLASS : X
BONAFIDE CERTIFICATE
CERTIFIED TO BE THE BONAFIDE WORK DONE BY
Elham Yousuf of class X
in the Computer lab during the year 2025 - 2026
Date : 23.08.2025 P.G.T in Computer Science
Mrs. Deepa Mary Albert
CARMEL SCHOOL
Khaitan, Kuwait
Submitted for ALL INDIA SECONDARY SCHOOL Practical
Examination held in Computer Lab at The Carmel School, Khaitan, Kuwait
Date :………………….. Examiner
Seal
STUDENT REPORT CARD GENERATION
INDEX
S NO. TOPIC PAGE NO.
1. STEPS OF TABLE CREATION
2. STEPS OF DATA ENTRY
3. STEPS OF SETTING TABLE
RELATIONSHIP
4. STEPS OF QUERY CREATION
5. STEPS OF FORM CREATION
6. STEPS OF REPORT CREATION
INTRODUCTION
In any educational institution, maintaining accurate and efficient student records is essential
for tracking academic performance, managing grades, and generating reports. Traditional
manual methods are time-consuming, prone to errors, and inefficient when handling a large
number of students. To address these issues, the Student Report Generation Database
system has been developed.
This system is designed to automate the process of storing student information, recording marks,
calculating results, and generating comprehensive reports. It allows administrators and
faculty members to easily input, update, and retrieve data, ensuring consistency, accuracy,
and speed in report generation. The database supports essential functionalities such as student
registration, subject-wise marks entry, grade calculation, and report generation in a structured
format.
By implementing this system, educational institutions can streamline their academic
workflows, reduce administrative burden, and enhance the overall quality of data management
and communication. This project aims to demonstrate how database technologies can be
effectively used to solve real-world problems in the education sector.
STEPS FOR CREATING A TABLE.
STEP 1: Click on create table in design view.
STEP 2: Enter the field name and data type of the field created by selecting the
appropriate type available under field type dropdown list.
STEP 3: After entering the feild name, click on the cross, a dialog box will appear, specify
the fieldname.
STEP 4: You will notice that the table has been created. Repeat the same experiment and
create another table person.
ENTERING DATA IN A TABLE
STEP 1: To insert data in the table, Select the table and double click on it.
STEP 2: The table will open in datasheet view.
STEP 3: Enter the data and close the tab and enter the data in another table.
SETTING A RELATIONSHIP
STEP 1: You can create a relation between 2 tables by selecting
relationships option from the tool’s menu
STEP 2: Add the tables in amongst which you want to create
the relationship. Select the tables and click on Add button
STEP 3: Form a relation between the 2 table either one to one,
one to many, many to many
STEP 4: Click save and Close the tab
STEPS FOR CREATING A QUERY
USING WIZARD
STEP 1: In database design window,click on queries button present in the database pane on the left.
STEP 2:In the task area ,click on wizard to create query…option.The query wizard will start .
STEP 3: select field from the respective tables.
STEP 4:Click on the next button will display the screen to select the sorting order.
STEP 5:Set the search critteria on the basis of which record will be filtered from the table .
STEP 6:To give the alias name that is the coloumn header name will be displayed when we run
the query .
STEP 7: It shows the entire overview of the query created till now.
USING DESIGN VIEW
STEP 1: click on queries icon on the object pane in the database window
STEP 2: Click CREATE QUERY IN DESIGN VIEW…….icon in the task pane.the Query Design Window
appears.In the middle of the window the Add table or Query dialog box appears
STEP 3:Click on the table to be used in the query and then click on add.Click close button in the Add table
or query dialog box.
STEP 4: Select the fields. The field name along with the table name is displayed in the Design Grid present in
the lower half of the Query Design Window.
STEP 5: Once the query is designed click Run Query button on the toolbar or press F5 key. The Query result
will be displayed.
CREATING FORMS AND ENTERING DATA IN FORMS
STEP 1: Click use wizard to create form option under tasks group. The form wizard dialog
box appears
STEP 2: You can select selective fields to be sent onto the form by selecting the field name
and clicking > button. You can select individual fields in a database or all fields in a database
STEP 3: To use all the fields in the table in a form, click the >> button
STEP 4: Click next >. You can see the setup a sub form step dialog box of the wizard
STEP 5: You can select the option Add Sub form if you need to insert the contents in the table
in a separate form
STEP 6: Add a new record in both the forms and notice the change in the main table.
CREATE REPORTS AND DISPLAY
STEP 1: Click on REPORTS section under Database in the OpenOffice base application
STEP 2: Once you select the option, you should see a window similar to the one displayed below
STEP 3: Click one USE WIZARD TO CREATE REPORT option available under Tasks.
STEP 4: Once you select the Use Wizard to Create Report option you should see a window
similar to one displayed below
STEP 5: You have to select all the table field by selecting the >> you should see a dialog box
similar to the one displayed below
STEP 6: Click NEXT > and go to the last option and click on Finish
STEP 7: A window will appear with the data
