Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
Which statement correctly describes manual data entry and editing in a Microsoft Access desktop database?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Access supports manual data entry and editing through forms and datasheets when their underlying record sources are updateable.
• Forms can provide a more controlled interface, while Datasheet View allows direct work with rows and columns.
• Reports are primarily intended for presenting data rather than ordinary record entry.
• Forms can provide a more controlled interface, while Datasheet View allows direct work with rows and columns.
• Reports are primarily intended for presenting data rather than ordinary record entry.
వివరణ:
Question 2
ప్రశ్న 2
Which keyboard shortcut moves to a new blank record for data entry in Microsoft Access?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Ctrl+Plus Sign (+) moves to a new blank record in Access.
• The new record can then be completed by entering values in its fields.
• Ctrl+Minus Sign (-) performs a different operation by deleting the current record in a datasheet.
• The new record can then be completed by entering values in its fields.
• Ctrl+Minus Sign (-) performs a different operation by deleting the current record in a datasheet.
వివరణ:
Question 3
ప్రశ్న 3
When a new record is added to an Access table, how does Access normally add it to the table?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Adding a record creates another item in the underlying table rather than replacing an existing record.
• Microsoft describes a newly added record as being appended to the table.
• Existing records remain stored unless they are separately edited or deleted.
• Microsoft describes a newly added record as being appended to the table.
• Existing records remain stored unless they are separately edited or deleted.
వివరణ:
Question 4
ప్రశ్న 4
A user finishes entering a new record in an Access form and then moves to another record. What normally happens to the newly entered record?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Access normally saves a newly entered record when the user moves to another record.
• Closing the table or form also normally causes the new record to be saved.
• A separate Save command is therefore not required after every normal record entry.
• Closing the table or form also normally causes the new record to be saved.
• A separate Save command is therefore not required after every normal record entry.
వివరణ:
Question 5
ప్రశ్న 5
Which keyboard shortcut explicitly saves changes to the current record in Microsoft Access?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Shift+Enter explicitly saves changes to the current Access record.
• Access also commits record changes automatically during several normal navigation actions.
• This shortcut is useful when the user wants to save the current record immediately.
• Access also commits record changes automatically during several normal navigation actions.
• This shortcut is useful when the user wants to save the current record immediately.
వివరణ:
Question 6
ప్రశ్న 6
While editing data in an Access text field, which key can be used to select the field for editing after navigating to it?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Microsoft documents F2 as a key that can be used when editing a field after navigating to it.
• The user can then place the insertion point and modify the stored text as required.
• Other function keys perform different Access operations.
• The user can then place the insertion point and modify the stored text as required.
• Other function keys perform different Access operations.
వివరణ:
Question 7
ప్రశ్న 7
Which keyboard shortcut inserts the current system date into a field during Access data entry?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Ctrl+Semicolon (;) inserts the current system date into an Access field.
• This can speed up repetitive entry of today's date.
• The shortcut for inserting the current time is different.
• This can speed up repetitive entry of today's date.
• The shortcut for inserting the current time is different.
వివరణ:
Question 8
ప్రశ్న 8
Which keyboard shortcut inserts the current system time into a field during Microsoft Access data entry?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Ctrl+Shift+Colon (:) inserts the current system time into the active field.
• It is distinct from Ctrl+Semicolon (;), which inserts the current date.
• Both shortcuts can reduce manual typing during repetitive data entry.
• It is distinct from Ctrl+Semicolon (;), which inserts the current date.
• Both shortcuts can reduce manual typing during repetitive data entry.
వివరణ:
Question 9
ప్రశ్న 9
While entering a new Access record, the value needed in the current field is the same as the value in the corresponding field of the previous record. Which shortcut can copy that previous-record value?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Ctrl+Apostrophe (') inserts the value from the same field in the previous record.
• It is useful when consecutive records contain repeated information in a particular field.
• The shortcut copies a field value rather than an entire record.
• It is useful when consecutive records contain repeated information in a particular field.
• The shortcut copies a field value rather than an entire record.
వివరణ:
Question 10
ప్రశ్న 10
A field has a defined Default Value, and the user wants to insert that default while entering a record. Which Access shortcut performs this operation?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Ctrl+Alt+Spacebar inserts the field's defined default value during data entry.
• A default value provides a predefined starting value for new records.
• The user can still change the inserted value when the field and record are editable.
• A default value provides a predefined starting value for new records.
• The user can still change the inserted value when the field and record are editable.
వివరణ:
Question 11
ప్రశ్న 11
Which keyboard shortcut inserts a new line within an editable Short Text or Long Text field in Microsoft Access?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Ctrl+Enter inserts a new line within an appropriate Short Text or Long Text field.
• This is useful when a field needs multiple lines of textual content.
• Shift+Enter has a different Access function: it explicitly saves the current record.
• This is useful when a field needs multiple lines of textual content.
• Shift+Enter has a different Access function: it explicitly saves the current record.
వివరణ:
Question 12
ప్రశ్న 12
In an Access datasheet, which keyboard shortcut deletes the current record?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Ctrl+Minus Sign (-) deletes the current record in a datasheet.
• A record can also be selected and deleted through Home > Records > Delete or by pressing Delete after selecting the entire record.
• Deleting a complete record is different from deleting only the contents of one field.
• A record can also be selected and deleted through Home > Records > Delete or by pressing Delete after selecting the entire record.
• Deleting a complete record is different from deleting only the contents of one field.
వివరణ:
Question 13
ప్రశ్న 13
A record contains an incorrect phone number, but all other information in that record must remain. What is the most appropriate Access operation?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Individual field values can be modified without deleting the complete record.
• If only one stored value is wrong, editing or clearing that particular field preserves the remaining record information.
• Deleting the entire record would unnecessarily remove every field value associated with that record.
• If only one stored value is wrong, editing or clearing that particular field preserves the remaining record information.
• Deleting the entire record would unnecessarily remove every field value associated with that record.
వివరణ:
Question 14
ప్రశ్న 14
An Access record on the 'one' side of a one-to-many relationship has related records. What may Access do by default when a user attempts to delete that record?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Access can prevent deletion of a record when related records exist and deleting it would violate enforced referential integrity.
• This behaviour helps protect the consistency of related database data.
• Related records are not automatically deleted unless the relationship and cascade-delete settings specifically permit that behaviour.
• This behaviour helps protect the consistency of related database data.
• Related records are not automatically deleted unless the relationship and cascade-delete settings specifically permit that behaviour.
వివరణ:
Question 15
ప్రశ్న 15
A user has changed both the current field and other fields in the current Access record, but the record changes have not yet been committed. According to Access undo behaviour, how can the user undo both the current-field edit and then the remaining changes to the current record?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• When both the current field and the current record contain uncommitted changes, Esc can be used twice.
• The first Esc undoes changes in the current field, and the second Esc undoes the remaining changes to the current record.
• This behaviour applies before those changes become permanently committed through subsequent database activity.
• The first Esc undoes changes in the current field, and the second Esc undoes the remaining changes to the current record.
• This behaviour applies before those changes become permanently committed through subsequent database activity.
వివరణ:
Question 16
ప్రశ్న 16
A user changes a record, moves to another record so the change is saved, but then immediately realizes the edit was wrong. Which statement about Access undo behaviour is correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Access may allow a recently committed data change to be undone through the Undo command.
• Microsoft notes that the opportunity is lost after actions such as beginning to edit another record, applying or removing a filter, or switching to another window or document tab.
• Esc is primarily used for undoing current uncommitted field or record changes and is not an unlimited recovery mechanism.
• Microsoft notes that the opportunity is lost after actions such as beginning to edit another record, applying or removing a filter, or switching to another window or document tab.
• Esc is primarily used for undoing current uncommitted field or record changes and is not an unlimited recovery mechanism.
వివరణ:
Question 17
ప్రశ్న 17
A field in an Access table is defined to accept numeric data. During manual data entry, a user attempts to enter incompatible text that does not satisfy the field's data type. What should normally be expected?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Access fields are defined to accept particular types of data, such as numbers, dates or text.
• An entry that does not conform to the field's required data type can be rejected with an error message.
• Data-type enforcement helps preserve consistency and integrity in stored data.
• An entry that does not conform to the field's required data type can be rejected with an error message.
• Data-type enforcement helps preserve consistency and integrity in stored data.
వివరణ:
Question 18
ప్రశ్న 18
While attempting to edit a record in a multiuser Access database, the record selector indicates that the record is locked by another user. What does this normally mean?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Access can display a locked-record indicator when another user has locked a record for editing.
• While the record remains locked, the current user cannot modify it.
• This is different from the edited-record indicator, which denotes unsaved changes made by the current user.
• While the record remains locked, the current user cannot modify it.
• This is different from the edited-record indicator, which denotes unsaved changes made by the current user.
వివరణ:
Question 19
ప్రశ్న 19
Which statement about editing stored data through an Access query Datasheet view is correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Whether a query result is updateable depends on how the query is constructed.
• Some query datasheets allow edits that update underlying table data, while others are non-updateable.
• Microsoft specifically identifies crosstab query results and calculated fields among data that cannot be directly edited in this way.
• Some query datasheets allow edits that update underlying table data, while others are non-updateable.
• Microsoft specifically identifies crosstab query results and calculated fields among data that cannot be directly edited in this way.
వివరణ:
Question 20
ప్రశ్న 20
Match List I with List II:
List I
(a) Ctrl+Semicolon (;)
(b) Ctrl+Shift+Colon (:)
(c) Ctrl+Alt+Spacebar
(d) Ctrl+Apostrophe (')
List II
1. Inserts the current time
2. Inserts the field's default value
3. Inserts the value from the same field in the previous record
4. Inserts the current date
Choose the correct matching code.
List I
(a) Ctrl+Semicolon (;)
(b) Ctrl+Shift+Colon (:)
(c) Ctrl+Alt+Spacebar
(d) Ctrl+Apostrophe (')
List II
1. Inserts the current time
2. Inserts the field's default value
3. Inserts the value from the same field in the previous record
4. Inserts the current date
Choose the correct matching code.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Ctrl+Semicolon inserts the current date, giving (a)-4, while Ctrl+Shift+Colon inserts the current time, giving (b)-1.
• Ctrl+Alt+Spacebar inserts a field's default value, giving (c)-2.
• Ctrl+Apostrophe copies the value from the corresponding field in the previous record, giving (d)-3.
• Ctrl+Alt+Spacebar inserts a field's default value, giving (c)-2.
• Ctrl+Apostrophe copies the value from the corresponding field in the previous record, giving (d)-3.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: B. Data can be entered or edited through an updateable form or directly in an updateable datasheet. సమాధానం: B.
-
Question 2 ప్రశ్న 2Answer: D. Ctrl+Plus Sign (+) సమాధానం: D.
-
Question 3 ప్రశ్న 3Answer: A. It appends the new record to the table. సమాధానం: A.
-
Question 4 ప్రశ్న 4Answer: C. Access normally saves the newly entered record. సమాధానం: C.
-
Question 5 ప్రశ్న 5Answer: C. Shift+Enter సమాధానం: C.
-
Question 6 ప్రశ్న 6Answer: A. F2 సమాధానం: A.
-
Question 7 ప్రశ్న 7Answer: D. Ctrl+Semicolon (;) సమాధానం: D.
-
Question 8 ప్రశ్న 8Answer: B. Ctrl+Shift+Colon (:) సమాధానం: B.
-
Question 9 ప్రశ్న 9Answer: A. Ctrl+Apostrophe (') సమాధానం: A.
-
Question 10 ప్రశ్న 10Answer: C. Ctrl+Alt+Spacebar సమాధానం: C.
-
Question 11 ప్రశ్న 11Answer: D. Ctrl+Enter సమాధానం: D.
-
Question 12 ప్రశ్న 12Answer: B. Ctrl+Minus Sign (-) సమాధానం: B.
-
Question 13 ప్రశ్న 13Answer: C. Select or edit only the PhoneNumber field value and replace or remove that value. సమాధానం: C.
-
Question 14 ప్రశ్న 14Answer: A. Prevent the deletion when it would violate referential integrity involving related data. సమాధానం: A.
-
Question 15 ప్రశ్న 15Answer: B. Press Esc twice. సమాధానం: B.
-
Question 16 ప్రశ్న 16Answer: D. The Undo command may still reverse the change, but beginning to edit another record, changing a filter, or switching to another window or document tab can make the change permanent. సమాధానం: D.
-
Question 17 ప్రశ్న 17Answer: A. Access rejects the incompatible entry and displays an error or validation message. సమాధానం: A.
-
Question 18 ప్రశ్న 18Answer: D. Another user currently has the record locked, so it cannot be edited by the current user at that moment. సమాధానం: D.
-
Question 19 ప్రశ్న 19Answer: C. Some query results are editable, but results such as crosstab queries and calculated fields cannot be edited directly in the ordinary way. సమాధానం: C.
-
Question 20 ప్రశ్న 20Answer: B. (a)-4, (b)-1, (c)-2, (d)-3 సమాధానం: B.