From the course: Access Essential Training (Office 365/Microsoft)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Report Wizard

Report Wizard

From the course: Access Essential Training (Office 365/Microsoft)

Start my 1-month free trial

Report Wizard

“

- [Instructor] In the CheckInDetails report that we just created, Access placed a single line for each record that was coming out of the original query. It's currently sorted chronologically based off of the CheckInDate, which is a logical way to store this information, but it's not the only way. What if I wanted to see all the details for each guest? For instance, I wanted to see Anna Cunningham, followed by all of her CheckIn details, and then Carl Garza and all of his. We can get more control over the layout of our report by allowing the Report Wizard to walk us through the process of collecting and organizing our data. So let's create another report based off of the CheckInDetails query, but this time we'll make use of the Wizard. Now we're actually going to overwrite this CheckInDetails report that we just created, so let's go ahead and make sure that it's closed. Then, we'll come out to the Create tab, and in the Reports group, click on Report Wizard. Now we've seen this…

Contents