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

