procedure:
Step 1 – Open Libre Office Base Application → Office → LibreOffice Base.
Step 2 – Create a new database Database wizard → Create a New Database → Next → Yes register the database for me → Open the database for editing Finish.
Step 3 – In Save Dialogue box, give the name STUDENT FEE and select a location to save the database and click Save button. The new database le STUDENT FEE.odb. is created
Step 4 – Create Data Tables From the left Database Pane, click on the icon Tables and below the Tasks section, click on ‘Create Table in Design view’ Database Pane → Tables → Create Table in Design view
Step 5 – Field Name Entry In Table creation Screen, Enter the Field names and select appropriate Data Types as given below.
Field Name |
Data Type |
Admn No. |
Number (Numeric) |
Name of student |
Text (VARCHAR) |
Class |
Text (VARCHAR) |
Admission date |
Date (DATE) |
Fee paid |
Number (Numeric) |
Step 6 – Setting Primary Key To set the Admn No. as the Primary key, Right click on the row selector of Admn No. and select the Primary key from the drop down menu
Step 7 – Save Table Click on Save button (or press Ctrl+S) to save the table. In save as dialogue box, Enter Tblstuderrts as table name and click on OK button Close the table creation screen
Step 8 – Data Entry Database Pane → Tables → Created Tables → Select Tbl students → Double click to open it Enter all the data given one by one
Output :
Admin No |
Name of student |
Class |
Admission Date |
Fee paid |
6847 |
Arya |
Science |
11/6/2013 |
480 |
6848 |
Aneesha |
Commerce |
13/6/2013 |
430 |
6849 |
Arun |
Science |
22/6/2018 |
480 |
6850 |
Akhil |
Commerce |
24/6/2018 |
430 |
6851 |
Athulya |
Humanities |
6/7/2018 |
360 |