From the course: Access Essential Training (Office 365/Microsoft)
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Obtain summary statistics
From the course: Access Essential Training (Office 365/Microsoft)
Obtain summary statistics
- [Instructor] Once you've gathered a number of records with a query, you can then tell Access to provide some summary statistics about those records. This is called a totals query. Let's see how we can use one to gain some insight into the performance of the Landon Hotel from month to month. We'll start by creating a new query in Design view. Now, I wanna find out how many guests that a hotel had for each month that we have data on. To find this out, we need to first collect some raw data, and we can find that in the "RoomAssignments" table. Let's go ahead and close the Show Table window. We'll need the check-in date column to know the day that the guest checked into the hotel. I'll also grab the "AssignmentID" column, which is at the bottom. This'll help us count up how many check-ins occurred on each day and month, in just a moment. For this query, we're not concerned with who visited the hotel, so we don't need to pull in the guest table at all, If I go ahead and run this query…
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
-
-
-
-
-
-
-
What are queries?3m 2s
-
Simple Query Wizard4m 19s
-
Build queries in Design view6m 18s
-
Establish constraints with criteria4m 30s
-
Specify criteria with wildcards3m 47s
-
Incorporate AND and OR statements6m 1s
-
Filter with mathematical comparisons3m 26s
-
Create flexible queries with parameters3m 53s
-
Build expressions5m 33s
-
Obtain summary statistics7m 29s
-
-
-
-
-