12th Class Computer Science Chapter 5 Short Questions with Answers Online Preparation

Question # 1

What is Microsoft Access?

Ans 1: Microsoft Access is one of the most popular and powerful DBMS. It has many built in factures to assist you in constructing database and viewing information.MS-Access is much more involved is a more genuine DBMS than other program such as Microsoft Works.Microsoft Access Relational Database Management System (RDBMS) that you can use to store and manipulate large amount of information.it is easy to understand and its graphical interface helps to create queries,forms, and reports .

Question # 2

What is Sample Database?

Ans 1: Sample Database includes sample database applications to assist you learn about real-world tables, forms, queries and reports, and how they are interconnected to form a database management system.

Question # 3

Describe Menu Bar.

Ans 1: Menu Bar : Each word on the menu bar represents a different menu. Each menu contains the commands you use to activate features of access. If a command is also found on a toolbar then the icon representing the command is displayed the menu too. This makes recognizing command easier.

Question # 4

Define Scroll Bar .

Ans 1: Scroll bars are used to move around the window if its contents do not fit on-screen.you can scroll around the sheet by clicking the scroll arrows at either end of the scroll bar by dragging the scroll buttons in the scroll bar.

Question # 5

Differentiate Between Query and Report .

Ans 1: Query: Query is a statement that extracts specific information from database. It is created by specifying the fields to display from a table or another query.It is more flexible way of selecting , filtering and sorting records.
Ans 2: Reports: Reports are used to retrieve the data from database and present it on screen in a predefined format. Report do not allow user to challenge data or to enter data into database.

Question # 6

How Query is Written?

Ans 1: 1) Open your database.
2) Select the queries tab.
3) Double -Click on
4) Create query by using wizard .

Question # 7

Write Definition of Reports.

Ans 1: The Report object of database is used to retrieve and present data in a formatted way . The report can be printed. Some reports are simply a list of the records in the database, one record after the other. Most of the popular DBMS provide this facility. The output of the query can also be given as input source to reports.

Question # 8

Define the term Redundancy.

Ans 1: MS-Access allows you to store, retrieve, sort, analyze, and print information contained in the database. Data may be manipulated without data redundancy by defining relationship between set of data . Database are often used for product data. Redundancy means duplication of data in multiple files. It wastes the storage media of computer .

Question # 9

Define a Form .

Ans 1: The Form object of database is used to enter data into database, edit data and view data from database. You can add, update, and delete records in your table by using a form.
1) An easy method for entering and editing data in tables , Thus the user does not have to work directly with tables .
2) Facilities to display data retrieved from database tables.

Question # 10

List advantages of RDBMS .

Ans 1: 1) Complex queries can be carried out
2) Ease of use
3) Better security
4) cater for future requirement
5) Data is only stored once

Latest Educational News Stories

Pakistan's Largest Database of Colleges and Universities

BS Programs

University Past Papers

University Results

Exam Results 2024

Study Abroad Programs and Opportunities for Pakistani Students

ICS Part 2 Computer Science Chapter 5 Short Questions Test With Answer

Online Short Questions For Chapter 5 "ICS Part 2 Computer Science Chapter 5 Short Questions Preparation "

Computer Science - ICS Part 2 Computer Science Chapter 5 Short Questions Preparation

What is Microsoft Access?

What is Sample Database?

Describe Menu Bar.

Define Scroll Bar .

Differentiate Between Query and Report .

How Query is Written?

Write Definition of Reports.

Define the term Redundancy.

Define a Form .

List advantages of RDBMS .

Prepare Complete Set Wise Questions For Chapter 5 "ICS Part 2 Computer Science Chapter 5 Short Questions Preparation "

Set 1

Set 2

ICS Part 2 Computer Science Chapter 5 Short Questions Preparation - Set 1

What is Microsoft Access?

What is Sample Database?

Describe Menu Bar.

Define Scroll Bar .

Differentiate Between Query and Report .

How Query is Written?

Write Definition of Reports.

Define the term Redundancy.

Define a Form .

List advantages of RDBMS .

ICS Part 2 Computer Science Chapter 5 Short Questions Preparation - Set 2

Differentiate Between Query and Report .

What is Microsoft Access?

Write Definition of Reports.

Define the term Redundancy.

Define Scroll Bar .

How Query is Written?

What is Query?

Name Any four parts of MS-Access Application Window.

Define a Form .

List advantages of RDBMS .

12th Computer Science Chapter 5 Preparation

Is this page helpful?

Share your comments & questions here