Page 427 - IT 402 v2.0 class 10
P. 427
PROJECT-3
Comp utational th ink ing
Follo t e gi en instruction to com lete t e ro ect in en ce:
Create a Macro that performs 'Paste Special' with Add and Subtract.
Create your own Macro function to return the number 10.
reate a Macro to sort the following data: 5 .
10
8
15
6
PROJECT-4 S ub j e ct E nr ich me nt
Bharat Associates Pvt. Ltd. wants to design a database which can store the details of its Customers and
ma e t eir illing details T e ta le name and its structure are as follo s:
Ta le ame : ST M Ta le ame : I T I S
Field Name Data Type Field Name DataType
CustId Number[NUMERIC] CustID Number[NUMERIC]
CName Text[VARCHAR] Quotation Number[NUMERIC]
Add1 Text[VARCHAR] Challan Number[NUMERIC]
STATEID Number[NUMERIC] Bill Number[NUMERIC]
Phone Number[NUMERIC] Amount_Billed Number[NUMERIC]
Mobile Number[NUMERIC] Amount_Paid Number[NUMERIC]
ContactPerson Text[VARCHAR]
redit imit Number[NUMERIC]
Table Name : STATE
Field Name Data Type
StateID Number[NUMERIC]
StateName Text[VARCHAR]
Forms uer elations i :
Set Relation Between Tables (CustID - Customer To BillDetails and StateID – Customer To State).
Projects 425

