1
Project
FILE
STUDENT’S RESULT MANAGEMENT SYSTEM
INFORMATION
TECNOLOGY
(Code – 402)
CLASS 10
Session 2025-26
ST. PETER’S CONVENT SCHOOL
(FARIDABAD)
1|Page
2
STUDENT deTAIL
Name of the student - Dev Vij
Class - 10 c
Roll no – 11
SUBJECT – Information technology (402)
School name – st. peter’s convent school,
Faridabad, Haryana
Page 2 of 34
3
Acknowledgement
I would like to express my special thanks of gratitude to my teacher Mrs.
Jyoti Saini as well as our Sister Principal, who gave me the golden
opportunity to do this wonderful project on the topic entitled 'STUDENT'S
RESULT MANAGEMENT SYSTEM', which also helped me in doing a lot of
Research and I came to know about so many new things.
Dev Vij
Class – X C
Page 3 of 34
4
[Link] of the Project
The influence of technology and the internet on modern life is far reaching and
continues to grow each day. From communication to commerce, technology has
revolutionized how we work, learn, and interact. Information today travels at
lightning speed, allowing businesses and individuals to make quick and effective
decisions. Computers and information systems have become the backbone of
almost every organization, simplifying complex processes and increasing efficiency.
In the field of education, technology has transformed traditional methods through
e-learning platforms, digital libraries, and online classrooms, creating a more
interactive and accessible learning environment.
Managing and declaring student results, one of the most crucial functions of any
educational institution, has also been streamlined through computerized systems.
Thus, implementing information systems not only enhances accuracy and
transparency but also marks a significant step toward modernization and better
academic management.
Page 4 of 34
5
2. Objectives and Scope of the
Project
LibreOffice Base Project: Student Result Management System
The project aims to simplify and automate student result management by providing
a secure platform for data entry, calculation, storage, and retrieval of academic
results. Additionally, it offers data analytics for performance insights and integrates
easily with other academic systems, ensuring efficient, accurate, and accessible
result management.
[Link] Components of Students
Management System
The Student Result Management System will have the following components.
• Marks Table:- This table will store the results of the students of each class.
• Student's Details Table:-This table will store the address and contact details of
all the students of a school.
• Relationship: Both the tables (Marks_Table and Student's Details) will be
linked to each other using Relationships.\
• Form: Form is created to input the records in the table.
Page 5 of 34
6
• Query: Various types of Queries will be performed on the table according to
the requirements.
• Report: Report of each class will be generated.
3.1 Creating a Database
3.2 Creating Tables
Perform the steps for creating Student Contact table.
• Step 1:- Open School Result Management System Database by click on file
men open option and locate School Result Management [Link] file.
• Step 2:- Click on Tables tab, Click on the Create table in Design View option
under the Tasks pane.
• Step 3:- A blank table opens in the Design View, type the field names and
data types as shown.
Page 6 of 34
7
• Step 4:- Set Admn_No as primary key.
• Step 5:- Click on Save button from standard toolbar, Save As dialog box will
open, save the table as Student Details table.
Page 7 of 34
8
Perform the steps for creating Marks Table.
• Step 1:- Open School Result Management System Database by click on
file men open option and locate School Result Management [Link]
file.
• Step 2:- Click on Tables tab, Click on the Create table in Design View
option under the Tasks pane.
• Step 3:- A blank table opens in the Design View, type the field names
and data types as shown.
• Step 4:- Set Admn_No as primary key.
• Step 5:- Click on Save button from standard toolbar, Save As dialog box
will open, save the table as Marks Table.
Page 8 of 34
9
Page 9 of 34
10
Page 10 of 34
11
3.3 Inserting Data in the table
3.4 Creating a Relationship between Tables
Page 11 of 34
12
Perform the steps for create the Relationships between both tables.
Step 1:- Click on the Relationships option in the Tools menu. Add Table
dialog box will appear.
Step 2 :- Add the tables in amongst which you want to create the
relationship. Select the tables and click on Add button.
Page 12 of 34
13
Step 3:- Drag the primary key column from one table and drop it on the key
column of another table.
Page 13 of 34
14
3.5 Creating Queries
Perform the steps to create a Query
Step 1:- Click on the Query option in the database pane
Step 2:- Click on the Create Query in Design view option under the tasks
pane.
Page 14 of 34
15
Step 3 :- Add the tables Dialog box will appear. Select the tables and click on
Add button.
Step 4 :- Select desired Field and Criterion and ‘Run’ Query.
Page 15 of 34
16
Step 5 :- ‘Run’ Query. Or Press F5
Displaying Records of those students who are got more than 85
Marks in Mathematics subject.
Page 16 of 34
17
Displaying Records of those students who are got less
than 80 Marks in Information Technology subject .
3.6 Creating a Form and Insert the records in a Table
Page 17 of 34
18
1. Click on Forms Use Wizard to Create Form…
2. A Form Wizard appears.
3. Select the table from Tables or Queries then add all the fields.
4. Click on Next button. Ignore step 3 and step 4.
[Link] the first option i.e. Columnar – Labels Left then click on the next
button.
6. Now set data entry step will be there. Ignore this step and click on Next.
Choose the styles for the form interface and click on next.
7. Type new name for the form and click on work with the form. Click on
Finish
Creating form for Student’s Details:
Page 18 of 34
19
Page 19 of 34
20
Page 20 of 34
21
Page 21 of 34
22
Insert record in the form and save it.
Page 22 of 34
23
Page 23 of 34
24
Creating form for Marks Table:
Page 24 of 34
25
Page 25 of 34
26
Page 26 of 34
27
Page 27 of 34
28
3.7 Creating Reports
Page 28 of 34
29
Perform the steps for create the Report
Step 1:- Click on the Report option in the database pane
Step 2:- Click on the use Wizard to create report option under the tasks
pane. The report wizard will appear.
Step 3:- Select desire query under the tables or queries option.
Page 29 of 34
30
Step 4:- Select the entire field in this step and specify the field labels in the
next step.
Page 30 of 34
31
Step 5:- Click on the Next button to move on to the next step.
Step 6:-Specify a title for the report and click on the finish button.
Page 31 of 34
32
Page 32 of 34
33
Page 33 of 34
34
Step 7:- The report will be created and will appear.
Page 34 of 34