What must a worksheet contain to insert, modify, or delete records in Rapid Response?

• A. Only reference keys
• B. Columns defining values for each table’s key fields
• C. Only header row without any data
• D. An empty row for data entry

Answer: (B)

To insert, modify, or delete records in Rapid Response, a worksheet must contain columns that define values for each table's key fields. Key fields are essential because they uniquely identify records within a table. By providing the necessary key values, the system can locate existing records to update or delete and can also apply new records correctly. This ensures data integrity and proper association of the new or modified entries within the broader dataset.

The presence of key fields is critical not just for data manipulation but also for maintaining relationships between tables in the database. Without these key values, the system would lack the context needed to accurately manage the records in question. Thus, defining these values is fundamental for any operation involving the records.

The other answer options lack the essential elements required for proper data manipulation. For example, having only reference keys would not provide enough context for the system to effectively carry out the desired operations. An empty row for data entry would not contribute any usable data, while a header row without data does not contain the necessary information for record creation or modification.