Module 7: Advanced Queries & Reports
Summarize data across two dimensions with crosstab queries, use action queries safely, and design reports that organize data for a reader.
What You'll Learn
- Build a crosstab query to summarize data by two dimensions at once
- Distinguish the four action query types and use them safely
- Group and sort a report, with headers, footers, and page numbering
- Place group and report totals in the correct sections
Real-World Scenario
The practice manager wants supply spending shown as departments down the side and months across the top, and last year's records moved into an archive because the active table has grown slow. Both jobs need query types that go beyond SELECT — and one of them permanently deletes data.
Lessons
Complete each lesson in order. Watch the video, review the notes, and finish the challenge.
Crosstab, Action, and Append Queries
Move beyond SELECT: summarize data in a grid, and use queries that change data rather than just returning it.
Designing Reports with Grouping and Sorting
Build reports that organize data into meaningful groups, with headers, footers, page numbering, and totals that print correctly.