From the course: Office 365: Access Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Using the Report Wizard - Microsoft Access Tutorial
From the course: Office 365: Access Essential Training
Using the Report Wizard
- In the last movie, we created this CheckInDetails report. Let's go ahead and double click on it open it up. One of the things about this report that Access just created is that Access placed a single line for each record that was coming out of the original query. It's currently sorted chronologically by CheckInDate, which is a logical way to organize this information, but it's not really the only way. What if I wanted to see the details for each guest? For instance, what if I wanted to see Anna Cunningham and all of her check-in dates, and then Carl Garza and then all of his check-in dates? We could go ahead and organize our report that way, and we can start doing so with the Wizard. Let's go ahead and close this report down, and I'm going to start a new report here by going to the Create tab. And then in the Report section, I'm going to choose the Report Wizard option. That will start up the Report Wizard, and you've seen this several times at this point. This is just building a…
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 reports4m 19s
-
(Locked)
Using the Report Wizard4m 53s
-
(Locked)
Creating a report in Design view4m 38s
-
(Locked)
Editing a report in Layout view7m 51s
-
(Locked)
Grouping and sorting records7m 7s
-
(Locked)
Creating calculated totals3m 52s
-
(Locked)
Applying conditional formatting rules7m 36s
-
(Locked)
Creating labels5m 21s
-
(Locked)
Adjusting print settings4m 6s
-
(Locked)
Challenge: Creating reports33s
-
(Locked)
Solution: Creating reports5m 29s
-
(Locked)
-
-
-
-