Buy Best DA106 Lab 2

Buy Best DA106 Lab 2

 

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 Vendor 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 of 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 the 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 the 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 the 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 the query as Lab 2-2 Step 12 Query.

 

Want Help with Lab?

While you are at IWantOnlineclasshelp.com then the process to hire for a brilliant level of services is very easy. In order to have to do my online exam-related services, you just have to fill the form available on the website of www.IWantOnlineclasshelp.com, and once after finishing up this process, all your information that contains Order-ID, name, Contact, email address, etc. will be handled by the sales experts for offering you some effective quotation. Once you settle down with the best possible quotation, you need to pay for the services, and then the management team will take better care of matching pairs of tutors and subjects. We cater to fulfill all your needs even Prior to the deadline with the best possible A or B grades in a guaranteed way regarding paying someone to take my exam query. You can surely spend some leisure time with your loved ones, take care of the different priorities you have in your life and leave the rest to our professional team. For custom, help email us at [email protected] or WhatsApp us at +1(657)366-7486

Placeholder $3.99
Buy Best DA106 Lab 2
  • 200+ Downloads
  • 8k Views