Which of the following can a Report Wizard NOT do? A. Add summary functions B. Create groups C. Group fields into more than one Control Layout D. Select fields

Add summary functions
Create groups
Group fields into more than one Control Layout
Select fields

The correct answer is: C. Group fields into more than one Control Layout

A Report Wizard is a tool that helps you create reports in Microsoft Access. It guides you through the process of selecting the data you want to include in your report, choosing the layout and style of your report, and adding any necessary summary functions.

A Control Layout is a way of organizing fields on a report. You can create a Control Layout by dragging and dropping fields from the Field List onto the report. You can then group fields into sections by dragging and dropping them between the section headers.

The Report Wizard can do all of the following except group fields into more than one Control Layout. This is because a Control Layout is a single unit, and you cannot add fields to more than one Control Layout at a time.

Here is a brief explanation of each option:

  • A. Add summary functions: The Report Wizard can add summary functions to your report, such as Sum, Count, and Average.
  • B. Create groups: The Report Wizard can create groups in your report, which can help you to organize your data.
  • D. Select fields: The Report Wizard can help you to select the fields you want to include in your report.