From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)

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 2016 Microsoft Office Specialist (77-730)

Start my 1-month free trial

Create a crosstab query

“

- [Instructor] When you want to arrange your query results to make it easier to read and understand, a crosstab query is a great option. When you're creating your crosstab query, you choose the field that you want to show as the row result. You also choose the column field and what data you want summarized. The layout of a crosstab query is very similar to an Excel worksheet, so if you haven't used this before, I'm anxious to show it to you because I have a feeling it's something you're going to want to start using frequently. Let's take a look at our O Four O Two Crosstab Query database. And I want to go ahead and focus on the 2016 Sales table. To create a crosstab query, you can use the Query Wizard. So on the Create tab I'll click Query Wizard and it's one of the options available to you in the New Query window. Crosstab Query Wizard, go ahead and click OK. As I mentioned, I'd like to use the 2016 Sales table. What we see in the window up above are the three tables in our database.…

Contents