Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
When you have a lot of data, you can group repeated info to make the report easier to read and understand. Open up our Order Totals query. This is a query we made earlier, showing our orders and a calculation of the Total amount for every Order. Let's turn it into a Report, so that it's easy to read. Click once on Order Totals under our Queries. Click on the Create Ribbon, and on Report. It opens up a formatted report. So far so good. Now notice how all of our companies are grouped, but also repeated.
On the Report Layout tools Design tab, click here on the Group & Sort button. At the bottom of your screen, a Group, Sort, and Total area will appear. Click on Add a Group, and click on Company. A new subheading will appear with the Orders below. The Company has been removed from every row, immediately making the data more understandable. Click on All Kinds of Taste, and drag the right-hand border so that it is smaller. I notice that my dates are not chronological.
At the bottom, click on Add a sort and choose OrderDate. I can sort both of these. Click on Company, and I can change it from A to Z, or if I wished, Z to A. I can click on OrderDate here is where I can change it from oldest to newest, to newest to oldest. Now click on the More button, and sometimes I like to change "do not group together on one page" to "keep whole group together on one page" so that it doesn't cut off a Group in the middle.
Let's click on the fields and resize them until all of our fields fit on the page. Make OrderDate a little smaller, make Product a lot smaller, Size, Price, Quantity, that's too short, Last Name and Total. Now all the fields fit on one page. Go up to the Views and toggle over to the Report view, so you can see what it looks like when it prints.
Then click over on our original Order Totals query, and we've gone from this to this. Let's Save the Report and change the name to Orders by Customer. Click OK, and we will it leave opened for the next lesson. Grouping and sorting controls helped us to reduce our a repetitious text and sort the order of our fields to make a report easier to interpret.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 91099 Viewers
80 Video lessons · 138153 Viewers
59 Video lessons · 56967 Viewers
52 Video lessons · 70601 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.