Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
What is a datasheet in Microsoft Access?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A datasheet is a tabular representation of database data arranged in rows and columns.
• It can display the contents of a table or the results returned by a query.
• Datasheet View is useful when users need to view or work with many records at the same time.
• It can display the contents of a table or the results returned by a query.
• Datasheet View is useful when users need to view or work with many records at the same time.
వివరణ:
Question 2
ప్రశ్న 2
When an ordinary Access table is opened from the Navigation Pane, which view normally displays its records in a grid of rows and columns?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Datasheet View displays table records in a grid resembling a spreadsheet.
• Fields appear as columns and records appear as rows.
• Design View is primarily used to define table structure and field properties rather than to display ordinary records for data entry.
• Fields appear as columns and records appear as rows.
• Design View is primarily used to define table structure and field properties rather than to display ordinary records for data entry.
వివరణ:
Question 3
ప్రశ్న 3
In an Access table displayed in Datasheet View, how are records and fields normally represented?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Each horizontal row in a table datasheet represents one record.
• Each vertical column represents one field or category of information.
• This tabular arrangement allows many database records to be viewed efficiently.
• Each vertical column represents one field or category of information.
• This tabular arrangement allows many database records to be viewed efficiently.
వివరణ:
Question 4
ప్రశ్న 4
Which symbol in the record selector area identifies the blank row used for entering a new record in an Access datasheet?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Access identifies the new-record row with an asterisk in the record selector area.
• Users can enter values into this row to create another record.
• This symbol distinguishes the blank new-record row from existing saved records.
• Users can enter values into this row to create another record.
• This symbol distinguishes the blank new-record row from existing saved records.
వివరణ:
Question 5
ప్రశ్న 5
Which keyboard shortcut can be used in desktop Microsoft Access to move directly to a New (blank) record for data entry?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Ctrl+Plus Sign (+) is a documented Access shortcut for moving to a new blank record.
• The same task can also be performed from Home > Records > New.
• The blank record can then be completed by entering values into its fields.
• The same task can also be performed from Home > Records > New.
• The blank record can then be completed by entering values into its fields.
వివరణ:
Question 6
ప్రశ్న 6
While entering a record in Datasheet View, which key normally moves the cursor to the next field in the same record?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Tab moves to the next field in the same row during normal data entry.
• The Left and Right Arrow keys or clicking another cell can also be used to move between fields.
• This supports efficient sequential entry of field values within a record.
• The Left and Right Arrow keys or clicking another cell can also be used to move between fields.
• This supports efficient sequential entry of field values within a record.
వివరణ:
Question 7
ప్రశ్న 7
While working in an Access table datasheet, which keys can be used to move to the next cell above or below in the same column?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Up Arrow and Down Arrow keys can move between cells vertically in a table column.
• This allows the user to move between the same field in different records.
• Tab is more commonly used to move horizontally to the next field in the current record.
• This allows the user to move between the same field in different records.
• Tab is more commonly used to move horizontally to the next field in the current record.
వివరణ:
Question 8
ప్రశ్న 8
A user has entered a new record in an Access datasheet and then moves to another record. What normally happens to the newly entered record?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Access normally commits record changes when the user moves to another record.
• Closing the table or form also causes the current record to be saved under normal conditions.
• Therefore users generally do not need to issue a separate file-save operation after every record entry.
• Closing the table or form also causes the current record to be saved under normal conditions.
• Therefore users generally do not need to issue a separate file-save operation after every record entry.
వివరణ:
Question 9
ప్రశ్న 9
Which keyboard shortcut explicitly saves changes to the current record in Microsoft Access?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Shift+Enter explicitly saves changes made to the current Access record.
• Access also normally saves changes automatically when the user moves to another record or closes the datasheet.
• The shortcut is useful when the user wants to commit the current record immediately.
• Access also normally saves changes automatically when the user moves to another record or closes the datasheet.
• The shortcut is useful when the user wants to commit the current record immediately.
వివరణ:
Question 10
ప్రశ్న 10
What is the purpose of the record selector located at the left side of a record in an Access datasheet?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The record selector identifies the row representing a particular record.
• Clicking a record selector can select the entire record for operations such as deletion.
• Record selectors can also display symbols indicating states such as current, edited or new records.
• Clicking a record selector can select the entire record for operations such as deletion.
• Record selectors can also display symbols indicating states such as current, edited or new records.
వివరణ:
Question 11
ప్రశ్న 11
In Access record navigation controls, what is the purpose of the Current Record box?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Current Record box shows the sequential position of the current record in the datasheet or form.
• A user can type a record number in this box and press Enter to move to that record.
• This sequential record number is not necessarily the same as the value stored in a primary-key field.
• A user can type a record number in this box and press Enter to move to that record.
• This sequential record number is not necessarily the same as the value stored in a primary-key field.
వివరణ:
Question 12
ప్రశ్న 12
Which set correctly lists the principal arrow navigation operations available on the Access record navigation bar?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Access record navigation buttons provide commands for moving to the first, previous, next and last record.
• These controls appear at the bottom of datasheets and many forms.
• They navigate between records rather than between database objects or table-design fields.
• These controls appear at the bottom of datasheets and many forms.
• They navigate between records rather than between database objects or table-design fields.
వివరణ:
Question 13
ప్రశ్న 13
A table contains thousands of records. The user knows part of a person's name and wants Access to highlight the first matching value as characters are typed without opening the full Find dialog. Which feature is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Search box on the record navigation bar can be used to locate matching data quickly.
• Access highlights the first matching value in real time as characters are entered.
• It is convenient for quick searches when browsing records in a datasheet or form.
• Access highlights the first matching value in real time as characters are entered.
• It is convenient for quick searches when browsing records in a datasheet or form.
వివరణ:
Question 14
ప్రశ్న 14
Which keyboard shortcut opens the Find and Replace dialog box for locating data in an Access datasheet?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Ctrl+F opens the Find and Replace dialog box with the Find functionality available.
• The user can specify the value to search for and control options such as where and how matching is performed.
• This is particularly useful when the datasheet contains many records.
• The user can specify the value to search for and control options such as where and how matching is performed.
• This is particularly useful when the datasheet contains many records.
వివరణ:
Question 15
ప్రశ్న 15
An existing record is being modified, and the record-selector indicator shows that the record is currently being edited. What does this indicate about the latest changes?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Access uses an edited-record indicator when the current record has unsaved changes.
• The indicator distinguishes an edited record from one already saved as currently displayed.
• A separate locked-record indicator is used when another user has locked the record.
• The indicator distinguishes an edited record from one already saved as currently displayed.
• A separate locked-record indicator is used when another user has locked the record.
వివరణ:
Question 16
ప్రశ్న 16
A user wants to remove an entire record from an Access table while working in Datasheet View. Which procedure is valid after selecting that record?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• An entire selected record can be deleted using Delete or Home > Records > Delete.
• Access also supports Ctrl+Minus Sign (-) for deleting a selected record.
• Deleting an entire record is different from clearing the contents of only one selected field.
• Access also supports Ctrl+Minus Sign (-) for deleting a selected record.
• Deleting an entire record is different from clearing the contents of only one selected field.
వివరణ:
Question 17
ప్రశ్న 17
Consider the following statements about Access Datasheet View:
1. It can display many records at the same time.
2. Fields are normally displayed as columns.
3. Moving to another record normally causes changes to the current record to be saved.
4. The Current Record number shown by navigation controls must always equal the table's primary-key value.
Which statements are correct?
1. It can display many records at the same time.
2. Fields are normally displayed as columns.
3. Moving to another record normally causes changes to the current record to be saved.
4. The Current Record number shown by navigation controls must always equal the table's primary-key value.
Which statements are correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Statements 1 and 2 correctly describe the tabular nature of Datasheet View.
• Statement 3 is correct because Access normally commits changes when the user moves to another record.
• Statement 4 is false because the Current Record number is a sequential navigation position and does not necessarily correspond to a field value such as the primary key.
• Statement 3 is correct because Access normally commits changes when the user moves to another record.
• Statement 4 is false because the Current Record number is a sequential navigation position and does not necessarily correspond to a field value such as the primary key.
వివరణ:
Question 18
ప్రశ్న 18
Assertion (A): The record number displayed in the Current Record box should not be treated as the record's primary-key value.
Reason (R): The Current Record box uses a sequential position counted from the beginning of the datasheet, independent of the values stored in table fields.
Choose the correct answer.
Reason (R): The Current Record box uses a sequential position counted from the beginning of the datasheet, independent of the values stored in table fields.
Choose the correct answer.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Current Record box represents a record's sequential position in the current datasheet or form.
• Microsoft specifically distinguishes that navigation number from values stored in database fields.
• Both statements are therefore true, and the Reason correctly explains the Assertion.
• Microsoft specifically distinguishes that navigation number from values stored in database fields.
• Both statements are therefore true, and the Reason correctly explains the Assertion.
వివరణ:
Question 19
ప్రశ్న 19
A user is entering data in a new Access record. Which sequence best reflects normal record-entry behaviour?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A new record can be entered in the blank new-record row of a datasheet.
• The user enters values into the appropriate fields and moves through them using Tab, arrow keys or mouse clicks.
• Moving to another record normally causes Access to save the newly entered record.
• The user enters values into the appropriate fields and moves through them using Tab, arrow keys or mouse clicks.
• Moving to another record normally causes Access to save the newly entered record.
వివరణ:
Question 20
ప్రశ్న 20
Match List I with List II:
List I
(a) Asterisk in record selector
(b) Ctrl+F
(c) Shift+Enter
(d) Current Record box
List II
1. Explicitly saves the current record
2. Opens the Find and Replace dialog box for searching
3. Identifies the new blank record row
4. Shows or accepts a sequential record position for navigation
Choose the correct matching code.
List I
(a) Asterisk in record selector
(b) Ctrl+F
(c) Shift+Enter
(d) Current Record box
List II
1. Explicitly saves the current record
2. Opens the Find and Replace dialog box for searching
3. Identifies the new blank record row
4. Shows or accepts a sequential record position for navigation
Choose the correct matching code.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The asterisk identifies the new-record row, giving (a)-3.
• Ctrl+F opens Find and Replace, giving (b)-2, while Shift+Enter explicitly saves the current record, giving (c)-1.
• The Current Record box displays or accepts a sequential record position, giving (d)-4.
• Ctrl+F opens Find and Replace, giving (b)-2, while Shift+Enter explicitly saves the current record, giving (c)-1.
• The Current Record box displays or accepts a sequential record position, giving (d)-4.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: B. A tabular display of data in rows and columns from a table, query or datasheet-based object సమాధానం: B.
-
Question 2 ప్రశ్న 2Answer: D. Datasheet View సమాధానం: D.
-
Question 3 ప్రశ్న 3Answer: A. Records as rows and fields as columns సమాధానం: A.
-
Question 4 ప్రశ్న 4Answer: C. An asterisk సమాధానం: C.
-
Question 5 ప్రశ్న 5Answer: A. Ctrl+Plus Sign (+) సమాధానం: A.
-
Question 6 ప్రశ్న 6Answer: C. Tab సమాధానం: C.
-
Question 7 ప్రశ్న 7Answer: D. Up Arrow and Down Arrow సమాధానం: D.
-
Question 8 ప్రశ్న 8Answer: B. Access normally saves the record automatically. సమాధానం: B.
-
Question 9 ప్రశ్న 9Answer: C. Shift+Enter సమాధానం: C.
-
Question 10 ప్రశ్న 10Answer: A. To identify and select an entire record సమాధానం: A.
-
Question 11 ప్రశ్న 11Answer: B. It displays a sequential record number and can be used to navigate to a specified record number. సమాధానం: B.
-
Question 12 ప్రశ్న 12Answer: D. First Record, Previous Record, Next Record and Last Record సమాధానం: D.
-
Question 13 ప్రశ్న 13Answer: D. Search box on the record navigation bar సమాధానం: D.
-
Question 14 ప్రశ్న 14Answer: B. Ctrl+F సమాధానం: B.
-
Question 15 ప్రశ్న 15Answer: C. Changes to that record have not yet been saved. సమాధానం: C.
-
Question 16 ప్రశ్న 16Answer: A. Press Delete or use Home > Records > Delete. సమాధానం: A.
-
Question 17 ప్రశ్న 17Answer: B. 1, 2 and 3 only సమాధానం: B.
-
Question 18 ప్రశ్న 18Answer: D. Both Assertion and Reason are true, and Reason is the correct explanation of Assertion. సమాధానం: D.
-
Question 19 ప్రశ్న 19Answer: A. Move to the new-record row, enter field values, then move to another record so Access commits the record. సమాధానం: A.
-
Question 20 ప్రశ్న 20Answer: C. (a)-3, (b)-2, (c)-1, (d)-4 సమాధానం: C.