Create a report from scratch

Creating a report by dragging fields

If you don't like the results you get with the Report tool, you can use Layout view to build a report manually, a process that gives you more control. You drag fields from a list, arrange them to your liking, and group them.

On the Create tab, in the Reports group, click Blank Report. Access creates a blank report and displays the Field List task pane.

In the Field List task pane, open the table you want to use as a data source, then drag fields to the report. Access automatically uses the tabular layout.

If you want to use a different layout, highlight the fields in the report by clicking the Layout Selector, the cross in the upper-left corner of the layout, and then...

On the Arrange tab, in the Table group, click Stacked. Access rearranges the fields.

If that seems a bit complex, don't worry. You'll get a chance to try this during the practice.

Topic 6 of 10

Previous | Next

(Back to Start)

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.