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

Question # 1

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

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.

Question # 3

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

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

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

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

Question # 7

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

Question # 9

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

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