Assignment Instructions
The Report tool is very similar to the Form tool. If you select what you want in a report, in this case, Query5A, and then click on the Report button, it will create a report based on that query. You can go into Design View to change the labels. Like with the Form Tool, leave the ones that are white and opaque alone; edit the ones that are transparent. For the Report Wizard, you want to click on Query4C. That will default the selected query in the drop down to Query4C. Use the >> symbol to move all of the fields over. The directions will walk you through what to do for each of the next steps.
Assignment Files
Submissions
You must submit your completed file(s) through the CS101 Submit Assignments tool.
Due Date
This assignment is due on Thursday, April 3, 2025. For on-campus sections, it is due by the end of class. For online sections, it is due by 11:59:59 PM Eastern Time. Late work will not be accepted.
Grades
This assignment is worth 8 points. A grading rubric is provided at the end of the assignment instructions. Over the entire semester, students must complete at least 20 Participation Projects to earn a maximum of 160 points.
Help & Resources
Video
This video is also available on YouTube [1].
Associated Learning Objectives
This assignment covers the following course and unit learning objectives:
| Number | Learning Objective |
| C02 | Design and construct databases to store, extract, and analyze scientific and real world data. |
| C05 | Identify, access, and evaluate information to solve real world problems. |
| C02.AC02 | Create and manage databases and their data. |
| C02.AC05 | Use forms and reports to facilitate access to data. |
| C05.AC06 | Interpret and analyze database query results to perform calculations and answer questions. |
| C05.ED01 | Locate and access data and resources necessary to solve problems. |
References
- B. M. Powell, Access: Reports Participation Project. West Virginia University, 2021. Available: https://www.youtube.com/watch?v=_RbZu-1zbcA.