Page 91 - ModularV1.1 _c8_flipbook
P. 91

PROJECT WORK





                                                                                                      Subject Enrichment




                 MS Access
                 Project 1

                 Create three tables in MS Access as under:

                                                          Table: Purchases

                         Item_ID            Quantity Purchased           Rate per unit               Amount


                                                            Table: Sales

                         Item_ID               Quantity Sold             Rate per unit               Amount


                                                       Table: Stock in Hand

                           Item_ID                     Item Name               Quantity in Hand at the beginning


                 •  Make 5 entries in each table.

                 •  Create a query to calculate the Quantity in Hand at the end for all the items.
                 Project 2

                 Create a data entry form for patient record to be maintained by ABC Hospital Services.
                 The fields that need to be part of the table are:

                 •  Unique Patient ID
                 •  Patient Name
                 •  Patient Address
                 •  Symptoms
                 •  Doctor’s Name

                 •  Diagnosis
                 •  Health Insurance Coverage (Yes/No)
                 Project 3

                 Create the following tables in MS Access:


                                                            Table: Parts

                    PartNo       PartName       PartUnit      SupplierID        Stock      CostPrice      SalePrice




                                                                                                   Project Work   89
   86   87   88   89   90   91   92   93   94   95   96