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
   87   88   89   90   91   92   93   94   95   96   97