Access Reports

This video below explains how to create Access reports. The tutorial is a part seven of a series. If you are interested in completing a Microsoft Access classroom based courses, details can be found by clicking here. If you would like an online course click here

Access reports in design mode

There are several ways to create an Access report, the temptation is to use one of the automated options but in my experience that may be unwise. The wizard often creates a report with truncated text and field boxes, you will have go into design to fix this issue.

Using report design as your first option enables you to get a better understanding on how reports in Microsoft Access work. You first attach the table or query required then add the grouping options if any. You can start to add your fields and position them as required. It may take a little bit longer to finish but once you have, the end product will be far better.

Print Preview

In Microsoft Access report design mode you can select how you want your records to be displayed. They can be shown altogether as the wizard creates or you could select the one record per page option. First select the details bar in design mode, then right click into properties. Once in properties, select force page break after section.

Leave a Reply

You must be logged in to post a comment.


“Steve delivered a number of Microsoft Office Training Sessions to a range of employees across Newcastle College. The service provided by Steve is second to none. I have no hesitations in recommending him to other employers.”

Christine Jackman
Learning Manager(North) - Winner of Training Programme of the Year NECCA

“Steve’s background in IT training clearly provided him with great organisational and managerial skills which he put to good use at Second Chance Enterprises. His ability to see the long term strategy as well as manage the day to day management is one of his biggest strengths.”

Chriss Graham
Project Coordinator at Daisy Group

“The course was really thorough and Steve was very knowledgeable and explained things very well. I’ve not used Microsoft Project before but now I feel very confident that I’ll be able to use it for what I need to do in my job”.

Craig Forster
Estimator, John F Hunt Regeneration Ltd

“I studied with Steve when we completed our CiPD CTP together. During the course I found Steve to be very personable and also very professional.  Steve was first on my list of suppliers. Steve was very competitively priced and very accommodating.”

Simon Snowdon
European Training Manager at HP Enterprise Services