Page 321 - TP_IT_V1.0_C10_flipbpookl
P. 321
The Sort Ascending and Sort Descending button sorts the data by one criterion only. LibreOffice Base allows you to
combine several criteria by selecting Sort icon on the toolbar. The Sort Order dialog can be used to do the required
changes, perform the following step for the same:
Step 1: Click on the Sort icon ( ) on the toolbar.
The Sort Order dialog box opens, as shown below:
Step 2: Select the Field name and Order from the drop-down list.
Step 3: Click on the OK button.
If you wish to sort one field within another field, then use Sort Order -Then.
For example, if the Name is stored as Name and Address, then we can sort Address within Name by specifying:
Sort Order- Field Name = Name, Order = Ascending
Then - Field Name = Phone No., Order = Descending
1. Your neighbourer—Amit has a flower shop. He maintained the details of his customers
personal information, order details and stock details manually. Now he wants to maintain
uiz Bee them in a computer using a database. Help him create a Database with the appropriate 3
tables.
▪ Give a name to the database.
▪ Design the fields and their data types of all the three tables-customers personal
information, order details and stock details.
▪ Name the primary keys of all the three tables.
2. Save the above created table without creating a Primary key. Double click on the STUDENT
table tab and try to enter a few records. Are you able to create records without making a
primary key? Also if you wish to make Adm No now as a primary key are you able to edit
the already created table structure? Give steps to do so.
Database Management System using LibreOffice Base 319

