Download OU B.Com (Important Questions) Bcom (Computers ,CA,& Hons) MIS Practical Question Bank

FirstRanker.com

Computer Lab - Practical Question Bank

FACULTY OF COMMERCE, OSMANIA UNIVERSITY

--- Content provided by⁠ FirstRanker.com ---

MANAGEMENT INFORMATION SYSTEM PRACTICAL QUESTION BANK

Time: 60 Minutes

Record : 10

Skill Test : 15

Total Marks : 25

--- Content provided by‌ FirstRanker.com ---

MS ACCESS:

1. Create a Student Table in MS-Access with the following features:
   1. Roll Number
   2. Student Name
   3. Class
   4. Marks in Subject 1, Subject 2, Subject 3

   --- Content provided by FirstRanker.com ---

   5. Total
   6. Average
   7. Result
2. Create a Personal Information table in MS-Access with the following fields:
   1. First Name

   --- Content provided by FirstRanker.com ---

   2. Middle Name
   3. Last Name
   4. Nationality
   5. Gender
   6. Temporary Address

   --- Content provided by‍ FirstRanker.com ---

   7. Permanent Address. Generate a Form and Report.
3. Create an Inventory table in MS-Access with fields:
   1. Product ID
   2. Product Name
   3. Product Quantity

   --- Content provided by‌ FirstRanker.com ---

   4. Product Price
4. Create a database 'College' and table 'Student'. The following are the details of the table:
   

   Number	Fname	Lname	Address	Home phone	Joining date
   101	Ram	Prasad	11-1-963/A, Banjara Hills, Hyderabad	040-23343256	02/06/2016
   102	Shyam	Singh	12-1-254/B, Sultan Bazar, Hyderabad	040-23345679	05/06/2016
   103	Ankur	Agrawal	11-2-667/A, Vidhya Nagar, Hyderabad	040-23358796	03/06/2016
   104	Ramesh	Sharma	10-2-340, Road No.12, Banjara Hills, Hyderabad	040-23389745	04/06/2016
   105	Harish	Shekhawat	15-4-633/A, Begum Bazar, Hyderabad	040-23356486	02/06/2016

5. Create a database 'Student'. Also create table 'studtable' and execute the following queries

--- Content provided by​ FirstRanker.com ---

FirstRanker.com

1. Sort the data by Sname.
2. Calculate Total Marks of Individual Students.
3. Calculate Percentage Marks of Individual Student.

6. Create a database 'Student1'. Also create table 'stdtable' and execute the following queries

--- Content provided by⁠ FirstRanker.com ---

1. Display all Students who got >=80 Marks in Any Subject.
2. Display all Students who got >=80% Marks in Total
3. Display all Students who got <=60% Marks

7. Create a database 'Student2'. Also create 'stdmarks' and execute the following queries

1. Display All the students who got <25 in individual subject.

--- Content provided by‍ FirstRanker.com ---

2. Display all the students who are Failed in individual Subject.
3. Increase marks by adding 5 marks whose marks are <25.

8. Create a database 'Student3'. Also create table 'stdmarks1' and execute the following queries

1. Update table by adding Grade as per the following:-
   1. Total %age >=90% Grade “E”

--- Content provided by‌ FirstRanker.com ---

FirstRanker.com

9. Create 'Employee' database and table 'Emp'

1. Calculate DA as 40% of Basic Salary.
2. Calculate Hra as 15% of Basic Salary.
3. Calculate PF as 12.67% of Basic Salary

--- Content provided by FirstRanker.com ---

4. Calculate Gross Pay = Basic Salary + DA + HRA
5. Calculate Net Pay = Gross Pay – PF.

10. Create 'Employeel' database and table 'Emp]

1. List all the Imployees Who are working in Dept no.10
2. List all the Employees who get less than 20000 Salary.

--- Content provided by FirstRanker.com ---

11. Create 'Employee2' database and table 'Emp2'

FirstRanker.com

1. Update Salary by adding the increments as per the following:-
   1. 10% Increment in Basic Salary who get < 20000
   2. 5% Increment in Basic Salary who get >20000.

--- Content provided by‌ FirstRanker.com ---

12. Create 'Employee3' database and table 'Emp3'

Generate the query to find out the following:-

1. Total Salary paid by the Company to Employees
2. Maximum Salary paid by the Company to Employees
3. Minimum Salary paid by the Company to Employees

--- Content provided by⁠ FirstRanker.com ---

13. In the following table find out the Followings:

1. All the Department Nos and Employees Names.
2. All the Employees who joined in year 2001.

14. Create 'Course' database and 'Coursedtl' table having following records:-

1. Prepare the report to display lowest course fees with college name.

--- Content provided by FirstRanker.com ---

2. Prepare the Report to display all students who are pursuing B.Com(Computers).

15. In the following table generate the queries for the followings:-

1. Display the Course and College having Lowest Course Fees.
2. Display all the courses pursuing by the PQR College.

16. Create a Library Database of your college having following fields and enter atleast 30 records in it:-

--- Content provided by​ FirstRanker.com ---

17. From the College Library database find out the following:-

1. Total no. of copies of books subject wise.
2. A report displays all books group by Publisher.
3. A report displays all books group by Book Title.
4. A report displays all books group by Book Edition

--- Content provided by​ FirstRanker.com ---

18. Create the ‘Order' database and a table "Orderdt having following records:-

Generate the following reports from the above table:-

1. Display all the Order No. which have not been yet Delivered.
2. Display all the Orders of LED Monitor and CPU.
3. Display all the Orders of LED Monitor and CPU which are not have been delivered yet.

--- Content provided by FirstRanker.com ---

19. Create a a 'Sales' Database and a table ‘Salesdtl' having following fields and data:-

20. Generate the queries to find out the followings from the above ‘Sales' Table:

1. Total sale of all the Branches.
2. Total sale group by Branches.
3. Maximum sale of individual branch.

--- Content provided by FirstRanker.com ---

4. Maximum sale in all branches.

21. Create an 'Stock' database having an ‘Inventory' Table as per the followings:-

22. Generate the following queries from the above ‘Inventory ‘Table:-

1. Item wise total purchase price.
2. Display new purchase price after adding 15% increase in purchase price.

--- Content provided by‍ FirstRanker.com ---

3. Display new Purchase quantity after deducting 5% from the quantity

23. Create a 'Stock' database having 'Inventory,

Generate the following queries from the above table:-

1. Calculate the closing stock of each item (Closing Stock = Opening Stock + Purchase - Sales)
2. Display all the Items which has closing stock < 100

--- Content provided by‍ FirstRanker.com ---

3. If closing stock is less than 100 then set the remark as “Re-Order Level” otherwise "Enough Stock".

24. Create a database 'Student2'. Also create table 'stdmarks' and execute the following queries

FirstRanker.com

1. Display All the students who got <25 in individual subject.
2. Display all the students who are Failed in individual Subject.

--- Content provided by​ FirstRanker.com ---

3. Increase marks by adding 5 marks whose marks are <25.

25. Create a Personal Information table in MS-Access with the following fields:

1. First Name
2. Middle Name
3. Last Name

--- Content provided by FirstRanker.com ---

4. Nationality
5. Gender
6. Temporary Address
7. Permanent Address. Generate a Form and Report.

--- Content provided by​ FirstRanker.com ---

This download link is referred from the post: DUET Last 10 Years 2011-2021 Question Papers With Answer Key || Delhi University Entrance Test conducted by the NTA