Background

Forrest runs Y Not Flowers, Inc. (YNF), a wholesale flower distributor with stores in several major metropolitan areas of the U.S. He is considering expanding his business, but he thinks his current accounting and financial systems are restricting that expansion. He also worries that YNF is not adequately prepared to face expected business risks. He has come to you for assistance.

Instructions

Your supervisor met with Forrest and discussed his requirements in detail. At that meeting, they agreed on the following deliverables for your project.

Required

Develop a relational database in Microsoft Access for YNF. You will need to import Excel data into Access (See the document on Canvas Group Project 2_Importing Excel data into Access), and set relationships consistent with your data model. Then create queries to answer questions.