This assignment has you looking at a micro view $$ you are presented with data first and then you need to configure it to build your data model.$$ Once the data model is built make your Access database work correctly with the content to put in tables.$$ Then the queries, forms, and reports to prove that your design works.

Step $1$ is looking at the data and bringing it into Access.$$ Look at the Excel data and begin to create your own table design based on the Excel data.$$ Applying the rules of the relational model $$ every table needs to have a primary key etc.

Look at the Excel file:

$-$ We have three sheets

$-$ On the Business sheet we have BusinessNum, BusinessName, BusinessPhone, Street, City, Sate, ZipCode, OwnerName, OwnerPhone

o$$ You don$$t need to break down phone number any more $$ it doesn$$t need to be made more atomic.

$-$ On OrderInfo you have OrderNum, BusinessNum, Paid, InvoiceAmt, BillingDate

o$$ Note that not every business has an order and not every order has a business.

$-$ On Salesmen sheet it has SalesNum, SalesName, CommRate $($which is commission rate$),$ SalesRegion, State

The data on these sheets needs to be brought into Access $$ you can use the import wizard

based on the tables names and attributes listed in this assignment i need to create an SQL query to answer this question:

For all salesmen with current customers, create a list of each business $($one record per business$)$ with unpaid orders.$$ Include the following attributes: SalesNum, Salesman Full Name $($derived from Salesman L Name and Salesman F Name$),$ Business Number, Business Name, and Owner Name.