Business Scenario
Your muesli company has been using Excel to track customer orders. They are having difficulty analyzing the data and producing meaningful reports. They have asked you to implement an Access database so they can add, modify and delete data as well as generate queries and reports based on the information contained in the database. Part of the work has already been done for you and the data from Excel was transferred into Access database.
Your muesli company sells different types of muesli which are stored in the table Muesli in your database. Your customers are many different small and large grocery stores. Muesli is sold through three different distribution channels: channel 10 - Hypermarkets (i.e. wholesale like Costco or Sams Club); channel 12 - grocery stores (i.e. supermarkets like Publix); and channel 14 - independent grocers (small grocery stores). Distribution channel types are stored in the Distribution Channel table and your company's customers are stored in Customer table. For every sale transaction the customer, muesli type as well as price and quantity are recorded in table Sale.
Attachment:- database assignment.rar