Case-Based Critical Thinking Questions Case 4-2
Carmen and Sergio have created a database for the Spring Fling event at their college. Sergio created forms for Carmen to use when entering data into the database. Carmen needs to create some reports to update the faculty sponsor on the progress that has been made planning the event. The tables and fields for the database along with established relationships are illustrated in the figure below.

The faculty sponsor has asked Carmen to email all participants with a balance greater than zero and remind those participants of the due date for payment. Carmen wants to generate a report with participant email addresses only for those participants with a balance greater than zero. Which method would be best for Carmen to use to generate the report?
A) create a form and base the report on the form
B) create a report with all participants and manually highlight those with a balance greater than zero
C) create a report with only the balance field included
D) create a query using a criterion for the balance then create a report based on the query

Question

Case-Based Critical Thinking Questions Case 4-2
Carmen and Sergio have created a database for the Spring Fling event at their college.  Sergio created forms for Carmen to use when entering data into the database. Carmen needs to create some reports to update the faculty sponsor on the progress that has been made planning the event.  The tables and fields for the database along with established relationships are illustrated in the figure below.

The faculty sponsor has asked Carmen to email all participants with a balance greater than zero and remind those participants of the due date for payment. Carmen wants to generate a report with participant email addresses only for those participants with a balance greater than zero.  Which method would be best for Carmen to use to generate the report?
A) create a form and base the report on the form 
B) create a report with all participants and manually highlight those with a balance greater than zero 
C) create a report with only the balance field included 
D) create a query using a criterion for the balance then create a report based on the query

Quizplus · Accepted Answer

Creating a query with a criterion for the balance field would allow for the selection of only participants with a balance greater than zero. This would make it easier for Carmen to generate a report with participant email addresses only for those participants with a balance greater than zero. A form or report without a specified criterion would include all participants, including those with a zero or negative balance, requiring Carmen to manually highlight the participants with a balance greater than zero. Including only the balance field in a report would not provide the necessary information to identify the participant's email address.