Computer Operator Practical Exam Ms-Access (Database Management System) Questions Collection

Dear friends, here I present the collection of computer practical questions that are asked previously in the computer practical exam of the Public Service Commission (Lok Sewa Aayog).

These questions are collects from the students that are included in the final exam, from the internet, from Facebook, from friends.

If you need Practical Question on Ms-Word, Ms-Excel, Ms-Powerpoint, HTML & Interview, Please Go through the following link.

CLICK BELOW LINK:-

Ms-Word Practical Questions:

Ms-Excel Practical Questions:

Ms-Powerpoint Practical Questions:

Ms-Access (Database) Practical Questions:

HTML Practical Questions:

If you want also mcq questions on following topic, click the link

Computer Fundamental MCQ Questions Collection:-

Ms-Word (Word Processing) MCQ Questions Collection:-

Ms-Excel (Excel Spreadsheet) MCQ Questions Collection:-

Ms-Powerpoint (Presentation) MCQ Questions Collection:-

Ms-Access (Database Management System) MCQ Questions Collection:-

HTML (Web Page Designing) MCQ Questions Collection:-

Interview Questions Collection:-

And further if you need the preparation and practical guide for the final exam. 

The post or article Practical Exam Guide for Computer Operator Exam of PSC. 

The another articles about Sample Job Interview Questions really helps you.

I have collected questions for Ms-Access (Database Management System) Practice. Practice well and try to solve those questions in time.

If you need other similar questions, please write in the comment box below. I will upload it on the website for your preparation. If there is any problem in solving it, please write in the Comment Box. 

Join My Social Profile for more updates:

Telegram Group:-  Mohan Bhatt

(Where upload learning materials more about Computer Practical and upload pdf file related with)

Facebook Page:- Mohan Bhatt Facebook Page

Youtube Channel:- Computer Operator & Blogging 

Ms-Access (Database Management System) Practice Questions Collection:-
1. Create a database in Ms-Access of Employees, using following fields of the database
· Employee – ID
· Emp – Name
· Emp – Post
· Basic – Pay
· Department
· Age
· Sex (M/F)
Note: Add at least 5 records.

2.     Create a Bank Database with the following fields using Ms-Access.

Account Number

Account Type

Address

Telephone

Balance

Customer Name

Add at least five records in each. Create a form consisting of all fields of the Bank.

3. Create a database in Ms-Access of BOOK-SHOP, using following fields of the database.
· ISBN
· Author
· Title
· Publisher
· Cost
· Discount
Note: Add at least 5 records.

4. Create a database using Ms-Access for the customer of an organization. The database should have the following fields (you must select proper data types and sizes of the fields):
(cust_id, cust_name, cust_rating, cust_phone, cust_balance)
Enter about 4 records in this database created by you.
5. Create a database using Ms-Access for students having the following database fields (select proper data types and sizes of the fields):
(student_id, name, programme, phone, age)
Also enter 4 student records in this database.

6.     Create a database in Ms-Access of Medical Shop using following fields of the database:

Medicine_Code

Trade Name

Date of Manufacture

Date of Expiry

Quantity Available

Cost

Add at least three records in each. Create a form consisting of all fields of the shop.

7. Create a database in Ms-Access of Cricketers, using following fields of the database.
· Name of Cricketer
· State of Cricketer
· No. of International games played
· Age (Should not be more than 50 years)
· Sex (M/F)
· Best Score
· No. of runs
Note: Add at least 5 records.
8. Create a database in Ms-Access of a Transportation company using following fields of the database:

Vehicle_Code

Registration Code

Plan Code

No. of Kilometers

Date of hire

Time of hire

Rate of hire

Total earning

Add at least three records in each. Create a form consisting of all fields of the shop.
9. Create a database called COLLEGE. Create a table within the Database called students with the following details.

Name	Department	Age	SALARY
A	ICT	40	50000
B	STORES	34	40000
C	PRODUCTION	51	45000
D	SALES	33	45000
E	MARKETING	43	35000
F	HRM	24	40000

a)  Create a query for all students below 50000 salary showing the following fields only name, age and salary.

b) Create an input form for all the fields.

c) Create a report showing all details but arranged in ascending order according to name.

10. Create a Database called EMPLOYEE. Enter the following records, sort table by Employee No. in ascending order, save the table as employee.

Employee Name	DEPT.	DOB	Date Employed	Qualification
Ram	ICT	20/10/1990	02/01/2010	BCOM
Gita	STORES	12/08/1982	10/05/2012	BED
Sita	PRODUCTION	16/05/1993	11/04/2015	B.E.
Rita	SALES	17/04/1980	15/03/2016	HM
Shyam	MARKETING	12/01/1989	21/02/2014	BSc
Prem	ICT	11/11/1991	15/10/2014	BED

a) Create a query that displays all employees with BED and save as query1

b) Design a query that displays all employees employed before 01/01/2010 or are doing HM. Save as query2.

c) Print a report that extracts the following information from table: Employee Name and Qualification.

d) Design a query for those employees who are in the ICT department and their name starts with an 'R'.

11. Design a database called examination with the following fields save it as exam.

Name	Age	Mark %	Position in Class
Raju Bhatt	19	60
Priya Joshi	18	69
Radhika Bohara	22	74
Arju Bam	17	63
Janu Dobal	21	72

a) Design a suitable query that display the records for all students whose percentage mark is more than 50%, save the file as exam1.

b) Sort the records alphabetically.

c) Calculate and insert class positions accordingly.

d) Save the database as MIDYEARRESULTS and produce a report that extracts all the information in the database.

12. Create a database file 'STAFFREC'. Create a table within this database and used the following structure.

Name	DOB	SEX	DEPARTMENT	SALARY
Rohan Bohara	09/03/1983	M	Administration	45000
Ranjana Dhami	05/06/1991	F	Administration	40000
Ram Bhatt	18/05/1995	M	Accounting	35000
Raj Gautam	04/06/1985	M	Marketing	30000
Priya Joshi	06/11/1992	F	Marketing	36000

a)  Save the table as STAFF. Change the field type for Long Date to Short Date.

b) Sort in descending order by name.

c) Create a Query showing all people born after 1980, save query as query1.

d) Create a Query showing all females showing name, department, sex and salary only, save query as query 2.

e) Create a tabular report showing name, sex, department and salary only.

13. Create a database file 'Student'. Create a table within this database and used the following structure.

Student_Name	Student_ID	SEX
Priya Bohara	1001	F
Deepak Dhami	1002	M
Kriti Bhatt	1003	F
Sooniya Badu	1004	F
Mohan Dadal	1005	M

a) Save the table as STUDENT. Insert the fieldname Birthdate right after Student_Name of data type Date/Time. The field size is automatically set. Set the format of date as DD/MM/YY.

b) Create a Query showing all people with initial P, save query as query 1.

c) Create a Query showing all STUDENT_ID with prefix 10, save query as query 2.

d) Create a Query showing all Students with student_id greater than 1003, save query as query 3.

e) Create a tabular report showing all details in landscape format.

14. Create a database file 'CLASS REGISTER'. Create a table within this database with a structure below. Add six records. Save it as class register. Do not set the primary key.

Field_Name	Data Type
NAMES	Text
DOB	Date/Time
GENDER	Text
FEES PAID	Currency

a) The format of the date should be Medium Date.

b) Sort the records in ascending order of all field name.

c) Design a query that displays the details of all females and save it as Female Query.

d) Design a tabular report basing on the class register table. The report should be titled CLASS LIST 2011, save it.

15. Create a database file 'HOTEL'. Create a table within this database and used the following structure.

Rooms	No. of Beds	Facilities	Cost	Single
Room 1	2	General	2500	Yes
Room 2	2	Special	3000	Yes
Room 3	1	Special	3500	No
Room 4	2	General	3000	No
Room 5	1	Special	1500	Yes

a)  Save the table as Hotel Acc.

b) Design a Query that displays costs above 1000, save it as query 1.

c) Design a Report and save it as hotel report.

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

17. Create a database named 'school' and perform the following tasks.\

a. Create a table named 'student info' having following table structure.

Field Name	Data type	Description
Class	Number
Section	Text
Roll no	Number
Name	Text	40 characters long
Status	Lookup wizard	Two value: 'Senior' , 'Junior'
Photo	OLE object	Photos of students
DOB	Date/time	Date of birth of students
Remarks	memo

b. Fill at least 5 records.

c. Prepare a query to display all records and Name should be in ascending order.

d. Prepare a query named 'senior' to display records including fields name, class, sec, roll no, status, photo and value of 'status' field must be senior.

e. Prepare a form of above query 'senior'.

f. Prepare a report of all the fields of above table.

18. Create a database named 'library' and perform the following tasks:

a. Create a table named 'Book' having following structure:

Field name	Field datatype	Description
Book _id	Text	Primary key. Book identification number
Bname	Text	Book name
Wname	Text	Writer’s name
Pyear	Date/time	Published year
Pname	Text	Publisher name
Price	Currency	Purchased price
Pdate	Date/time	Purchased date
Remark	Memo	comments

b. Add at least 5 records.

c. Prepare a query to display only records including book name, writer name and publication name. Save the query as 'q_book'.

d. Prepare a query to display all records on the basis of price which is more than Rs500.

e. Prepare a form on the basis of table.

f. Prepare a report on the basis of query named "q_book".

19. Create a database named 'Nepal Bank' to store information about its staffs and do the following tasks:

a. Create a table named 'staffinfo' having following table structure:

Field name	Data type	Description
Sid	Autonumber	Pkey. Staff identification number
Department	Text	Department like teller dept, administration dept, store dept, loan dept, marketing dept
Sname	Text	Staff name
Address	Text	Address of staff
Sphone	Text	Staff phone
Post	Text	Like junior teller, casher, accountant, manager etc
Doj	Date/time	Date of joined
Sdob	Date/time	Date of joined

b. Create a form on the basis of 'staffinfo' table and save as 'entryform'.

c. Fill at least 5 records using the 'entryform'

d. Create a query named 'depinfo' to display records only including department name, staff name and mobile number.

e. Create a query named 'post' to display staff name, post, department and phone number whose post is 'teller' or 'casher'.

f. Prepare a report on the basis of query named 'depinfo'.
20. A. Create a database named exam.mdb and a table named class 8 with the following structure.

Field name                              Data type

Roll no                        number (primary key)

Name                                      text

English                                    number

Science                                   number

Math                                        number

a. Add any 5 records in the table.
b. Prepare a query named 'total marks' to calculate sum of all the marks.
c. Prepare a query named 'topper' of query 'total marks' to display all records whose total is more than 200.
d. Prepare a form of your query using form wizard with all the fields.
e. Prepare a report on the basis of query 'Total marks'.

If you have any queries, comment below in the comment box.