The Crosstab query presents data more like a standard spreadsheet than a data table. They use categories in the column headers and row headers, and display aggregated information at the intersection of the two. In this movie, Adam uses the wizard to create a crosstab query that looks at the employment status of individuals across departments.
- [Voiceover] All of the queries…that we have been working with throughout this course…have been examples of select queries,…basically, queries that select and manipulate…data from our tables and presents the results…in a new, but temporary table format.…But Access also has a couple of other query types…that we can work with.…The first type I want to look at…is called a cross-tab query.…Like the select queries, the cross-tab query…pulls information from our tables…and reorganizes it.…But unlike a select query, the cross-tab query…is presented more like a standard spreadsheet,…with column headers and row headers.…Let's take a look at how a cross-tab query works.…
I want to create an alternate view of our diversity…of our employees' statuses across the departments…of the company.…Specifically, I'd like to be able to compare…the numbers of employees in each category.…We'll start a new cross-tab query…by going up to the Create tab, and going into…the query wizard.…Here, we have the option for a cross-tab query,…and we'll select it and say OK.…
- Creating a query with the wizard
- Defining query criteria
- Using comparison and wildcards in criteria
- Working with joins
- Creating parameter queries
- Using the built-in functions in Access
- Summarizing data
- Aggregating records with totals
- Working with dates
- Creating alternative queries: unmatched, crosstab, and more
- Writing queries with SQL
Skill Level Intermediate
1. Introduction to Access Queries
2. Creating Simple Select Queries
3. Creating Parameter Queries
4. Use the Built-In Functions
5. Aggregating Records with a Totals Query
6. Working with Dates in Queries
7. Understanding Program Flow Functions
8. Alternative Query Types
9. Writing Queries with Structured Query Language
Explore the basics of SQL5m 59s
10. Useful Query Tricks
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.