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

