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

