Connect Me

twitterfacebookgoogle plus email

  Instagram View Biwas Bhattarai's profile on LinkedIn

DBMS SLC Practical Questions

1.      Perform the following tasks using MS Access-2003/2007.
a.       Create a database file “Salary” with the table name “Employee” using  following fields:
Field Name
Data Type
Field Size
EmployeeID
Number(PK)

FullName
Text
40
Address
Memo

Basic Salary
Number

Date of Join
Date/Time

Post
Text

Designation
Text

b.      Add 6 records in the “Employee” table.
c.       Prepare a query to display all the records with fields Name, Basic Salary, and Post.
d.      Prepare a query that display the records whose Basic Salary is more than 50000 and Post is “Director”
e.       Prepare an update query to increase the Basic Salary of entire employee by 5500.
f.       Prepare a report containing for Q.N (d).


2.      Perform the following tasks using MS Access-2003/2007.
a.       Create a database file “Hospital” with the table name “Patient” using  following fields:
Field Name
Data Type
Field Size
Patient ID
Numbr (PK)

Patient Name
Text
50
DOB
Date/Time
YY-MM-DD
Address
Text
35
Health Problem
Memo

Communicable/ Non-communicable
Yes/No
Check for Communicable
b.      Add 5 records in the “Patient” table.
c.       Prepare a query to display the records of communicable disease.
d.      Create a form and add 2 records in the above table.
e.       Create a query that display the patient records whose DOB is before 06/08/2005.

3.      Perform the following tasks using MS Access-2003/2007.
a.       Create a database file “Result” with the table name “Marks” using  following fields:
Field Name
Data Type
Remarks
Roll Number
Number (PK)

Full Name
Text
Field Size 50
DOB
Date/Time
DD-MM-YY
Photo
OLE object

English
Number
Validate Marks between 0 to 100
Nepali
Number
Science
Number
b.      Add 5 records in the “Marks” table.
c.       Prepare a query that display the Total marks obtained in all 3 subjects. Use the formula: Total:[English]+[Nepali]+[Science]
d.      Prepare a query that displays the records where the mark of English is less than 87 and mark in Nepali is between 70 and 80.
e.       Prepare an Update Query that increase the mark of all students in Science by 5.
f.       Prepare a report based on Q.N (d)


4.      Perform the following tasks using MS Access-2003/2007.
a.       Create a database file “Football” with the table name “Players” using  following fields:
Field Name
Data Type
Field Size
Player ID
Number(PK)

FullName
Text
40
Gender
Yes/No

Country
Text
45
Club
Text
35
Position
Text

DOB
Date/Time

b.      Add 5 records in the table.
c.       Prepare a query to display the players records who are of “Nepal”
d.      Prepare a query to display the records of female players only.
e.       Prepare a query that displays the records of Players who are Forward.
f.       Create a report based on table “Players”.
Ą
https://www.flickr.com/photos/spklg/15211044551/