How to Create a Microsoft Access Report for Weekly Class or Room Schedules
Question details
The user needs to build a Microsoft Access report that displays class or room schedules in a weekly grid, using structured schedule data and workarounds because Access no longer has a built-in calendar report.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- The user manages course, instructor, room, weekday, and time data in Access and wants a printable weekly class or room schedule.
- Observed behavior
- Microsoft Access does not provide a current built-in calendar report for weekly class or room schedules, so a crosstab query, custom report, or grouped query is required.
Before you start, confirm that your Access table stores weekday, start time, end time, room, course, and instructor in separate fields. These fields are required for crosstab grouping, column layout, and calendar-style reporting.
Create a Weekday-by-Time Crosstab Query Report in Microsoft Access
Use this when you want a grid-style report with weekdays as columns, time periods as rows, and class or room details in the cells.
Crosstab queries transform normalized schedule records into a matrix. In Access, set Weekday as the column heading, StartTime as the row heading, and Course or Room as the value. The resulting query can be used directly as a report data source.
In Microsoft Access, open your database and click Create > Query Design. Add the table or query that contains your schedule fields.
Double-click Weekday, StartTime, Room, Course, and Instructor in the field list so they appear in the query grid.
On the Query Design tab, click Crosstab in the Query Type group.
In the Crosstab row of the query grid, set Weekday to Column Heading, StartTime to Row Heading, and Room or Course to Value with Group By or First.
Click Run to preview the grid. Save the query, then select Create > Report Wizard and choose the saved crosstab query to build a printable schedule report.

Build a Custom Calendar-Style Report with Subreports
Use this for a more flexible Microsoft Access layout when a crosstab query does not give the visual weekly calendar design you need.
Summarize Room or Instructor Usage with a Grouped Query
Use this when you mainly need to check room occupancy, instructor load, or potential conflicts rather than print a calendar grid.
Use WPS Office as a Free Alternative for Weekly Class and Room Schedule Files
Microsoft Access does not include the old calendar report, and WPS Office does not provide an Access database replacement. For many schedule tasks, WPS Office free Writer and Spreadsheet apps can open, edit, and share .xlsx or .docx schedule templates, build printable weekly grids, and keep familiar Microsoft Office formatting without Access.
- 1. Download WPS Office: Go to the official WPS Office download page and install WPS Office on your device.
- 2. Open a schedule template or workbook: Launch WPS Spreadsheet, search for a weekly schedule or class schedule template, or open your existing .xlsx schedule file.
- 3. Edit and save the schedule grid: Adjust weekday columns, time slots, rooms, or instructor names in the grid, then save the file in .xlsx or .docx format for sharing or printing.

Frequently Asked Questions
Does Microsoft Access still have a built-in Calendar report?
No. The Calendar report was deprecated after Access 2010. You can create a weekly schedule view with a crosstab query or a custom report instead.
How do I show weekdays as columns and time slots as rows in Access?
Create a crosstab query and set Weekday as the Column Heading, StartTime as the Row Heading, and Room or Course as the Value.
Can I edit schedule data directly in a crosstab query?
No. Crosstab queries are read-only because they aggregate records. Use your original table or a separate form or query for data entry.
What is the fastest way to find room booking conflicts in Access?
Create a Totals query grouped by Room, Weekday, and StartTime, and count Instructor or Course. Any group with more than one booking indicates a conflict.
Does WPS Office have an Access replacement?
No. WPS Office does not include a database application like Access, but you can use WPS Spreadsheet or Writer to create and share weekly class or room schedule files in .xlsx or .docx format.




