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

Question # 1

Define Relationship.?

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

Name three methods for creating tables in MS-Access.

Ans 1: 1) Creating Table in Design view
2) Creating Table by using wizard
3) Creating table by entering data

Question # 3

Define Degree of Relation.

Ans 1: 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 # 4

List Some Advantages of Query.

Ans 1: 1) High Speed
2) Well Defined Standards Exist \
3) No Coding Required
4) Emergence of RDBMS

Question # 5

Define Join?

Ans 1: 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 # 6

What is the use of field size property?

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

Write the use of data sheet form.

Ans 1: 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 # 8

Create a query in Design View .

Ans 1: 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 # 9

Define Sorting.

Ans 1: 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 # 10

What is the use of Input Mask?

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

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 6 Short Questions Test With Answer

Online Short Questions For Chapter 6 "ICS Part 2 Computer Science Chapter 6 Short Questions Preparation "

Computer Science - ICS Part 2 Computer Science Chapter 6 Short Questions Preparation

Define Relationship.?

Name three methods for creating tables in MS-Access.

Define Degree of Relation.

List Some Advantages of Query.

Define Join?

What is the use of field size property?

Write the use of data sheet form.

Create a query in Design View .

Define Sorting.

What is the use of Input Mask?

Prepare Complete Set Wise Questions For Chapter 6 "ICS Part 2 Computer Science Chapter 6 Short Questions Preparation "

Set 1

Set 2

ICS Part 2 Computer Science Chapter 6 Short Questions Preparation - Set 1

Define Relationship.?

Name three methods for creating tables in MS-Access.

Define Degree of Relation.

List Some Advantages of Query.

Define Join?

What is the use of field size property?

Write the use of data sheet form.

Create a query in Design View .

Define Sorting.

What is the use of Input Mask?

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

List of Field Properties ?

What is the use of field size property?

Name three methods for creating tables in MS-Access.

Write the use of data sheet form.

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

What is OLE Object in MS- Access?

Write down the use of filters in MS-Access.

List Some Advantages of Query.

List Some Advantage of IDE .

Create a query in Design View .

12th Computer Science Chapter 6 Preparation

Is this page helpful?