Page 281 - Trackpad 402_Class-X_Final
P. 281
To sort in the descending order, click on Sort Descending. The data will be rearranged in the descending
order of the Name.
Try sorting data using sort icon . It will open a Sort Order dialog box as shown below:
Select the Field name, Order from the drop-down list and click on 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 First Name and Last
Name then we can sort Last Name within First Name by specifying:
Sort Order- Field Name = First Name, Order - Ascending
Then - Field Name = Last Name, Order - Ascending
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 281

