Display the names of students who scored greater than or equal to 500. Display the name of student whose name begin with ‘S’

Question

Enter the following data in a database table

Roll No.	Name	Sex	Mark
48	Aristo	M	521
49	Shabu	M	500
50	Shaly	F	428
51	Chintha	F	410
52	Saji	M	565
53	Leena	F	498

• Display the names of students who scored greater than or equal to 500. 
• Display the name of student whose name begin with ‘S’

Answer 1

Procedure: 

Step 1 – Open LibreOffice Base Application → Office → LibreOffice Base 

Step 2 – Create New Database Datebase wizard → Create New Data base Next Yes, register the database form → Open the database for editing → Finish 

Step 3 – In Save dialogue box, give the name STUDENTMARK and select the location to Save the data base and click Save button, the new data base le STUDENTMARK.odb. is created. 

Step 4 – Create Data Table 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 Tables in Design view 

Step 5 – Filed Name Entry In Table creation Screen, Enter the Field names and select appropriate Data Types as given below

Step 6 – Setting Primary Key To set STUDROLL_NO as primary key Right click → Select 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 TBLSTUDENTDETAILS as the name and **** on OK Button Close the Table creation screen. 

Step 8 – Data Entry 

Data base pane → Tables → Created Tables → Select TBLSTUDENTDETAILS → Double click to open it Enter all the data on by one 

Step 9 – Create Query

• From the Data base Pane, Click on Queries button and in the right side under Task section, Click on Create Query in Design view. Now Add Table or Query Window opens. 
• Select the table TBLSTUDENTDETAILS and click Add button, then close the window. 
• In the Query Design window, double click on each Field in Table window to add all the fields to query design grid.

Step 10 – Enter Query Criteria (Question 1) In Query design Grid, set the Criteria for the query. 

• Enter >=500, in the Criterion row in STUDMARK column. 
• Click on the RUN Query Button or Press F5 to display the result. Save and close the query. File → Save. 
• ‘Save as’ window opens. Give the name Query 1 and click on OK button.

 Step 11 – Enter the Query Criteria (Question 2) 

In the Query design grid, set the criteria for the query 

a) Enter LIKE ‘S*’, in the criterion row in STUDNAME column. 

b) Click on the Run Query Button or Press F5 to display the result. 

c) Save and close the query. 

File → Save. ‘Save as’ window opens. Give the name ‘Query 2’ and click on OK button. 

Output – 1

Output – 2