CENTRAL BOARD OF SECONDARY EDUCATION
NARAYANA e-TECHNO
SCHOOL
ADUR, BANGALORE
"STAFF MANAGEMENT" PROJECT REPORT FILE IS SUBMITTED TO
DEPARTMENT OF INFORMATION TECHNOLOGY FOR THE PARTIAL
FULFILLMENT OF AISSE EXAMINATION SESSION 2024-2025
SUBMITTED BY:
ADMISSION NO:
HOD(COMPUTER): [Link].L.N
CLASS: X ‘A’
ACKNOWLEDGMENT
I wish to express my deep sense of gratitude and indebt-
edness to our learned teacher Mrs. Kavitha ma'am, PGT
COMPUTER SCIENCE, Narayana E-Techno BLR-ADUR,
for her invaluable help, advice, and guidance in the
preparation of this project.
I am also greatly indebted to our principal Mr. Biswambar
Das sir and our Academic Dean Mr. Pavan Sir and school au-
thorities for providing me with the facilities and requisite labo-
ratory conditions for making this practical file.
I also extend my thanks to a number of teachers, my class-
mates and friends who helped me to complete this project re-
port file successfully.
NARAYANA e-TECHNO SCHOOL
This is to certify that ________________________ of
class ___ has successfully completed the Information
Technology 402 project on the topic Staff Management
under the guidance of Mrs. [Link] during the aca-
demic year 2024-25.
Date:
Internal Examiner Principal
Signature: Seal and Signature
INDEX
Table of Contents
ABSTRACT........................................................................................................... 5
Introduction........................................................................................................ 6
OBJECTIVES AND SCOPE OF THE PROJECT..........................................................7
SOFTWARE AND HARDWARE SPECIFICATION.....................................................8
LIBREOFFICE....................................................................................................... 9
DATABASE MANAGEMENT SYSTEM..................................................................10
Main Components of Staff Management System.............................................11
Opening LibreOffice Base................................................................................. 12
Creating a Table................................................................................................ 13
Creating a Form................................................................................................15
Creating a Report............................................................................................. 19
ABSTRACT
The project title "STAFF MANAGEMENT SYSTEM"
is a Libre Office Base application used to maintain the
details of the staff.
It allows the administrator to enter staff’s details.
This project contains one module, staff table. Staff table
is used for adding and maintaining records of their details
like emp_id, designation, etc.
I have taken case study for the organisation to maintain
the details in an organized way. I have also selected table
to do this project as I mentioned above.
Introduction
The impact of computers and internet, on our lives today is prob-
ably much more than we really know. Getting information and
quickly turning it into a product that consumers want is an essen-
tial key to staying in business and all of this is done nowadays us-
ing computers and applications or information systems. And the
information systems will continue to change businesses and the
way we live. Many corporate leaders are using technology to
manage every aspect of their organization, from product creation
to customer service. It has brought evolution in almost event
field, it changed the ways of teaching, administration of activities
such as e-learning, e-library and online portals where teachers
and students communicate and sharing of information has never
been better.
Staff management are amongst the most important activities
within a School or any organisation, since all other activities de-
pend on it. Hence implementing an information system can be
declared a significance result.
OBJECTIVES AND SCOPE
OF THE PROJECT
The main objective of Staff Management Project
is to enhance and automatic the management
and maintaining the staff info using a computer-
ized system. It provides the easy retrieval of staff
data for an organisation in simple manner.
SOFTWARE AND
HARDWARE
SPECIFICATION
HARDWARE:
➢ Processor: 12th Gen Intel Core i7-12700 2.11 GHz
➢ RAM: 64 GB
➢ System Type: 64-bi OS, x64-based processor.
Software:
At least 65 MB available disk space for a default install
(including a JRE) via download. After installation and
deletion of temporary installation files.
Operating System(OS): Microsoft Windows
LIBREOFFICE
LibreOffice is a free and open-source office productivity software suite, a
project of The Document Foundation (TDF). It was forked in 2010
from [Link], an open-sourced version of the earlier StarOffice. It
consists of programs for word processing; creating and editing spread-
sheets, sideshows, diagrams, and drawings; working with databases; and
composing mathematical formulae. It is available in 120 languages.
LibreOffice uses the OpenDocument standard as its native file format
but supports formats of most other major office suites, includ-
ing Microsoft Office, through a variety of import and export filters. It is
available for a variety of computing platforms, with official support
for Microsoft Windows, macOS, and Linux,[13] and community builds for
many other platforms.
LibreOffice Online is an online office suite that includes the applications
Writer, Calc, and Impress, and provides an upstream for projects such as
commercial Collabora Online. It is the most actively developed free and
open-source office suite, with approximately 50 times the development
activity of Apache OpenOffice, the other major descendant of
[Link], in 2015.
The project was announced, and a beta was released on September 28,
2010. LibreOffice was downloaded about 7.5 million times between Janu-
ary 2011 (the first stable release) and October 2011.[19] The project
claimed 120 million unique downloading addresses from May 2011 to
May 2015 (excluding Linux distributions), with 55 million of those from
May 2014 to May 2015.[20] The Document Foundation estimates that
there are 200 million active LibreOffice users worldwide, about 25% of
whom are students and 10% are Linux users
DATABASE
MANAGEMENT SYSTEM
DATABASE
A database is a collection of data, which is stored in a systematic manner,
i.e., in the form of tables so that you can retrieve and manipulate the data
quickly from a large set of data. A database consists of one or more tables.
A table holds information in the fom of rows and columns. Some of the
database programs such as Microsoft Access, [Link] Base, and
MySQL. These database programs are used to store related information
and perform various operations as per user needs in the computer system.
DATABASE MANAGEMENT SYSTEM (DBMS)
A database management system is a software package that enables
you to create, store, modify, update and extract information based on
user conditions. It allows different user application programs to access
the same database, concurrently. The main function of DBMS is to
provide the users with efficient and reliable methods of data storage,
modification and retrieval. Some of the DBMSs are Oracle, IBM DB2,
Microsoft SQL server, Microsoft Access, PostgreSQL, MySQL, FoxPro
and SQLite. Some of the DBMS applications are Inventory, Payroll, re-
servation, invoicing, medical records etc.
Main components of
staff management
system
The Staff Management System will have the following components:
1) Employee Table: The table will store the data of staff information.
2) Form: Form is created to input the records in the table.
3) Query: Various types of query will be performed on the table.
4) Report: Report of each class will be generated.
Opening LibreOffice Base
Step 1: Opening Libre Office Base Database.
Step 2: Click on Base Database choose the location to
save and give a name for file.
Step 3: Click on save button.
Creating a Table
Step 1: Click on Create table in Design View.
Step 2: While creating Table Primary Key is must for
any one of the column.
PRIMARY KEY: A Primary key is a field that uniquely identifies
each record in a table it does not contain at duplicate data. The
value in the primary key field is different for each record.
Step 3: Give field name and Suitable Field type and
create a table.
Step 4: Now, Save your table.
Step 5: Table is created under the table's column.
Step 6: Enter the Data in your table based on the
Field name and Type.
Step 7: Preview of Table.
Creating a Form
FORM: A form provides the user a systematic way of storing in-
formation into the database. It is an interface in a user specified
layout that lets users to view, enter and change data directly in
database objects such as tables.
Adding new Record:
Click on New Record button on the FORM NAVIGATION Tool
bar.
Enter the required information in blank fields. Click on the
save button on the Form Navigation too bar.
Removing a Record:
Select the record that you wish to remove. Click on Delete Re
cord button on the Form Navigation Tool bar.
Step 1: Creating form using Wizard method.
Step 2: Now, finish all 8 steps to create Form.
Step 3: Select the fields which you want to create
form and move the selected fields to Right-side Using
> (single arrow button).
Step 4: Arrange the Controls.
Step 5: Apply Styles.
Step 6: Set the name for Frames.
Step 7: Click on FINISH button.
Step 8: Below is the Preview of the Form Page.
Creating a Report
Report:
A Report helps to display the data in a summarized manner.
It is an effective way to organize the data for viewing and
printing.
Reports helps to get the summarized data. To create report in
Base, the table must be selected from using which data can
be displayed in a format as required.
Step 1: Creating report using Wizard.
Step 2: Now, Finish all 6 steps to create Report.
Step 3: Select the fields to create Report and move the selec-
ted fields to Right-side Using> (single arrow button)
Step 5: We can sort the fields as Ascending or Des-
cending Order using Sort by Option.
Step 6:
Choose the
Layout.
Step 7: Set the Name for Report. Click on Finish.
Step 8: Preview of the Report.
Thank You