Consider using a crosstab query to summarize your data. In this video, learn how to create a crosstab query that uses aggregate functions to calculate data.
- [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 that's already selected. …
- Modifying the database structure
- Managing table relationships and keys
- Exporting data
- Managing records and fields
- Creating and running queries
- Configuring form controls
- Modifying form positioning
- Grouping report fields
- Formatting reports
- Taking the practice exam
Skill Level Intermediate
1. Microsoft Office Specialist (MOS) Exam Overview
2. Managing Databases
3. Create and Modify Tables
4. Create and Modify Queries
5. Modify Forms in Layout View
6. Modify Reports in Layout View
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.