OU B.Com 2020 Important Question Bank || Osmania University (Important Questions)
FACULTY OF COMMERCE, OSMANIA UNIVERSITY
B.Com (Honours) (CBCS) III – Semester
Lab - Practical Question Bank
--- Content provided by FirstRanker.com ---
MANAGEMENT INFORMATION SYSTEMS – Practical Question Bank
Time: 60 Minutes Record: 10
Skill Test: 15
Total Marks: 25
- Create a database named “College.mdb" and perform the following tasks: (For questions 1 to 10)
--- Content provided by FirstRanker.com ---
Create a table named “StudentInfo” having following table structure.
Fieldname Datatype Description Rno Text Primary Key Name Text DOB Date/time Gender Text M/F Class Text BCOM Section Text GEN/HONOURS - Insert at least 10 records and display the records in ascending order of their Name's.
- Prepare a query to display all the fields.
- Prepare a query to display only Rno, Name fields
- Prepare a query to display all records in ascending order of the names.
- Prepare a form for the above table and insert 5 records through the form.
- Prepare a report consisting of the fields Rno, Name, Class.
- Display all the student details where gender is “M”.
- Prepare a query to display all records where the name begins with “A”.
- Display the students studying under HONOURS section.
- Display the students studying under GEN section.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
- Create a database named “Library.mdb" and perform the following tasks: (For questions from 11 to 20)
Create a table named “Books” having following structure:--- Content provided by FirstRanker.com ---
Fieldname Datatype Description BookId Text Primary Key BookName Text Author Text Year Date/Time Publisher Text TMH/OXFORD Price Currency Remarks Memo - Insert at least 10 records and display the records in descending order of their price.
- Prepare a query to display onlyfields includingBookName, Author and Publisher name. Save the query as "MyQuery".
- Prepare a query to display all records where the price of the book is more than 500.
- Prepare a form for the table.
- Insert 5 records through the form.
- Display the records whose publisher is ‘TMH’
- Sort the records in the ascending order of the Price.
- Display the records in the ascending order of the Year published.
- Generate a report consisting of the fields BookId, BookName, Author.
- Delete the records whose publisher is “TMH”.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
- Create a database named “Employee.mdb" and perform the following tasks: (For questions from 21 to 30)
Create a table named “EmpSalaryTable” having following structure:
Fieldname Datatype Description EmployeeId Text Primary Key EmployeeName Text BasicSalary Currency DA Currency HRA Currency TA Currency PF Currency GrossSalary Currency NetSalary Currency - Insert at least 10 records into the EmployeeId, EmployeeName fields and display the records in ascending order of EmployeeName's.
- Prepare a query to Calculate the DA as 30% of BasicSalary.
- Prepare a query to Calculate the HRA as 20% of BasicSalary.
- Prepare a query to Calculate the TA as 10% of BasicSalary.
- Prepare a query to Calculate the GrossSalary as BasicSalary+DA+TA+HRA.
- Prepare a Query to Calculate the PF as 12% of BasicSalary.
- Prepare a Query to Calculate the NetSalary as GrossSalary-PF.
- Sort the employee details in the increasing order of NetSalary.
- Generate a form to display the details of all the employees.
- Generate a report to display the fields EmployeeId, EmployeeName,BasicSalary, GrossSalary and NetSalary.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
- Create a database named “Marks.mdb" and perform the following tasks:(for questions from 31 to 40)
Create a table named “StdMarksTable" having following structure:
Fieldname Datatype Description StudentId Text Primary Key StudentName Text Marks1 Number Marks2 Number Marks3 Number Total Number Average Number Result Number Pass/Fail - Insert at least 10 records and display the records in ascending order of their StudentName's.
- Display the student details in the deceasing order of Marks1.
- Prepare a query to Calculate the Total as sum of Marks1,Marks2, Marks3.
- Prepare a query to Calculate the Average.
- Prepare a query to Calculate theResult taking your own criteria.
- Prepare a Query to display the fields StudentId, Total, Average, Result.
- Prepare a Query to display all the students in the ascending order of their names.
- Sort the students in the ascending order of their totals.
- Generate a form to display the details of all the students.
- Generate a report to display the students details who have passed.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
- Create a database named “CustOrders.mdb" and perform the following tasks:(for questions from 41 to50)
Create a tables with the following structure
Table name: "CustomerTable"
Fieldname Datatype Description CustomerId Text Primary Key FirstName Text LastName Text Street Text City Text Zipcode Text Email Text Phone Text
Table name: "Orders Table"--- Content provided by FirstRanker.com ---
Fieldname Datatype Description OrderId Text Primary Key CustomerId Text Price Number OrderDate Date/time Qty Number - Create the tables with the above mentioned structure.
- Insertatleast5 records in Custome Table.
- Create a query to display all the fields in CustomerTable
- Create a one to many relationship between the two tables.
- Insertatleast 10 records in the Orders Table
- Prepare a query to display the fields Id, FirstName, LastName, Phone from the CustomerTable
- Prepare a query to display all the fields in the Orders Table
- Prepare a query to display the fields Id, FirstName, LastName, OrderId, Qty from the two tables.
- Prepare a query to display the fields OrderID, CustomerID, Qty from Orders Table where Qty> 10.
- Prepare a query to display all the customers whose FirstName begins with the character “A”.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
This download link is referred from the post: OU B.Com 2020 Important Question Bank || Osmania University (Important Questions)