In this e$-$project, you will construct a database of customer purchases for a small concession stand near $$Four Corners,$$ the point in the United States where the Utah, Colorado, Arizona, and New Mexico state lines meet. Much of the data will be imported from Excel files. Please submit the completed Access file by November $12$th$.$

$4-45.$ Open Access, and create a new database called FruitStand.

$4-46.$ Create a table called Products with the following fields:

ProductID $($The first field defaults to the name ID$,$ as the table$$s primary key. Change the name to ProductID. Leave it as autonumber and as the primary key.$)$

ProductName $($Text data type, field size $25$ characters$)$

Price $($Currency data type$)$

$4-47.$Enter the records in the following table. Note that you do not enter the ProductID; it is an autonumbering field that generates the next value. Save your work.

$4-48.$Download the Excel file Ch$04\_$FruitStand, and import the two worksheets labeled Customers and Purchases. Identify the CustomerID as the primary key for Customers, and PurchaseNumber fields as the primary key for Purchases rather than letting Access create its own primary keys.

What fields are contained in the Customers table? Generate a list of all your customers, sorted by CustomerID.

What fields are contained in the Purchases table? What are the foreign key$($s$)$ in the Purchases table, and which table$($s$)$ do they reference?

$4-49.$Use Access to Create Query $($Query Design$),$ join Customers to Purchases $($on CustomerID$)$ and Purchases to Products $($on ProductID$),$ and answer the following questions:

a$.$Create a query that returns all the purchases from customers from Nevada $($NV$).$ Which fruit do people from that state seem to prefer?

b$.$How many pears have been sold? $($Click on Totals in the Design Ribbon to bring up options to report grouped totals. Your query should Group By ProductName. Include the Quantity field, and in the Total row, select Sum for Quantity.$)$

c$.$How many watermelons have been sold?

d$.$List all the states your customers come from and the number of customers from each state. $($Use COUNT under the CustomerID field from Customers.$)$ From which state do most of your cust