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.

1. Create Database Relationships (Part of this assignment has been done for you, use the file available on BlackBoard under Assignments.)

Your first task is to download a Microsoft Access database and create the relationships between tables in the database in Microsoft Access that has been populated with data from the Excel spreadsheet which includes the following tables: Distribution Channel, Customer, Muesli, and Sale.

2. Create Forms to Handle Data Entry

Part 1. Create a data input form for customers that will update the customer table so new information can easily be added to the database. Use the Form Wizard and choose the Columnar format.

Attachment:- Assignment.rar