From the course: Office 365: Access Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Creating calculated totals - Microsoft Access Tutorial
From the course: Office 365: Access Essential Training
Creating calculated totals
- So far, our Checkin Analysis Report has organized and grouped the records that were gathered by our CheckIn Anaysis query. We can also add some statistical information about each group right inside of the report. This will give you some quick, grand total figures that can help in understanding the data and making comparisons across days. Let's go ahead and continue modifying the report called "CheckInAnalysis". I'll right click on it, and we'll jump straight into Layout View. Next, I'm going to click on one of these fields over here in the Total Revenue column. It doesn't matter which number you click on. They'll all do the same thing. And then, I'm going to come up here on the Design tab of the Report Layout Tools ribbon. We'll go ahead and take a look at this Totals button here. This will work like just like the totals that we saw earlier when we working with our totals queries. We had some aggregate functions, including Sum, Average, Count, Min, Max, and Standard Deviation and…
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
-
-
-
-
-
-
-
-
-
-
-
Introducing reports4m 19s
-
Using the Report Wizard4m 53s
-
Creating a report in Design view4m 38s
-
Editing a report in Layout view7m 51s
-
Grouping and sorting records7m 7s
-
Creating calculated totals3m 52s
-
Applying conditional formatting rules7m 36s
-
Creating labels5m 21s
-
Adjusting print settings4m 6s
-
Challenge: Creating reports33s
-
Solution: Creating reports5m 29s
-
-
-
-
-