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.
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”.