Note: In case if your problem statement is updated, please donot hesitate us and send it to us at [email protected] We would surely like to help you in this regard.
Lab 2: Querying the Walburg Energy Alternatives Database
1. Open the Walburg Energy Alternatives database and create a query that includes all fields and all records in the Item table. There should be only one column in the design grid. Name the query Lab 2-2 Step 1 Query.
2. Create a query that includes the Item Number, Description, Cost, and Vender Code fields for all items where the vendor code is JM. Save the query as Lab 2-2 Step 2 Query.
3. Create a query that includes the Item Number and Description fields for all items where the description starts with the letters, En. Save the query as Lab 2-2 Step 3 Query.
4. Create a query that includes the Item Number and Description fields for all items with a cost less than $4.00. Save the query as Lab 2-2 Step 4 Query.
5. Create a query that includes the Item Number and Description fields for all items with a selling price greater than $20.00. Save the query as Lab 2-2 Step 5 Query.
6. Create a query that includes all fields for all items with a vendor code of AS and where the number on hand is fewer than 10. Save the query as Lab 2-2 Step 6 Query.
7. Create a query that includes all fields for all items that have a selling price greater than $10.00 or a vendor code of JM. Save the query as Lab 2-2 Step 7 Query.
8. Join the Vendor table and the Item table. Include the Vendor Code and Vendor Name fields from the Vendor table and the Item Number, Description, On Hand, and Cost fields from the Item table. Sort the data records in ascending order by item number within vendor code. Save the query as Vendor-Item Query.
9. Create a form that uses the Vendor-Item Query.
Form title: Vendor-Item Query
Fields (or maybe they are called form labels, not sure):
Vendor Code
Vendor Name
Item Number
Description
On Hand
Cost
10. Create a query that includes the Item Number, Description, On Hand, and Cost fields. Calculate the inventory value (on hand*cost) for all records in the table. Assign the alias Inventory Value to the calculated field. Change the caption for On Hand column to In Stock. Format the Inventory Value field as currency with two decimal places. Sort the records in descending order by inventory value. Save the query as Lab 2-2 Step 10 Query.
11. Create a query that calculates and displays the average cost of all items. Save query as Lab 2-2 Step 11 Query.
12. Create a query that calculates and displays the average cost of items grouped by vendor code. Save query as Lab 2-2 Step 12 Query.
* If you have any issues with the payment method, please let us know at [email protected] and that can be discussed and considered.
* Your paypal has to be pre-loaded in order to complete the purchase or otherwise please discuss it with us at [email protected].
* As soon as the payment is received through PayPal, download link of the solution will automatically be sent to the address used in Paypal.
* Please check your junk mails as the download link email might go there.
* All the contents are compressed in one zip folder.
* In case if you get stuck at any point during the payment process, please immediately contact us at [email protected] and we will fix it with you.
* We try our best to reach back to you on immediate basis. However, please expect to get a response within 8 hours from our side.
* Comments/Feedbacks are truely welcomed and there might be some incentives for you for the next lab/quiz/assignment.
* In case of any query, please donot hesitate to contact us at [email protected].
******************************************** Good Luck ***************************************************
Any personal information received will only be used to fill your order. We will not sell or redistribute your information to anyone.
We will try our best to resolve the issue and if still persists we can discuss for a refund in case its required.
Note: In case if your problem statement is updated, please donot hesitate us and send it to us at [email protected] We would surely like to help you in this regard.