1. Technology
Send to a Friend via Email

Video:Microsoft Access: How to Create Reports

with Nick Flegg

Navigating Microsoft Office can seem complicated, but it's a great way to organize your information in easy templates. In this About.com video, learn how to create a new report in Microsoft Access 2010 with this step-by-step guide.See Transcript

  • All Videos
  • All Technology Videos
  • Databases Videos

Transcript:Microsoft Access: How to Create Reports

Hi, I'm Nick and today for About.com, I'm going to show you how to create a new report in Microsoft Access 2010.

Reports are a great way to organise your data into easy-to-understand templates, without losing any information.

Step 1: Create a New Report in Microsoft Access

To create a new report, open the database containing your data and then select the element you wish to convert into a report. You can quickly create a basic report by heading to the Create menu in the ribbon and selecting the 'Report' button. 

If you need to have more customization over the creation of your report, reselect your original data and then head back to the Create menu. From here, choose the 'Report Wizard' option and a new window will open, which will allow you to customize your new report.

Step 2: Add or Remove Fields in Microsoft Access

The first page of the report wizard allows you to add the fields you would like to add to your report. If you need to add fields from multiple tables, you can switch between them by using the drop down menu. Add or remove fields by selecting them and pressing the arrow button, until all of the desired fields are in the 'Selected Fields' box.

The next page allows you to add grouping to your reports. If you need to customize your grouping preferences, click on the 'Grouping Options' button and you'll have access to more details, such as date intervals. Grouping isn't mandatory, so feel free to click the 'Next' button if you want to leave this step blank.

Step 3: Change the Style of Your Report in Microsoft Access

The Report Wizard also allows you to organise the order of your report. To change the order, simply place your fields in order of priority.

You can also change the style of your report by deciding which layout you would like to use and whether you want the orientation to be portrait or landscape.

Finally, give your report a name and then click the 'Finish' button to view it in action!

Now you know how to create a new report in Microsoft Access 2010. For more help with Access, including how to create forms, be sure to visit About.com.

About videos are made available on an "as is" basis, subject to the User Agreement.

©2014 About.com. All rights reserved.