Download file LFMNNNN_ITM2500_EX02_Northwinds.accdb from the assignment link on Blackboard. Immediately save the file and rename it replacing LFMNNNN with your own initials and last four digits of your student ID.
For any query which requires more than two tables, you must use an approach using sub queries that combine no more than 2 tables or queries at a time (as demonstrated in class). All subqueries must begin with the same prefix as the main query (e.g. LFM_Q01_A, LFM_Q01_B etc)
| Name | Description |
| LFM_Q01_SortedCustList | List CompanyName, ContactName and Phone in ascending sorted order by CompanyName |
| LFM_Q02_NetByProductName | List ProductName, Net Sale Amount (Quantity * Price ) minus dollar discount amount, in descending sorted order by Net Sale Amount |
| LFM_Q03_CountOrdDetByCgy | Count the number of items found in the OrderDetail table, summarized by category, listed in ascending sorted order by CategoryName |
| LFM_Q04_SalesByEmployee | List Employee Last Name, Employee First Name, Category Name and Sum Of Gross Sales, by Category within Employee, sorted first in ascending order by employee last name, and within employee, descending order by Sum of Gross Sales |
| LFM_Q05_UserProductSummary | Allow the user to enter a product ID and list the corresponding ProductName and summarized Gross Sales (Quantity * Price) for that product. Note - no example is included in the attached (it depends on what product you choose) Hint you must use a parameter for this query to work. |