From the course: Access 2016 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Getting a different look with crosstab queries
From the course: Access 2016 Essential Training
Getting a different look with crosstab queries
- Queries generally follow the rows and columns, or records and fields model for their layout. We have a slightly modified layout option available to us, called a Crosstab Query, that gives us headers along the top and side and then aggregate, or summary, data that appears in the middle. Let's put one together that takes a look at the visits to our various room options at the hotel. Now, the Crosstab Query is just a variation on a Totals Query, so we'll start there, and then convert it over to a Crosstab Query. In order to create that Totals Query, we start in the Create tab and go ahead and visit the Query Designer here. Now, I'm going to add in some information from my RoomAssignments table here, and then I also want the Rooms data, so that I can get some information about the types of beds that we have available in our rooms. Go ahead and close down the Show Table window here. And I'm going to double-click on RoomName and Bed, to add both of those columns down here into my 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
-
-
-
-
-
-
-
-
(Locked)
Using update queries6m 44s
-
(Locked)
Using make table queries3m 33s
-
(Locked)
Finding unmatched records4m 3s
-
(Locked)
Using delete queries4m 13s
-
(Locked)
Using append queries3m 50s
-
(Locked)
Creating a union query in SQL view5m 27s
-
(Locked)
Getting a different look with crosstab queries3m 19s
-
(Locked)
-
-
-
-
-
-
-