Ms Access
Q.1(a) Create a data file “FIFA22.MDB” and create a table
“team” under the database with the following structure.
|
Field Name |
Data Type |
|
Team_No |
Number( Primary Key) |
|
Country |
Text |
|
Captain_Name |
Text |
Q.1(b) Add five records in the “team” table.
Q.1(c) Create a form including all the fields to
perform data entry in future.
Q.1(d) Prepare a query to display the details of
country name start from alphabet “B”.
Q.1(e) Prepare the report of 1 (d).
Q.2(a) Create a database “hospital.MDB” and create a
table “patient” under the database with the following structure.
|
Field Name |
Data Type |
|
P_id |
Number( Primary Key) |
|
P_name |
Text |
|
P_gender |
Yes/No |
|
Address |
Text |
Q.2(b) Add any five records in the table.
Q.2(c) Create a form including all the fields to
perform data entry in future.
Q.2(d) Prepare a query to display list of patient
from “Kathmandu”.
Q.2(e) Prepare the report of 2(d).
Q.3(a) Create a data file “Student23.MDB” and create
a table “marks” under the database with the following structure.
|
Field Name |
Data Type |
|
Roll No |
Number( Primary Key) |
|
Name |
Text |
|
Marks in computer |
Number |
Q.3(b) Add five records in the “marks” table.
Q.3(c) Create a form including all the fields to
perform data entry in future.
Q.3(d) Prepare a query to display Students details
whose marks is more than 30 in computer
Q.3(e) Prepare the report of 3 (d).
Q.4(a) Create a data file “Student80.MDB” and create
a table “report” under the database with the following structure.
|
|
Data Type |
|
Roll No |
Number( Primary Key) |
|
Name |
Text |
|
Marks in Computer |
Number |
|
Marks in English |
Number |
|
Marks in Maths |
Number |
|
Marks in Nepali |
Number |
Q.4(b) Add five records in the “report” table.
Q.4(c) Create a form including all the fields to perform data entry in future.
Q.4(d) Prepare
a query to display Students details whose marks is more than 30 in
computer
Q.4(e) Prepare the report of 4 (d).