In the context of database management, specifically using the "workshopsbytype" query in design view, employ the Zoom dialog box to create a calculated field that adds 5 to the "CostPerPerson."

(a) Explain the purpose of the "workshopsbytype" query and its significance in the database.
(b) Discuss the structure of the query design view, highlighting the relevant tables and fields involved.
(c) Provide step-by-step instructions on how to access and utilize the Zoom dialog box within the query design view.
(d) Describe the process of creating a calculated field in the Zoom dialog box that adds 5 to the "CostPerPerson" field.