Explain the process of creating a report using the Report Wizard.

Question

What will be an ideal response?

Answer 1

?Answers will vary. When you create a report with the Report Wizard, you first choose the table or query on which to base the report and then select the fields you want to include in the report. You can select fields from more than one table as long as the tables are related.In the Report Wizard, the second dialog box lets you choose whether to show the data in the report grouped by table or ungrouped. A grouped report places the data from the first table in one group followed by the related records.Whether the report is grouped or ungrouped, the next dialog box in the Report Wizard lets you select grouping levels to add to the report. Grouping levels are useful for reports with multiple levels, such as those containing monthly, quarterly, and annual totals, or for those containing city and country groups.The next dialog box that appears lets you choose the sort order for the detail records. You can sort the detail records for the report by up to four fields, choosing ascending or descending order for each field.In the next dialog box, you select a layout and the page orientation for the report. Please see the section "Creating a Report Using the Report Wizard" for more information.