Computer Operator Practical Ms-Access Questions Collections

Q.No.1 Create a Hospital database and the following tables init: [4 marks]

Patient: PatientID, Name, Address, DateOfBirth, DoctorID

Doctor: DoctorID, Name, Address, JoinDate

Treatment: TreatmentID, DoctorID, PatientID

Medicine: MedicineID, Description, DoctorID, TreatmentID, PatientID

• Create suitable relationship between those tables.

Q.No.2 MS Access questions. (Ktm, 2071)

• Create a table with Product ID, Product Name, Product Detail, and Product Amount.
• Create a form and enter at least 3 products.
• Create a query that gives the maximum amount for the products entered (i.e. highest price of the given products.)

Q.No.3 Create a database and make a table named “salary” having the following fields:

empid, empname, address, dept, salary

•     Insert any five records.
•     Create a query to show the employees of “Account” department whose salary is greater than 10000.

Q.No.4 Create a database and make a table “employee”.

empid, empname, address, dob, salary

• Ø  Insert 5 records.
• Ø  Make a query to display the list of employees whose age is more than 25 years.

Q.No.5 Create a database named “library” and do the following tasks.

• Ø  Create a table student with stdid, stdname, address, bookname, issuedate, returndate
• Ø  Insert any five records.
• Ø  Generate a query to view the records of students who have 7 days due for book return.

Q.No.6 Perform following database tasks [4 marks]

1. Create a new database and name it Database_YourSymbolNumber. 

Create following tables with given field names and appropriate field types: [2]

Students: StudID, StudName, StudAddress, StudFather

Fees: FeesID, StudID, FeesMonth, FeesAmt, FeesDate

2. Set StudID field of Fees table so that it will display1] drop

3. Create a query to display FeesDate, StudName, FeesMonth and FeesAmt [1]

Q.No.7 Create a table “marks” in the database “exam” table. [2]

MarksID, English, Nepali, Maths, Science

• Create a query to display MarksID, Total, and Percentage [2]

Q.No.8 Perform following database tasks [4 marks]

1. Create a “marks” table with following in fields: “QC1” database.

Marks: MarksID, StudentName, Class, Eng, Nep, Mat, Sci

2. Create a form to enter marks in "Marks" table. It should be displaying Total, Percentage, Result, and Division at the bottom that updates when you enter marks for different subjects. [2]

3. Create a query to display StudentName, Total Marks and Division. [1]

Q.No.9 Create the following table in the “QC” database with given fields. Enter at least 3 records: [2]

Items: itmID, itmDesc, itmPrice

Purchase: purID, purDate, purQty, itmID

• Create “Inventory Details” report to list Purchase Date, ItemDescription, Purchase Quantity, and Item Price. [2]

Q.No.10. Create the following tables in the “Sales“database with given fields. Establish a suitable relationship between the two tables. [2]

Items: itmID, itmDesc, itmPrice

Purchase: purID, purDate, purQty, itmID

• Write a query to list Purchase Date, Item Description, Item Price, and Purchase Quantity. [2]