From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create a crosstab query

Create a crosstab query

From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365

Start my 1-month free trial

Create a crosstab query

“

- [Instructor] You may want to consider using a crosstab query to summarize your data to make it easier to read and understand. Crosstab queries can calculate a sum average or other aggregate function, and will group the results using two sets of value. It's a lot like Excel, where one of the values will be on the down side, or the rows of the datasheet, and the other set of volumes will be across the top or in the columns. Let's jump in to our crosstab database, and create some crosstab queries. We use our employee data table, let's take a look at the information in there. We have department, employees names and ID number, the date they were hired, the current benefit, benefit cost and their hourly rate. I'll close this table. Go to Create, and we're going to use the query wizard to create our crosstab queries. It's the second option in the first window. We'll click OK. We only have the one table, so you'll see…

Contents