Page 157 - iPrime_V2.2_class7
P. 157

PROJECT







                                                                                                                       https://www


                                                                                                      Subject Enrichment
                 EXCEL

                          ✶ Rajat has created a list of the students who are a part of the school cricket team.


                                                                                                                       https://www

















                           ✶ Now, he wants to add a column titled ‘Designation’ between Name of the student and
                          Runs scored in columns to put categories as Batsman, Bowler, All Rounder or Wicket
                          Keeper.
                          ✶ Vikas and Nitin have resigned from the team. He has to remove the details of these
                          students from the list.
                          ✶ Change the width of the column Designation to 20.

                          ✶ Find ‘Total Runs Scored’ and ‘Average Runs Scored’ by each student using formulas.

                 ACCESS
                                                                                                     Subject Enrichment
                 Project 1


                 Create three tables in Access as under:
                                                          Table: Purchases

                         Item_ID            Quantity Purchased           Rate per unit               Amount

                                                            Table: Sales
                         Item_ID               Quantity Sold             Rate per unit               Amount


                                                       Table: Stock in Hand
                           Item_ID                     Item Name               Quantity in Hand at the beginning

                          ✶ Make 5 entries in each table.
                          ✶ Create a query to calculate the Quantity in Hand at the end for all the items.


                                                                                                        Project    155
   152   153   154   155   156   157   158   159   160   161   162