12th Class Computer Science Chapter 5 Short Questions with Answers Solved

Question: 1

What is Microsoft Access?

Answer: 1

1-25

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

Define the term RDBMS.

Answer: 2

2-25

RDBMS is stand for Relational Database management System. A relational database management system (RDBMS) is a program that lets you create , update, and administer a relational database. Most commercial RDBMS use the Structured Query Language (SQL) to access the database, although SQL was invented after the development of the relational model and is not necessary for its use.

Question: 3

What is the use of MS-Access?

Answer: 3

3-25

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.

Question: 4

Define the term Redundancy.

Answer: 4

4-25

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: 5

Define Scroll Bar .

Answer: 5

5-25

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

List Down Any Two Advantages of Microsoft Access.

Answer: 6

6-25

There are the following advantages of Microsoft Access.

1) Easy to install and Use :MS Access give data managers a fully functional, relational database management

System in minutes. Like many other Microsoft application, access contains Wizards that walk you through each step of the way . The user interface is intuitive accelerating data information retrieval.

2) Ease to integrate: MS Access works well with many of the developing software programs based in windows. It also can be used in the front-end as back -end tables with products like Microsoft SQL Server and non-Microsoft products like Oracle and Sybase.

Question: 7

Describe Menu Bar.

Answer: 7

7-25

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: 8

What is Database Wizard?

Answer: 8

8-25

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

Name Any four parts of MS-Access Application Window.

Answer: 9

9-25

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

List Any four properties of relational database management system.

Answer: 10

10-25

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: 11

List advantages of RDBMS .

Answer: 11

11-25

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

Question: 12

What is Sample Database?

Answer: 12

12-25

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: 13

Differentiate between Menu bar and Toolbar.

Answer: 13

13-25

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: 14

Define Database Objects.

Answer: 14

14-25

Database Objects: MS-Access database consists of various components called the objects. The database objects is used to store data and to retrieve data from database . The major database Objects are :

1) Tables

2) Queries

3) Forms

4) Reports

Question: 15

List of Available Buttons on Access Database Window.

Answer: 15

15-25

1)Table

2) Queries

3)Forms

4) Reports

5) Pages

6) Macros

7) Modules

Question: 16

Enlist two Uses of Form.

Answer: 16

16-25

Uses of 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: 17

Differentiate Between Forms And Reports?

Answer: 17

17-25

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

Question: 18

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

Answer: 18

18-25

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: 19

List Any Two Uses of Reports.

Answer: 19

19-25

1) Display or distribute a summary of data.

2) Provide details about individual records.

Question: 20

Define a Form .

Answer: 20

20-25

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: 21

Write Definition of Reports.

Answer: 21

21-25

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: 22

What is Query?

Answer: 22

22-25

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: 23

How Query is Written?

Answer: 23

23-25

1) Open your database.

2) Select the queries tab.

3) Double -Click on

4) Create query by using wizard .

Question: 24

Differentiate Between Query and Report .

Answer: 24

24-25

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.

Question: 25

Define two database objects.

Answer: 25

25-25

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.

Computer-science Chapters

12th Class Chapter 5 Computer science Short Questions

0

Perparation Level