Which button is used to set the 'ClassSchedule' query as the report's record source?

Which button is used to set the 'ClassSchedule' query as the report's record source?

• A. 'Design View Button'
• B. 'Property Sheet Button'
• C. 'Record Source Button'
• D. 'Tools Button'

Answer: (B)

The appropriate choice for designating the 'ClassSchedule' query as the report's record source involves utilizing the Property Sheet. The Property Sheet provides a detailed interface where various attributes of the report can be configured, including the record source. When you access the Property Sheet, you can directly specify which query or table should serve as the data source for the report being created or modified. This ability to set the record source within the Property Sheet is fundamental to designing effective reports that reflect the desired data from your database queries. Other options, such as the Design View Button, would allow you to adjust the layout of the report but does not specifically facilitate changing the record source. The Record Source Button, while it seems intuitive, does not exist as a standalone tool in typical report design workflows in Access. Meanwhile, the Tools Button usually offers additional functionalities but does not directly handle record source assignment. Hence, utilizing the Property Sheet ensures that you can accurately set and manage the report's data source as needed.

The appropriate choice for designating the 'ClassSchedule' query as the report's record source involves utilizing the Property Sheet. The Property Sheet provides a detailed interface where various attributes of the report can be configured, including the record source. When you access the Property Sheet, you can directly specify which query or table should serve as the data source for the report being created or modified. This ability to set the record source within the Property Sheet is fundamental to designing effective reports that reflect the desired data from your database queries.

Other options, such as the Design View Button, would allow you to adjust the layout of the report but does not specifically facilitate changing the record source. The Record Source Button, while it seems intuitive, does not exist as a standalone tool in typical report design workflows in Access. Meanwhile, the Tools Button usually offers additional functionalities but does not directly handle record source assignment. Hence, utilizing the Property Sheet ensures that you can accurately set and manage the report's data source as needed.