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

Question: 1

Write two table views in MS- Access.

Answer: 1

1-20

Following are two types of table views in MS-Access:

1)Design View : Design view allows you to define fields in the table before adding data to datasheet.

2) Datasheet View :When you open a table or query using the database window, it will be displayed in datasheet view.The Datasheet view is like worksheet.

Question: 2

Write the use of data sheet form.

Answer: 2

2-20

Following steps are used to add record to a table in data sheet view

.

1) To add record to a table in datasheet view, open the desired table in date sheet view.

2)Click the "New Record" button at the right end of the record navigation button group. It is located in the lower left corner of the datesheet view. It is the button with the arrow and asterisk [*] on its face

3)d Then enter the information into the fields in the "New Records" row. It is the bottommost row in the datasheet view that display the asterisk [*] at the left end of the row.

4) When you have finished entering the new record, you can move down to enter the next new record into the new row that has appeared.

5) Close the table when you are finished adding records.

Question: 3

Name three methods for creating tables in MS-Access.

Answer: 3

3-20

1) Creating Table in Design view

2) Creating Table by using wizard

3) Creating table by entering data

Question: 4

List Some Advantage of IDE .

Answer: 4

4-20

1) Less Time and Effort : The entire purpose of an IDE is to make developing faster and easier. Its tools and features are supposed to help you organized resources, prevent mistakes, and provide shortcuts.

2) Enforce Project or Company Standards : Simply by working in the same development environment ,a group of programmers will adhere to a standard way of doing things. Standard can be further enforced if the IDE offers predefined templates, or if code libraries are shared between different team members working on the same project.

3) Project Management : This can be twofold .First many IDEs have documentation tools that either automate the entry of developer comments, or many actually force developers too write comments in different areas.Second, simply by having a visual presentation of resources. It should be a lot easier to know how an application is laid out as opposed to traversing the file system for arcane files in the file system.

Question: 5

What is OLE Object in MS- Access?

Answer: 5

5-20

An OLE (Object Linking and Embedding) object is a sound, picture, or other object such as a Word document or Excel spreadsheet that is created in another program . Use this data type to embed an OLE object or link to the object in the database.

Question: 6

Define Integrated Development Environment (IDE).?

Answer: 6

6-20

IDE stands For Integrated Development Environment Information. It is an interface that is used to create a database. An IDE makes the using of database simple, manageable for end users who may not have a complicate programming Knowledge of the database system.

Question: 7

What is the use of field size property?

Answer: 7

7-20

Field size is used to set the number of characteristics needed in a text or number field. The default field size for the text type is 50 characters. If the records in the field will only have two or three characters, you can change the size of the field to save disk space or prevent entry errors by limiting the number of characters allowed.

Question: 8

List of Field Properties ?

Answer: 8

8-20

1) Field Size

2) Byte

3) Integer

4) Long Integer

5) Single

6) Double

7) Decimal

8) Format

9) Number Format

10) Currency Format

11) Date Format

12) Yes/No

Question: 9

Difference between degree of relation and cardinality of relation.

Answer: 9

9-20

Degree of Relation: The number of field in a relation is called the degree of a table. Once the table is created, its degree usually does not change,e.g. A table with five fields has a degree of 5.

Question: 10

List two Disadvantages of integrated development environment .

Answer: 10

10-20

1) Learning Curve : IDEs are complicated tools. Maximizing their benefit will require time and patience.

2) Will Not Fix bad code, Practice : You still need to be proficient and meticulous. An IDE will not eliminate efficiency or performance problems in your application. IDEs are like paintbrushes. Whether you create a van Gogh or a Velvet Elvis is dictated by your skill and decisions.

Question: 11

Define Degree of Relation.

Answer: 11

11-20

The number of field in a relation is called the degree of a table. Once the table is created, its degree usually does not change,e.g. A table with five fields has a degree of 5.

Question: 12

What is the use of datasheet view in MS-Access?

Answer: 12

12-20

Datasheet View: To see many records of data in MS- Access at the same time, you use a Datasheet view. When you open a table or query using the database window, it will be displayed in datasheet view. A table or query is opened in Datasheet view to perform different operations on the data in the table such as displaying data, adding new data , searching data etc. The Datasheet view is like worksheet. When table is opened in Datasheet view, the field names are displayed as header of columns and each row contains a complete records.

Question: 13

Create a query in Design View .

Answer: 13

13-20

Following steps are to create a query in Design View.

1) From the queries page on the Database Window, click the 'New' button.

2) Select Design View and click Ok.

3) Select tables and exciting queries from the Tables and Queries Tabs and click the Add Button to add each one to the new query.

4) Click Close When all of the tables and queries have been selected.

Question: 14

List Some Advantages of Query.

Answer: 14

14-20

1) High Speed

2) Well Defined Standards Exist \

3) No Coding Required

4) Emergence of RDBMS

Question: 15

Define Join?

Answer: 15

15-20

Join are what make relationship work. With something like a flat-file, none of this is a concern to you . Of course, that's not necessarily good because you're probably more concerned with having hundreds or thousands more records than you actually need or can manage .

Question: 16

Define Sorting.

Answer: 16

16-20

Sorting is a term to view records in a table in a different order than they appear such as sorting by dates or in alphabetical order. Follow these steps to sort records in table based on the value of one field.

1) In table view, place the cursor in the cursor in the column that you want to sort by.

2) Select Record | Sort | Sort Ascending or Record |sort| Sort Descending from the menu bar or click Sort Ascending or sort Descending buttons on the toolbar.

Question: 17

Write down the use of filters in MS-Access.

Answer: 17

17-20

Filtering is useful way to see only the data that you want displayed. You can use filters to display specific records in a form, report, query, or datasheet or to print only certain records from a report, table , or query . By applying a filter, you are able to limit the data in a view without altering the design of the underlying object. There are the following method are available for filtering .

1) Filter by Selection

2) Filter by Form

Question: 18

Define Relationship.?

Answer: 18

18-20

A relationship is a powerful method for organizing your data. Using a relationship, you can join data in one or more tables based on common field values,different field values , or a comparison of values in two or more fields. It is important to note that whenever you want to use data from another table- either in a relational database or for a lookup --- you must first define a relationship between the two tables.

Question: 19

What is the use of Input Mask?

Answer: 19

19-20

An input mask controls the value of a record and set it in a specific format. They are similar to the format property , but instead display the format on the datasheet before the data is entered. For Example, a telephone number field can be formatted with an input mask to accept ten digits in the form "(555) 123-4567". The blank field would look like(_____)_____.

Question: 20