Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
The Report Wizard walks you through the steps of choosing which fields to print, how they're laid out, and it applies an overall theme. Let's make a report for the Sales Reps Phone List we created in an earlier lesson. Close it. Click on the Create tab and choose Report Wizard. Click on this dropdown list. You can base your report on any table or any query. Basing it on a query is ideal when you want to display fields from multiple tables. Make sure you're on Sales Reps Phone List Query.
We want all of our fields, so click on the double-arrow. Click next. The next screen asks for grouping levels. We'll use those in a future exercise. Click Next. The next window wants to know if we want to sort our records. First, we'll choose LastName, and then we'll choose FirstName. That way, it will group all of our reps with the same last name together and list them in order by first name. Click Next. Here we can choose a general layout. Columnar will run the fields down in columns.
Tabular makes it look something like a datasheet. Justified runs all the fields going across, like you were filling in a form. We're going to choose Tabular. You can then choose Portrait or Landscape. We're going to do Portrait. There's a check mark here to narrow all the fields so that they fit on one page. Sometimes this works wonders, but other times it may truncate your fields. You'll have to experiment with your data to know for sure. Click Next. Rename the report Sales Reps Phone List Report. It gives us the option of viewing the report or changing it.
We're going to leave it on Preview and click Finish. Now, right now, some of the fields are cut off, but we'll learn to fix that in future lessons. Look at the difference between this and our original query. Pretty nice! The Report Wizard makes it easy to lay out new reports based on any table or query.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 91230 Viewers
80 Video lessons · 138201 Viewers
59 Video lessons · 57029 Viewers
52 Video lessons · 70670 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.