Page 225 - IT_V1.0_Class10
P. 225
Notes
To store monetary values and support various currency formats, you need to select the field as a numeric
data type and then click on the Format Field button in the Filed Properties section. This will open the Filed
Format dialog box, where you can specify the desired currency format. For example, $1000, or ₹500.00.
To set the primary key for the table:
Step 5: Position the mouse pointer on the field which you want
to be set as primary key.
Step 6: Right-click the field. A context menu appears. 6
Step 7: Select the Primary Key option from the context menu.
7
A key-like symbol appears in front of selected field
indicating that the column will now considered as a primary key.
Step 8: Click on the Save button in the Standard toolbar. The Save As dialog box appears on the screen.
Step 9: Type the name of the table in the Table Name text box.
Step 10: Click on the OK button. A table with the given name is created.
8
9
10
Step 11: Click on the Close button in the Table Design window. The created database is displayed in the
Tables pane in the LibreOffice Base window.
21 st
Lab Assignment ‘n Activity Century #Technology Literacy
#Information Literacy
Skills
Complete the following activities and tick the circle.
Create a Table namely ‘STUDENT’ using Design View with the following fields:
Field Name Field Type Field Name Field Type
Stu_ID Numeric Marks_Eng Numeric
Stu_Name Text Marks_Hindi Numeric
DOB Date Marks_Maths Numeric
Set Stu_ID as Primary Key.
Set the field properties as:
(a) Width of Stu_Name as 40 characters.
(b) Set required property as ‘Yes’ for Stu_Name.
Starting with LibreOffice Base 223

