SERIAL NO. TABLE OF CONTENT PAGE NO.
1 INTRODUCTION 1
2 SCHOOL NAME DBMS 2&3
RELATIONAL
3 DATABASE 4&5
4 FORM IN DATABASE 6&7
5 DOCUMENTATION 8&9
6 CONCLUSION 10
7 LIST OF SOURCES 11
8 ACKNOWLEDGEMENT 12
9 BIBLIOGRAPHY 13
INTRODUCTION
IN THIS I.T PROJECT FILE WE ARE GOING TO
LEARN VARIOUS THINGS ABOUT HOW TO USE
DIFFERENT FUNCTION IN OPEN OFFICE
DATABASE .
THIS PROJECT GIVE US CHANCE TO WORK ON
DIFFERENT FUNTION IN DATABASE FOR EG-
PRIMARY KEY,TABLE ETC.
CREATE DATABASE USING SCHOOL
NAME
Open OpenOffice Base:
.
• Open OpenOffice Base from the Start Menu or application
list.
• Create a New Database:
• Once OpenOffice Base is open, click on the "New
Database" option.
• Database Wizard:
• The Database Wizard will appear, guiding you through the
process of creating a new database.
• Choose "Create a new database" and click Next.
• Save the Database:
• In the next window, you will be asked where you want to
save the database.
• Choose the location on your computer where you'd like to
save the database file.
• Name the database file Divine_Sainik_School (or simply
Divine Sainik School depending on your preference).
• Once you've named it, click Save
CREATE RELATIONAL DATABASE
USING MULTIPLE TABLES
TO MAKE RELATIONAL DATABASE FOLLOW THE
GIVEN STEPS:
✗ MAKE SOME TABLE BEFORE SETTING UP RELATION.
✗ GO TO TOOLS OPTION AND THEN RELATIONSHIP OPTION.
✗ NOW SELECT THE ANY TWO TABLE WHICH YOU
MAKED PRVIOUSLY.
✗ AND CLICK ON ADD OPTION.
✗ NOW SELECT THE SAME FIELD IN BOTH TABLES AND
CONNECT THEM USING MOUSE.
✗ THEN CLICK ON RELATIONSHIP.
✗ THEN IN RELATION DIALOG BOX SELECT “UPDATE
CASCADE” OPTION.
✗ THEN CLICK ON “OK” OPTION.
CREATING FORM TO DO THE
ENTRY IN TABLE
➔FOLLOW THE FOLLOWING STEPS:
➔ In the Tables section, click Create Table in Design View.
➔ Add fields to your table, specifying the Field Name, Field Type (e.g.,
Text, Integer, Date), and Primary Key (if necessary).
➔ Once you’ve defined the fields, click Save. Enter a name for the table
(e.g., Contacts) and click OK.
-Create a Form
Now that you have a table, you can create a form to input data into the table.
1. Open OpenOffice Base.
2. In the left panel, select the database (if not already open).
3. Click on Forms in the left-hand panel.
4. Click the Use Wizard to Create Form button (or Create Form in Design
View, but the Wizard is simpler).
5. The Form Wizard will guide you through several steps:
• Step 1: Select the Table
Choose the table you want to create the form for (e.g., Contacts).
• Step 2: Select Fields
Select the fields you want to appear in the form. You can choose all
or specific fields (e.g., Name, Address, Phone number).
• Step 3: Layout
Choose the form layout you prefer (e.g., Columnar, Tabular, etc.).
• Step 4: Modify Appearance
Select the desired style for your form (e.g., Classic, Modern).
• Step 5: Form Title
Give your form a title (e.g., "Contact Entry Form").
6. After completing the wizard, click Finish. The form will open in Form
Design View where you can tweak the design.
DOCUMENTATION OF ALL
PROCESS PRESENTED IN
PROJECT
➢ In this project we have used database
and writer. In the database we created
database with the name of our school and
creating it into table after and process of
saving it continues after it. Then in 2nd
project by using wizard we created two
table and setting relationship between
them,
using this when we change something in
field of 1st table then the same change is
done in
2nd field [Link] created form to do the entry
in the table using form option in left pannel
and using wizard option in writer.
CONCLUSION
In this project, we successfully leveraged the capabilities of OpenOffice
Writer, Calc, and Base to create a cohesive and functional suite of tools
for document creation, data analysis, and database management.
Throughout this journey, we have gained a comprehensive
understanding of the various functions and features offered by
OpenOffice applications.
Using OpenOffice Writer, we developed skills in crafting well-structured
documents, applying formatting techniques, and utilizing templates to
enhance our writing. This experience not only improved our document
presentation but also emphasized the importance of clarity and
organization in communication.
With OpenOffice Base, we gained valuable insights into database
management. We learned to design tables, establish relationships, and
execute queries to retrieve and analyze data efficiently. This experience
highlighted the importance of structured data management and the
role it plays in informed decision-making.
Overall, this project has not only enhanced our technical proficiency in
using OpenOffice applications but also demonstrated the practical
applications of these tools in real-world scenarios. The knowledge and
skills acquired will undoubtedly serve us well in future academic and
professional endeavors, empowering us to handle various tasks with
confidence and efficiency.
LIST OF SOURCES
➔ REFERENCE BOOK
➔ I.T NOTES
➔ BOOK BY SUMITA ARORA
➔ OPEN OFFICE FOR IMAGES
➔ EDITING FROM MICROSOFT 365
ACKNOWLEDGEMENT
I would like to express my sincere gratitude
to everyone who has contributed to the
completion of this project.
First and foremost, I want to thank my
teacher Deepak sir for their continuous
guidance, encouragement, and expertise. I
am grateful for the knowledge and skills I
have gained under their mentorship.
I would also like to extend my gratitude to
myself who have been working hard to
complete this project.
I am grateful to my parents for their
unwavering support and belief in my
abilities.
BIBLIOGRAPHY
FOR SUCCESSFULLY COMPLETING MY
PROJECT FILE. I HAVE TAKEN HELP FROM THE
FOLLOWING WEBSITE LINKS AND SOURCES:
REFERENCE BOOK
IT BOOK
GOOGLE (GEMINI)
IT NOTES
