Page 92 - ModularV1.1 _c8_flipbook
P. 92
Table: Suppliers
SupplierID SupplierName SupplierAddress SupplierContact
After creating both the tables, perform the following steps:
• Create relationship between both the tables.
• Create a query to extract the following details:
SupplierID SupplierName PartNo PartName PartUnit
Project 4
Create the following table in MS Access:
StudentID StudentName City State Pincode Country
Create a form to enter the records in the preceding table.
Project 5
Design the following form in MS Access and create a table for the form:
Create a report by using the table created in the Project 5.
Python
Project 6
Write a program to input the basic salary of an employee and calculate the net salary based on
the criteria given below:
Net salary = basic salary + incentive
Incentive = 7 % of the basic salary
90 Modular (Ver. 1.1)-VIII

