12th Class Computer Chapter 10 Using Datasheets to enter and view Data Questions Answer

12th Class Computer Chapter 10 Using Datasheets to enter and view Data Questions Answer

[toggle title=”In which form information is arranged in datasheet view? ” state=”close”]
In datasheet view, information is arranged in rows and columns. [/toggle]
[toggle title=”What is datasheet? ” state=”close”]
Datasheet is the most common way of viewing a table or a query. In this view, each column represents a single field in our database and each row represents a record. [/toggle]
[toggle title=”In which item is affected by changing in datasheet view. ” state=”close”]
When we make change in datasheet view only the layout of datasheet view is affected.[/toggle]
[toggle title=”Which techniques are resembled with the techniques for modifying the design of a datasheet?” state=”close”]
Many of the techniques for modifying the design of a datasheet resemble techniques used in Microsoft Excel worksheets. [/toggle]
[toggle title=”How can you change the width of a column in a datasheet?” state=”close”]
We can change the width of a column in a datasheet by dragging the right border of the column heading. [/toggle]
[toggle title=”How can you change the height of a row? ” state=”close”]
We can you change the height of a row using a similar technique with the row selector, the button to the left of the row.[/toggle]
[toggle title=”How can Access determine the most appropriate width for the column?” state=”close”]
Access can determine the most appropriate width for the column by double clicking the right border of the column heading.[/toggle]
[toggle title=”Can you change the arrangement of the columns? ” state=”close”]
Yes we can also change the arrangement of the columns in a datasheet.[/toggle]
[toggle title=”Does changing the order of columns make effect on the underlying order of the fields?” state=”close”]
Changing the order of columns in a datasheet as displayed in design view or other views.[/toggle]
[toggle title=”How can you change the field name? ” state=”close”]
We can change the field name by double-clicking the column heading typing a new name and pressing enter. [/toggle]
[toggle title=”What is the procedure to delete a column? ” state=”close”]
To delete a column select it by clicking the column heading and then choose delete column from the Edit menu. When we delete a column, we are permanently removing a field together with all its data from the table.[/toggle]
[toggle title=”How can we hide the columns? ” state=”close”]
We can temporarily hide one or more columns by selecting them and choosing hide columns from the format menu. [/toggle]
[toggle title=”What is the procedure to visible the hidden columns? ” state=”close”]
We can later make one or more hidden columns visible again by choosing unhide column from the format menu and selecting all the columns that we want to reappear. [/toggle]
[toggle title=”Does the Access save any changes that effect the underlying structure of a table?” state=”close”]
Access automatically saves any changes that affect the underlying structure of a table renaming, adding or deleting a field, as well as edits to each record.[/toggle]
[toggle title=”How do we display a Subdatasheet? ” state=”close”]
We display a Subdatasheet by clicking the plus symbol (+) in the left Column of one of the records.[/toggle]
[toggle title=”What is the function of Subdatasheet? ” state=”close”]
A Subdatasheet lists one or more records from another table which are related to the records of the table displayed in the datasheet. [/toggle]
[toggle title=”How can you delete a group of records? ” state=”close”]
To select the records click the row selector of one record and drag the highlight up or down over the other records in the group.[/toggle]
[toggle title=”Which is the easiest way to sort the records in a datasheet? ” state=”close”]
The easiest way to sort the records in a datasheet is to designate a single Column of information to use as the sort key. [/toggle]
[toggle title=”How many ways to apply filters to the data in a table? ” state=”close”]
There are three different ways to apply filters to the data in a table.[/toggle]
[toggle title=”What does filter by selection allow us?” state=”close”]
Filter by selection allows us to establish filter criteria for only a single field at one time. The records which are displayed depend on how we select text in the field.[/toggle]