Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
What is the primary purpose of a form in a Microsoft Access desktop database?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Access forms provide an interface through which users can work with database information.
• Forms can be designed for adding, editing, viewing and displaying data stored in tables or supplied by queries.
• A well-designed form can make data entry easier and more accurate than working directly with complex tables.
• Forms can be designed for adding, editing, viewing and displaying data stored in tables or supplied by queries.
• A well-designed form can make data entry easier and more accurate than working directly with complex tables.
వివరణ:
Question 2
ప్రశ్న 2
A table named Employees is selected in the Navigation Pane, and the user chooses Create > Form. What type of form does the Access Form tool normally create?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Form tool quickly creates a single-item form based on the selected table or query.
• The form displays information for one record at a time and adds fields from the underlying data source.
• The resulting form can later be modified in Layout view or Design view.
• The form displays information for one record at a time and adds fields from the underlying data source.
• The resulting form can later be modified in Layout view or Design view.
వివరణ:
Question 3
ప్రశ్న 3
Which Access form-creation method is especially useful when the user wants to choose exactly which fields will appear and may need fields from more than one related table or query?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Form Wizard allows the user to select the fields that should appear on the form.
• It can include fields from more than one table or query when the required relationships have been established.
• This provides more selection control than the one-click Form tool.
• It can include fields from more than one table or query when the required relationships have been established.
• This provides more selection control than the one-click Form tool.
వివరణ:
Question 4
ప్రశ్న 4
A database designer wants to begin with an empty form and manually add the required fields and controls. Which Access option is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Blank Form provides an empty form as a starting point for custom form construction.
• Fields can subsequently be added from the Field List pane, and other controls can be inserted as required.
• This approach is useful when the designer wants greater control over the form's structure.
• Fields can subsequently be added from the Field List pane, and other controls can be inserted as required.
• This approach is useful when the designer wants greater control over the form's structure.
వివరణ:
Question 5
ప్రశ్న 5
Which statement correctly describes a Split Form in Microsoft Access?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A Split Form combines Form view and Datasheet view in the same form.
• Both portions are connected to the same data source and remain synchronized.
• A user can locate a record quickly in the datasheet portion and then view or edit it through the form portion.
• Both portions are connected to the same data source and remain synchronized.
• A user can locate a record quickly in the datasheet portion and then view or edit it through the form portion.
వివరణ:
Question 6
ప్రశ్న 6
A user needs an Access form that displays several records at the same time but offers more customization than an ordinary datasheet. Which form type is appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A Multiple Items form, also called a continuous form, can display several records simultaneously.
• Its data may appear in rows and columns similar to a datasheet.
• Because it is a form, it supports greater customization such as graphical elements, buttons and other controls.
• Its data may appear in rows and columns similar to a datasheet.
• Because it is a form, it supports greater customization such as graphical elements, buttons and other controls.
వివరణ:
Question 7
ప్రశ్న 7
Which property of an Access form specifies the table, query or SQL statement that supplies the form's underlying records?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Record Source property specifies the source of data for an Access form.
• Its setting can be a table name, query name or SQL statement.
• Controls on the form can then be bound to fields available from that record source.
• Its setting can be a table name, query name or SQL statement.
• Controls on the form can then be bound to fields available from that record source.
వివరణ:
Question 8
ప్రశ్న 8
What is meant by a bound control on an Access form?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A bound control is connected to a field from the form's underlying record source.
• It displays the corresponding field value for the current record and can permit editing when the data source and form settings allow it.
• Bound controls are commonly used for ordinary data-entry fields.
• It displays the corresponding field value for the current record and can permit editing when the data source and form settings allow it.
• Bound controls are commonly used for ordinary data-entry fields.
వివరణ:
Question 9
ప్రశ్న 9
Which property of a text box control determines the field or expression whose value is displayed in that text box?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Control Source determines where a control obtains the value that it displays.
• A Control Source can identify a field from the form's record source or contain an expression.
• Record Source applies to the form or report as a whole rather than to an individual text box.
• A Control Source can identify a field from the form's record source or contain an expression.
• Record Source applies to the form or report as a whole rather than to an individual text box.
వివరణ:
Question 10
ప్రశ్న 10
Which statement correctly describes an unbound text box on an Access form?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• An unbound text box has no field specified as its Control Source.
• It can be used to accept temporary input or to display information that is not directly stored in an underlying field.
• An expression can also be used with a text box to display a calculated result.
• It can be used to accept temporary input or to display information that is not directly stored in an underlying field.
• An expression can also be used with a text box to display a calculated result.
వివరణ:
Question 11
ప్రశ్న 11
A form contains Quantity and UnitPrice fields. A text box has the Control Source expression =[Quantity]*[UnitPrice]. What type of control is this text box?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A text box whose Control Source contains an expression is a calculated control.
• The expression =[Quantity]*[UnitPrice] calculates a value using other controls or fields.
• The calculated result is displayed by the control and is not itself stored as a field value merely because the expression appears on the form.
• The expression =[Quantity]*[UnitPrice] calculates a value using other controls or fields.
• The calculated result is displayed by the control and is not itself stored as a field value merely because the expression appears on the form.
వివరణ:
Question 12
ప్రశ్న 12
A table contains a Yes/No field named IsVerified. Which control is generally the most user-friendly choice for displaying and entering this two-state value on a form?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A check box provides a clear graphical representation of a Yes/No value.
• Access commonly uses a check box as the default display control for a Yes/No field.
• Selecting or clearing the check box provides an intuitive way to enter the two possible states.
• Access commonly uses a check box as the default display control for a Yes/No field.
• Selecting or clearing the check box provides an intuitive way to enter the two possible states.
వివరణ:
Question 13
ప్రశ్న 13
A Department field should let a user select a value from a compact drop-down list of permitted departments instead of repeatedly typing department names. Which form control is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A combo box provides a compact control that can display a drop-down list of choices.
• It can be bound to a field so that the selected value is associated with the current record.
• Providing predefined choices can improve consistency and reduce typing errors during data entry.
• It can be bound to a field so that the selected value is associated with the current record.
• Providing predefined choices can improve consistency and reduce typing errors during data entry.
వివరణ:
Question 14
ప్రశ్న 14
A form needs a clickable control that opens another form, finds a record or runs another predefined action. Which Access control is designed for this purpose?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A command button is used to initiate an action or series of actions from an Access form.
• For example, a button can open another form, open a report, find a record or run a macro.
• Its behaviour can be defined through an embedded macro, VBA event procedure or the Command Button Wizard.
• For example, a button can open another form, open a report, find a record or run a macro.
• Its behaviour can be defined through an embedded macro, VBA event procedure or the Command Button Wizard.
వివరణ:
Question 15
ప్రశ్న 15
What is the principal purpose of a label control on an Access form?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Labels display descriptive text on a form and commonly identify the purpose of nearby controls.
• They can also provide headings or short instructions that make the form easier to understand.
• A label does not serve as the form's underlying data source.
• They can also provide headings or short instructions that make the form easier to understand.
• A label does not serve as the form's underlying data source.
వివరణ:
Question 16
ప్రశ్న 16
A designer wants to resize and rearrange controls on a form while still seeing actual data in the form. Which Access view is particularly suitable?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Layout view allows design changes while the form is actually displaying data.
• This makes it useful for resizing, rearranging and visually adjusting controls based on real content.
• Design view provides deeper structural control but does not show the underlying data while the form is being designed.
• This makes it useful for resizing, rearranging and visually adjusting controls based on real content.
• Design view provides deeper structural control but does not show the underlying data while the form is being designed.
వివరణ:
Question 17
ప్రశ్న 17
Consider the following statements about Access form design:
1. Design view provides a detailed view of the form's structure.
2. In Design view, the form is not actually running and underlying data is not displayed.
3. Design view can be used to add controls and modify form sections.
4. Design view is intended only for printing forms and cannot change their structure.
Which statements are correct?
1. Design view provides a detailed view of the form's structure.
2. In Design view, the form is not actually running and underlying data is not displayed.
3. Design view can be used to add controls and modify form sections.
4. Design view is intended only for printing forms and cannot change their structure.
Which statements are correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Statements 1 and 2 correctly describe Design view as a detailed structural view in which the form is not actually running.
• Statement 3 is correct because Design view supports adding controls, resizing sections and changing form properties.
• Statement 4 is false because Design view is specifically intended for structural design rather than only for printing.
• Statement 3 is correct because Design view supports adding controls, resizing sections and changing form properties.
• Statement 4 is false because Design view is specifically intended for structural design rather than only for printing.
వివరణ:
Question 18
ప్రశ్న 18
Assertion (A): Dragging a field from the Field List pane onto an Access form can create a control bound to that field.
Reason (R): Access can choose a control appropriate to the field's data type when a field is added from the Field List.
Choose the correct answer.
Reason (R): Access can choose a control appropriate to the field's data type when a field is added from the Field List.
Choose the correct answer.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Fields from the Field List can be dragged onto a form to create bound controls.
• Access selects an appropriate control according to the field type; for example, many text and numeric fields create text boxes, while a Yes/No field commonly creates a check box.
• Both statements are true, and the Reason correctly explains the behaviour described in the Assertion.
• Access selects an appropriate control according to the field type; for example, many text and numeric fields create text boxes, while a Yes/No field commonly creates a check box.
• Both statements are true, and the Reason correctly explains the behaviour described in the Assertion.
వివరణ:
Question 19
ప్రశ్న 19
A data-entry form already has a Record Source. The designer wants to add another existing field from that source without recreating the form. Which action is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Field List pane displays fields that can be added to the form from its available data sources.
• Add Existing Fields or the Alt+F8 shortcut can display this pane in supported desktop Access views.
• Dragging the required field onto the form creates an appropriate control without requiring the form to be rebuilt.
• Add Existing Fields or the Alt+F8 shortcut can display this pane in supported desktop Access views.
• Dragging the required field onto the form creates an appropriate control without requiring the form to be rebuilt.
వివరణ:
Question 20
ప్రశ్న 20
Match List I with List II:
List I
(a) Form tool
(b) Form Wizard
(c) Split Form
(d) Multiple Items
List II
1. Displays several records while providing more form customization than a datasheet
2. Quickly creates a single-item form from a selected table or query
3. Allows selective choice of fields and can use fields from related tables or queries
4. Displays synchronized Form and Datasheet views
Choose the correct matching code.
List I
(a) Form tool
(b) Form Wizard
(c) Split Form
(d) Multiple Items
List II
1. Displays several records while providing more form customization than a datasheet
2. Quickly creates a single-item form from a selected table or query
3. Allows selective choice of fields and can use fields from related tables or queries
4. Displays synchronized Form and Datasheet views
Choose the correct matching code.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Form tool quickly creates a single-item form, giving (a)-2.
• Form Wizard permits selective field choice, giving (b)-3, while Split Form combines synchronized Form and Datasheet views, giving (c)-4.
• Multiple Items displays several records in a customizable form, giving (d)-1.
• Form Wizard permits selective field choice, giving (b)-3, while Split Form combines synchronized Form and Datasheet views, giving (c)-4.
• Multiple Items displays several records in a customizable form, giving (d)-1.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: A. To provide a user-friendly interface for adding, editing, viewing or displaying database data సమాధానం: A.
-
Question 2 ప్రశ్న 2Answer: C. A single-item form containing fields from the selected table or query సమాధానం: C.
-
Question 3 ప్రశ్న 3Answer: B. Form Wizard సమాధానం: B.
-
Question 4 ప్రశ్న 4Answer: D. Blank Form సమాధానం: D.
-
Question 5 ప్రశ్న 5Answer: D. It displays synchronized Form and Datasheet views of the same underlying data. సమాధానం: D.
-
Question 6 ప్రశ్న 6Answer: A. Multiple Items form సమాధానం: A.
-
Question 7 ప్రశ్న 7Answer: C. Record Source సమాధానం: C.
-
Question 8 ప్రశ్న 8Answer: B. A control connected to a field in the form's data source so that it can display and, where permitted, edit that field's data సమాధానం: B.
-
Question 9 ప్రశ్న 9Answer: A. Control Source సమాధానం: A.
-
Question 10 ప్రశ్న 10Answer: D. It is not connected directly to a field and can be used for calculations or input that is not stored directly in a table field. సమాధానం: D.
-
Question 11 ప్రశ్న 11Answer: C. A calculated control సమాధానం: C.
-
Question 12 ప్రశ్న 12Answer: B. Check box సమాధానం: B.
-
Question 13 ప్రశ్న 13Answer: D. Combo box సమాధానం: D.
-
Question 14 ప్రశ్న 14Answer: C. Command button సమాధానం: C.
-
Question 15 ప్రశ్న 15Answer: A. To display descriptive text such as a caption or instruction that helps identify another control సమాధానం: A.
-
Question 16 ప్రశ్న 16Answer: B. Layout view సమాధానం: B.
-
Question 17 ప్రశ్న 17Answer: C. 1, 2 and 3 only సమాధానం: C.
-
Question 18 ప్రశ్న 18Answer: D. Both Assertion and Reason are true, and Reason is the correct explanation of Assertion. సమాధానం: D.
-
Question 19 ప్రశ్న 19Answer: B. Open the Field List using Add Existing Fields or Alt+F8 and drag the required field onto the form. సమాధానం: B.
-
Question 20 ప్రశ్న 20Answer: A. (a)-2, (b)-3, (c)-4, (d)-1 సమాధానం: A.