Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
What is the primary purpose of a report in Microsoft Access?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Access reports are primarily used to view, format and summarize database information.
• Reports are especially useful for organized presentation, summaries and printed output.
• The underlying data normally comes from tables or queries rather than being permanently stored in the report itself.
• Reports are especially useful for organized presentation, summaries and printed output.
• The underlying data normally comes from tables or queries rather than being permanently stored in the report itself.
వివరణ:
Question 2
ప్రశ్న 2
A table named Employees is selected in the Navigation Pane and the user chooses Create > Report. What does the Report tool normally do?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Report tool is the quickest way to create a simple report from a selected table or query.
• It includes all fields from the selected record source.
• Access creates the report immediately and displays it in Layout view.
• It includes all fields from the selected record source.
• Access creates the report immediately and displays it in Layout view.
వివరణ:
Question 3
ప్రశ్న 3
Which Access report-creation feature is most appropriate when the user wants to choose specific fields and specify grouping, sorting and layout options through a guided sequence of steps?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Report Wizard guides the user through several report-design decisions.
• It allows selection of fields and specification of grouping, sorting and layout options.
• It provides more control during initial report creation than the one-click Report tool.
• It allows selection of fields and specification of grouping, sorting and layout options.
• It provides more control during initial report creation than the one-click Report tool.
వివరణ:
Question 4
ప్రశ్న 4
What happens when Create > Blank Report is selected in Microsoft Access?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Blank Report provides an empty report starting point.
• Access opens it in Layout view and displays the Field List pane.
• The designer can then drag the required fields onto the report and arrange them as needed.
• Access opens it in Layout view and displays the Field List pane.
• The designer can then drag the required fields onto the report and arrange them as needed.
వివరణ:
Question 5
ప్రశ్న 5
Which Access report tool opens a completely blank report directly in Design view so that the designer can manually add the required fields and controls?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Report Design opens a blank report directly in Design view.
• It is suitable when the user wants detailed control over sections, controls and report structure from the beginning.
• Blank Report differs because it initially opens a blank report in Layout view.
• It is suitable when the user wants detailed control over sections, controls and report structure from the beginning.
• Blank Report differs because it initially opens a blank report in Layout view.
వివరణ:
Question 6
ప్రశ్న 6
What does the Record Source of an Access report determine?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A report obtains its underlying data through its Record Source.
• The source can be a table, named query or an embedded query based on an SQL statement.
• The fields available from that source determine which database information can be displayed in the report.
• The source can be a table, named query or an embedded query based on an SQL statement.
• The fields available from that source determine which database information can be displayed in the report.
వివరణ:
Question 7
ప్రశ్న 7
A report needs CustomerName from a Customers table and OrderAmount from a related Orders table. Which approach is generally appropriate for supplying the required combined data to the report?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• When required report data comes from more than one related table, a query can combine the necessary information.
• That query can then be used as the report's Record Source.
• This avoids unnecessary duplication of stored data while providing the report with the required fields.
• That query can then be used as the report's Record Source.
• This avoids unnecessary duplication of stored data while providing the report with the required fields.
వివరణ:
Question 8
ప్రశ్న 8
In an Access report, which section normally prints once for every row in the report's record source?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Detail section prints once for every row supplied by the report's record source.
• Controls representing ordinary record-level information are commonly placed in this section.
• Header and footer sections have different repetition rules.
• Controls representing ordinary record-level information are commonly placed in this section.
• Header and footer sections have different repetition rules.
వివరణ:
Question 9
ప్రశ్న 9
Which report section prints only once at the end of an Access report and is suitable for an overall report total?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Report Footer prints only once at the end of the complete report.
• It is suitable for totals or summary information applying to the entire report.
• A Group Footer instead repeats at the end of each group.
• It is suitable for totals or summary information applying to the entire report.
• A Group Footer instead repeats at the end of each group.
వివరణ:
Question 10
ప్రశ్న 10
A report groups records by District, and a subtotal must appear after the records for each District. In which report section is that subtotal most appropriately placed?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A Group Footer appears at the end of each group of records.
• It is specifically suitable for group-level summaries such as subtotals.
• A Report Footer would normally be used for an overall total across the complete report.
• It is specifically suitable for group-level summaries such as subtotals.
• A Report Footer would normally be used for an overall total across the complete report.
వివరణ:
Question 11
ప్రశ్న 11
Which Access report section appears at the end of every printed page and is commonly used for information such as page numbers?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Page Footer appears at the bottom of every report page.
• It is appropriate for recurring per-page information such as page numbers.
• The Report Footer appears only once at the end of the entire report.
• It is appropriate for recurring per-page information such as page numbers.
• The Report Footer appears only once at the end of the entire report.
వివరణ:
Question 12
ప్రశ్న 12
Which Access view should be used when the main requirement is to inspect how a report will appear when printed?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Print Preview shows the report as it is expected to appear on printed pages.
• It helps the user inspect pagination, margins and the overall printed arrangement before printing.
• Datasheet and SQL views serve different database purposes.
• It helps the user inspect pagination, margins and the overall printed arrangement before printing.
• Datasheet and SQL views serve different database purposes.
వివరణ:
Question 13
ప్రశ్న 13
A report was saved yesterday. Today, a record in its underlying table is changed, and the report is opened again. What normally happens?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Saving a report saves its design rather than creating a permanent duplicate of all source records.
• When the report is opened again, Access retrieves data from its current record source.
• Changes made to the source data can therefore appear in the report the next time it is viewed.
• When the report is opened again, Access retrieves data from its current record source.
• Changes made to the source data can therefore appear in the report the next time it is viewed.
వివరణ:
Question 14
ప్రశ్న 14
Which Access feature is designed specifically to create printable mailing or other labels from database information?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Access provides the Labels command and Label Wizard for creating label reports.
• The wizard allows the user to select label sizes, fields and sorting arrangements.
• The resulting labels can be previewed and printed like other Access reports.
• The wizard allows the user to select label sizes, fields and sorting arrangements.
• The resulting labels can be previewed and printed like other Access reports.
వివరణ:
Question 15
ప్రశ్న 15
An existing Access report needs an additional grouping level and a different sort order. Which feature is specifically intended to manage these settings?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Group, Sort, and Total pane is used to add or modify grouping and sorting levels in a report.
• It can also provide options for totals associated with report groups.
• These settings help organize report information without changing the underlying stored records.
• It can also provide options for totals associated with report groups.
• These settings help organize report information without changing the underlying stored records.
వివరణ:
Question 16
ప్రశ్న 16
Which statement correctly distinguishes the four major Access objects: table, query, form and report?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Tables are the main objects in which database records are stored.
• Queries retrieve or process selected data, while forms provide user interfaces for viewing or entering data.
• Reports are primarily used to organize, format and summarize data for presentation or printing.
• Queries retrieve or process selected data, while forms provide user interfaces for viewing or entering data.
• Reports are primarily used to organize, format and summarize data for presentation or printing.
వివరణ:
Question 17
ప్రశ్న 17
An Employees table contains 10,000 records, but a report should show only employees whose Department is "Forensics". Which design approach is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A query can restrict the source data to records satisfying Department = "Forensics".
• The query can then serve as the report's Record Source so that the report receives only the required records.
• Deleting unrelated records would incorrectly modify the underlying database data.
• The query can then serve as the report's Record Source so that the report receives only the required records.
• Deleting unrelated records would incorrectly modify the underlying database data.
వివరణ:
Question 18
ప్రశ్న 18
Assertion (A): A form is generally more suitable than a report for routine user-friendly record entry and editing.
Reason (R): Reports are primarily designed to view, format, summarize and present information rather than serve as the normal interface for entering records.
Choose the correct answer.
Reason (R): Reports are primarily designed to view, format, summarize and present information rather than serve as the normal interface for entering records.
Choose the correct answer.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Forms are commonly designed as user-friendly interfaces for viewing, entering and editing database records.
• Reports are primarily output-oriented objects for presenting, formatting and summarizing information.
• Both statements are true, and the Reason correctly explains why forms are generally preferred for routine data entry.
• Reports are primarily output-oriented objects for presenting, formatting and summarizing information.
• Both statements are true, and the Reason correctly explains why forms are generally preferred for routine data entry.
వివరణ:
Question 19
ప్రశ్న 19
Consider the following statements about Microsoft Access reports:
1. A report can use a table or query as its record source.
2. Report Wizard can specify grouping and sorting levels.
3. The Detail section prints only once for the entire report.
4. A saved report can display updated information from its record source when opened again.
Which statements are correct?
1. A report can use a table or query as its record source.
2. Report Wizard can specify grouping and sorting levels.
3. The Detail section prints only once for the entire report.
4. A saved report can display updated information from its record source when opened again.
Which statements are correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Statement 1 is correct because reports can obtain data from tables or queries.
• Statements 2 and 4 are also correct: Report Wizard supports grouping and sorting, and reports can display current source data when reopened.
• Statement 3 is false because the Detail section normally prints once for every row in the record source.
• Statements 2 and 4 are also correct: Report Wizard supports grouping and sorting, and reports can display current source data when reopened.
• Statement 3 is false because the Detail section normally prints once for every row in the record source.
వివరణ:
Question 20
ప్రశ్న 20
Match List I with List II:
List I
(a) Report tool
(b) Report Wizard
(c) Blank Report
(d) Report Design
List II
1. Opens a blank report in Design view
2. Creates a simple report immediately from the selected source and displays it in Layout view
3. Opens a blank report in Layout view with the Field List available
4. Guides the user through fields, grouping, sorting and layout choices
Choose the correct matching code.
List I
(a) Report tool
(b) Report Wizard
(c) Blank Report
(d) Report Design
List II
1. Opens a blank report in Design view
2. Creates a simple report immediately from the selected source and displays it in Layout view
3. Opens a blank report in Layout view with the Field List available
4. Guides the user through fields, grouping, sorting and layout choices
Choose the correct matching code.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Report tool immediately creates a simple report from the selected source, giving (a)-2.
• Report Wizard provides guided field, grouping, sorting and layout choices, giving (b)-4.
• Blank Report opens in Layout view with the Field List, giving (c)-3, while Report Design opens a blank report in Design view, giving (d)-1.
• Report Wizard provides guided field, grouping, sorting and layout choices, giving (b)-4.
• Blank Report opens in Layout view with the Field List, giving (c)-3, while Report Design opens a blank report in Design view, giving (d)-1.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: D. To view, format, summarize and present database information in an organized manner సమాధానం: D.
-
Question 2 ప్రశ్న 2Answer: B. Creates a simple tabular report containing all fields from the selected table or query and displays it in Layout view సమాధానం: B.
-
Question 3 ప్రశ్న 3Answer: A. Report Wizard సమాధానం: A.
-
Question 4 ప్రశ్న 4Answer: C. Access opens a blank report in Layout view and displays the Field List so fields can be added. సమాధానం: C.
-
Question 5 ప్రశ్న 5Answer: B. Report Design సమాధానం: B.
-
Question 6 ప్రశ్న 6Answer: D. The table, query or SQL-based source that supplies the records and fields available to the report సమాధానం: D.
-
Question 7 ప్రశ్న 7Answer: C. Use a query that combines the required fields from the related tables as the report's record source. సమాధానం: C.
-
Question 8 ప్రశ్న 8Answer: A. Detail section సమాధానం: A.
-
Question 9 ప్రశ్న 9Answer: A. Report Footer సమాధానం: A.
-
Question 10 ప్రశ్న 10Answer: D. Group Footer సమాధానం: D.
-
Question 11 ప్రశ్న 11Answer: B. Page Footer సమాధానం: B.
-
Question 12 ప్రశ్న 12Answer: C. Print Preview సమాధానం: C.
-
Question 13 ప్రశ్న 13Answer: D. The report normally displays the current data from its record source, including the updated value. సమాధానం: D.
-
Question 14 ప్రశ్న 14Answer: A. Label Wizard సమాధానం: A.
-
Question 15 ప్రశ్న 15Answer: C. Group, Sort, and Total pane సమాధానం: C.
-
Question 16 ప్రశ్న 16Answer: B. Tables store data, queries retrieve or process selected data, forms provide interfaces for working with data, and reports format and summarize information for presentation. సమాధానం: B.
-
Question 17 ప్రశ్న 17Answer: A. Create a select query that returns only Department = "Forensics" records and use that query as the report's record source. సమాధానం: A.
-
Question 18 ప్రశ్న 18Answer: C. Both Assertion and Reason are true, and Reason is the correct explanation of Assertion. సమాధానం: C.
-
Question 19 ప్రశ్న 19Answer: B. 1, 2 and 4 only సమాధానం: B.
-
Question 20 ప్రశ్న 20Answer: D. (a)-2, (b)-4, (c)-3, (d)-1 సమాధానం: D.