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
   422   423   424   425   426   427   428   429   430   431   432