Tips to Getting Started: This conversion database activity is a challenge problem based on an extension of the previous work done in Access. This assignment requires reviewing each of the tables within the above Access file. Your task is to create queries to answer the questions and the challenge is in selecting the proper fields. Start with reviewing your previous assignments and then consider what information you would need to answer the conversion related questions.

Getting Started with the Conversion Activity

Using the Cookie Conversion.accdb darr latabase and the Microsoft Access Guide darr, please answer the following questions by creating required queries:

What is the name of the supervisor who authorized the production $($issued baking order$)$ of Frosted Sugar Cookies with Candy Sprinkles?

What is the bill of materials $($i$.$e$.,$ the ingredient list$)$ for Snickerdoodles?

What ingredients, in what quantities, were issued to batch WJ$1?$

Which employees operated the equipment for batch WJ$1?$

What is the list price for a dozen chocolate chip cookies?

How would you determine the planned cost for a dozen chocolate chip cookies?

How would you determine the actual cost for a dozen chocolate chip cookies?

Required Submission: Upload your completed database with queries solving #$1-$ #$5$ and in the feedback box submit your answers to #$6$ and #$7.$