Question

Yuka wants to create a report using the Report Wizard. She will select fields from the Student table and the Contract table. She has asked that you sort the detail records in ascending order by Contract ID. This will be a(n) ____ report.

1) Summary
2) Detail
3) Grouped
4) Filtered

Answer 1

Yuka's report, which will display detailed records from two tables sorted by Contract ID, is known as a Detail report. It provides full information for each record without summarizing the data.

Step-by-step explanation:

When Yuka wants to create a report using the Report Wizard by selecting fields from the Student table and the Contract table and sorting the detail records in ascending order by Contract ID, the report she is aiming to create would be a Detail report. A Detail report is focused on listing all the records in a dataset, displaying information from multiple fields as specified for each record, all sorted according to a given criterion. In this instance, because each Contract ID's data will be shown in full detail, rather than being summarized or categorized, it fits the definition of a Detail report.