Page 432 - TP_IT_V1.0_C10_flipbpookl
P. 432

Consider your 3 friends as representatives of Company A, B and C, respectively. Share the worksheet with
                     your friends to update the selling data of Dairy Products in New Delhi by their company.
              3.  Follow the given instruction to complete the project in LibreOffice:
                     Create a Macro that performs 'Paste Special' with Add and Subtract.
                     Create your own Macro function to return the number 10.
                     Create a Macro to sort the following data: 10, 8, 15, 6.

                                                                 10

                                                                  8

                                                                 15

                                                                  6

              DATABASE MANAGEMENT SYSTEM

              1.   Bharat Associates Pvt. Ltd. wants to design a database which can store the details of its Customers and make
                  their billing details. The table name and its structure are as follows:

                             Table Name : CUSTOMER                            Table Name : BILL DETAILS

                        Field Name             Data Type                 Field Name             Data Type
                   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]
                   CreditLimit           Number[NUMERIC]



                                                 Table Name              STATE
                                             Field Name           Data Type

                                             StateID              Number[NUMERIC]
                                             StateName            Text[VARCHAR]

              Forms/Query/Relationship:

                  Set Relation Between Tables (CustID - Customer To BillDetails and StateID – Customer To State).
                 Generate a query that will display the records of Customer Table along with Statename and Billing details of the
                customer. The query should calculate the balance amount of the customer.
                 Design a Form to display the customer details.
                 Update any CustID in CUSTOMER table and verify if the same gets updated in BILLDETAILS table.


                430   Trackpad Information Technology (Ver. 1.0)-X
   427   428   429   430   431   432   433   434   435   436   437