Please Build Database and Static Queries. MY LAST NAME STARTS WITH R$,$ SO MY INDUSTRY IS APPLIANCES. Two of the images are the instruction for this project and one image is the assignment $2$ that I completed before this project, which you have to use for reference for this project. PLEASE READ THE INSTRUCTION, THERE SHOULD BE $6$ STEPS TO COMEPPlease Build Database and Static Queries. MY LAST NAME STARTS WITH R$,$ SO MY INDUSTRY IS APPLIANCES. Two of the images are the instruction for this project and one image is the assignment $2$ that I completed before this project, which you have to use for reference for this project. PLEASE READ THE INSTRUCTION, THERE SHOULD BE $6$ STEPS TO COMEPLETE. THANK YOU SO MUCH. ACCT $361$ Accounting Analytics $-$ Spring $2024$

$6.($Access$)$ Create static queries to summarize the results of transactions executed:

$-$ Total Sales in Dollars by Customer:

$-$ Fields: Customer Name, Count of Sales, Total Sales $(\backslash$$$)$

$-$ Sort: Alphabetically by Customer Last Name $($or simply by Customer Name if you do not have First and Last Name fields separately$)$

$-$ Gross Profit in Dollars by Inventory Item

$-$ Fields: Item $\backslash$#$,$ Item Description, Total Quantity Sold, Total Gross Profit

$-$ Sort: High to Low by Total Gross Profit

$-$ EQOH $($Ending Quantity on Hand$)$ Report

$-$ Fields: Item $\backslash$#$,$ Item Description, Count of Items on Hand, Value of Items on Hand

$-$ Sort: High to Low by Value of Items on Hand

$-$ Unshipped Inventory Report

$-$ Fields: Order $\backslash$#$,$ Item Description, Quantity Unshipped

$-$ Sort: High to Low by Order $\backslash$#

$-$ Detailed Sales Report for Visualization

$-$ Fields: Ship $\backslash$#$,$ Ship Date, Order $\backslash$#$,$ Order Date, Customer $\backslash$#$,$ Customer Name, Street Address, Customer City, Customer State, Customer Zip, Customer Phone $\backslash$#$,$ Customer Segment, Sales Clerk $\backslash$#$,$ Sales Clerk Name, Ship Clerk $\backslash$#$,$ Ship Clerk Name, Total Inventory Cost for Order, Total Gross Profit for Order, SH Fee, Invoice Total

ACCT $361$ Accounting Analytics

Submission Required at Time of Completion:

$1.$ For the submission link provided in the AIS Project tab on Blackboard:

a$.$ The Logical Model of your company in PDF with the file name: "YourLastName$\_$FirstName$\_$Spring$24\_$LM$.$pdf$"$

b$.$ Your completed and populated project Access database with the file name: "YourLastName$\_$FirstName$\_$Spring$24\_$DB$.$accdb"

Grading Rubric $($Based on $100$ Points$)$: Solution for

Assignment $\backslash$#$2-$ Converting from the REA Model to the Logical Model

Master Tables

tblInventoryItems: Item$\backslash$#$,$ Item Description, Price, BQOH, BQOH Date, Standard Cost, $[$example for the extra field: "Reorder Point" or "Maximum Storage in Days" etc.$]$

tblSalesClerk: SalesClerk$\backslash$#$,$ Sales Clerk Name, Sales Clerk, SSN$\backslash$#

tblShipClerk: ShipClerk$\backslash$#$,$ Ship Clerk Name, Ship Clerk SSN$\backslash$#

tblCustomer: Customer$\backslash$#$,$ Customer Name, Customer Street Address, Customer City, Customer State, Customer Zip, Customer Phone $\backslash$#$,$ Customer Segment, $[$example for the extra field: "Loyalty Card Membership" or "Privileged Customer" etc.$]$

Event Tables

tblOrder: $\backslash (\backslash$underline$\{\backslash$text $\{$ Order$\backslash$#$,[$SalesClerk$\backslash$#$],[$Cust$\backslash$#$],$ Order Date $\}\}\backslash )$

tblOrder$/$InventoryItems: $[$Order$\backslash$#$],[$Item$\backslash$#$],$ Qty Sold $($Note: If you only underlined the primary key, or only put in brackets, it is okay for the linking tables.$)$ tblShip: Shipment$\backslash$#$,[$Order$\backslash$#$],[$Cust$\backslash$#$],[$ShipClerk$\backslash$#$],$ Shipment Date, SH Fee

tblShip$/$InventoryItems: $[$Shipment$\backslash$#$]$Item$\backslash$#$],$ Qty Shipped $($Note: If you only underlined the primary key, or only put in brackets, it is okay for the linking tables.$)$