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
   276   277   278   279   280   281   282   283   284   285   286