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

Question # 1

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 # 2

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 # 3

Define two database objects.

Ans 1: 1) Database Objects :

a) Forms : The form object of database is used to enter data into database, edit data and view data from database. You can add, updates and delete records in your table by using a form,
b) Reports: The Reports 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.

Question # 4

Name Any four parts of MS-Access Application Window.

Ans 1: These Access Application Window follows the standard layout of all Microsoft Application:
1) Title Bar
2) Menu Bar
3) Toolbars
4) Scroll Bar
5) Status Bar

Question # 5

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 # 6

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 # 7

What is the use of title bar in MS-Access?

Ans 1: The Title bar identifies the database application you are running in Microsoft Access. On the left side of the title bar is program Control Icon.If you click this, a menu of the commands to control the Access window is displayed . On the right side of the title bar to control the MS-Access Window.

Question # 8

What is Database Wizard?

Ans 1: Database Wizards make very easy to create a database. You can choose from several examples of database in the Database Wizard for the such storage uses as contact information, inventory control, a ledger, and so on. you can create and then modify these database to meet your own needs.

Question # 9

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 # 10

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.

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

Define the term Redundancy.

What is Microsoft Access?

Define two database objects.

Name Any four parts of MS-Access Application Window.

How Query is Written?

Differentiate Between Query and Report .

What is the use of title bar in MS-Access?

What is Database Wizard?

Write Definition of Reports.

Define a Form .

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

Define the term Redundancy.

What is Microsoft Access?

Define two database objects.

Name Any four parts of MS-Access Application Window.

How Query is Written?

Differentiate Between Query and Report .

What is the use of title bar in MS-Access?

What is Database Wizard?

Write Definition of Reports.

Define a Form .

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

What is the use of MS-Access?

Differentiate between Menu bar and Toolbar.

What is Sample Database?

How Query is Written?

Write Definition of Reports.

Describe Menu Bar.

List advantages of RDBMS .

Define two database objects.

Define Database Objects.

What is Database Wizard?

12th Computer Science Chapter 5 Preparation

Is this page helpful?