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

Question # 1

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

Differentiate Between Forms And Reports?

Ans 1: Forms: 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
Ans 2: Reports: 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 # 3

List of Available Buttons on Access Database Window.

Ans 1: 1)Table
2) Queries
3)Forms
4) Reports
5) Pages
6) Macros
7) Modules

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

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

List Any four properties of relational database management system.

Ans 1: 1) Values Are Atomic
2) Column Values Are of the Same Kind
3) Each Row is Unique
4) The Sequence of Columns is Insignificant
5) The Sequence of Row is Insignificant
6) Each Column Has a Unique Name

Question # 8

What is Query?

Ans 1: 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.

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

What is the use of MS-Access?

Ans 1: Use of MS-Access:

1) Access can also understand and use a wide variety other data formats, including many other database file structure .
2) You can export data to and import data from word processing files, spreadsheet ,or database files directly.
3) it stores data in its own format based on the Access Jet Database Engine.

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 the use of title bar in MS-Access?

Differentiate Between Forms And Reports?

List of Available Buttons on Access Database Window.

Name Any four parts of MS-Access Application Window.

Define the term Redundancy.

How Query is Written?

List Any four properties of relational database management system.

What is Query?

Define a Form .

What is the use of MS-Access?

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 the use of title bar in MS-Access?

Differentiate Between Forms And Reports?

List of Available Buttons on Access Database Window.

Name Any four parts of MS-Access Application Window.

Define the term Redundancy.

How Query is Written?

List Any four properties of relational database management system.

What is Query?

Define a Form .

What is the use of MS-Access?

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

List advantages of RDBMS .

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

List Any Two Uses of Reports.

List Down Any Two Advantages of Microsoft Access.

Define the term RDBMS.

Differentiate Between Forms And Reports?

What is Query?

What is Sample Database?

Write Definition of Reports.

Define Scroll Bar .

12th Computer Science Chapter 5 Preparation