From the course: Access 2019 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
The Report Wizard
- [Instructor] In the check-in details 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 check-in date which is a logical way to view this information, but it's not the only way. What if I wanted to see all of the details for each guest? For instance, I wanted to see Anna Cunningham, followed by her entire check-in history, and then Carl Garza, followed by all of his check-in history. 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. Let's create another report based off of the check-in details query, but this time, we're going to make use of the wizard. First, I'll go ahead and close out of this report and then I'll come over here to the Create tab, and in the report's group, click on Report Wizard. Now we've seen this interface several times now. The first step…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
(Locked)
Introducing reports3m 27s
-
(Locked)
The Report Wizard4m 37s
-
(Locked)
Edit a report in Design view6m 3s
-
(Locked)
Edit a report in Layout view5m 11s
-
(Locked)
Group and sort records5m 35s
-
(Locked)
Creating calculated totals2m 59s
-
(Locked)
Apply conditional formatting rules6m 2s
-
(Locked)
Create labels3m 31s
-
(Locked)
Adjust print settings3m 38s
-
(Locked)
-
-