Learn how to create a crosstab query using the Query Wizard. Author Jen McBee will demonstrate the process and talk about the differences between simple select queries and crosstab queries.
- [Instructor] If you want to change your query results…to something other than a data sheet view…so it's easier to read and understand,…a crosstab query is a great option.…What this will remind you of is an Excel worksheet,…because you have row headings…and you have column headings,…and then your data is in the middle.…You're also going to think of pivot tables…when you're working with crosstab queries.…On the Access 2010 MOS exam,…you may be asked to create a crosstab query.…And we'll see how we can use the query wizard…to get the desired results.…
It's a little faster if you use the wizard.…I have the 05_03 exercise file open,…so if you're ready, let's create a crosstab query.…We're going to focus on the orders table…on our create tab.…We'll go to query wizard.…You may remember that crosstab query…was the second option in our wizard,…so we'll select that and click okay.…The very first step in the wizard…is to choose the table that you want to use…for your crosstab query.…
We're going to use orders.…Notice that you can use tables, queries, or both.…
- Creating a new Access database
- Applying application parts
- Backing up a database
- Creating new tables and fields
- Sorting and filtering records
- Setting primary keys
- Importing data
- Creating basic forms
- Creating Access queries, including crosstab and multitable queries
- Creating Access reports
Skill Level Intermediate
1. Microsoft Office Specialist Exam Overview
Prepare for the exam2m 18s
2. Managing the Access Environment
3. Building Tables
4. Create Forms
5. Create and Manage Queries
6. Create Reports
7. Final Practice Exam
- 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.