Page 321 - IT_V1.0_Class10
P. 321
21 st
PROJECT-4 Century #Technology Literacy
Skills
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 : BILLDETAILS Table Name : STATE
Field Name Data Type Field Name Data Type Field Name Data Type
CustID Number[NUMERIC] CustID Number[NUMERIC] StateID Number[NUMERIC]
CName Text[VARCHAR] Quotation Number[NUMERIC] StateName Text[VARCHAR]
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]
Forms/Query/Relationship:
Set relation between tables:
o CustID field of CUSTOMER table to CustID field of BILLDETAILS table.
o StateID field of CUSTOMER table to StateID field of STATE table.
Create a query in Design View that will display the records of the customer along with the State name 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.
PROJECT-5
21 st
Follow the given instruction to complete the project: Century #Technology Literacy
Skills
The following table shows the members of a community centre.
Number Last_Name First_Name DOB Member_Type Payment
001 Singh Ashish 03/04/77 Senior Y
002 Mirza Gautam 16/06/92 Junior N
003 Chouhan Kunal 02/11/85 Senior N
004 Sharma Rahul 06/07/74 Senior Y
005 Bhagat Manish 12/10/89 Junior Y
Create a query in Design View for community centre that wants to find the members according to the
following criteria:
Member_Type is not ‘Senior’ and Payment is ‘N’.
Member_Type is not ‘Senior’ and Payment is ‘Y’.
Member_Type is not ‘Junior’ and Payment is ‘Y’.
Member_Type is not ‘Junior’ and Payment is ‘N’.
Project Work 319

